By mws on
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?
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
Profile: https://www.linkedin.com/in/kristenpol
Drupal 7 Multilingual Sites: http://kristen.org/book