Posted by mws on February 15, 2007 at 5:30pm
I'm considering loading my comment table (200mb) onto a ramdisk to speed up read access and was wondering if anyone has had any experience with doing this. Does it really increase performance? What about reliability?
Comments
Update: My DB size is about
Update: My DB size is about 1.5 GB and I just tried expanding the MySQL RAM cache to 4GB. It does not fix the problem, making me wonder if a ramdisk is the only way to go.
RAM disk on Ubuntu
Here are instructions for setting up RAM disk for MySQL on Ubuntu. I found it helped a lot with writing to disk.
http://wolfgangziegler.net/ubuntu-11.04-simpletest-performance-upstart-m...
Caveat is that you might lose data if you don't write to disk regularly (it will write to disk when you do "mysql stop").
-Kristen
Blog: http://kristen.org
Drupal 7 Multilingual Sites: http://kristen.org/book