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

mws’s picture

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.

Kristen Pol’s picture

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