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?


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.


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").

Blog: http://kristen.org
Drupal 7 Multilingual Sites: http://kristen.org/book