Posted by deverman on February 5, 2009 at 12:12am
Hello I have a problem with my site when trying to use a RAM Disk to boost temp table create performance. I heard that this optimization was being done on drupal.org but couldn't find any documentation on it. I would appreciate if you could look at my post here and give me any suggestions:
Comments
+1
+1
Found a solution here:
http://drupal.org/node/369204#comment-1274786
The problem, mostly with D5,
The problem, mostly with D5, is that those temp tables use column types that mysql cannot use in memory based temp tables. Usually you set up your unix box to mount /tmp on tmpfs which is memory based. Problem however is that until mysql 5.0.48 there has been a bug with mysql not using tmpdir variable for disk based temp table creation but creating in /var/lib/mysql instead .
Ubuntu
Here are instructions for setting it up on Ubuntu:
http://wolfgangziegler.net/ubuntu-11.04-simpletest-performance-upstart-m...
Contact: https://www.hook42.com/contact
Drupal 7 Multilingual Sites: http://www.kristen.org/book
That solution is fine for
That solution is fine for testing, but should never be used in production since it moves all MySQL files to a ram disk and then copies them back when MySQL shuts down. If the server loses power, then you will lose all data added, deleted or changed since the last time MySQL started.
HollyIT - Grab the Netbeans Drupal Development Tool at GitHub.
Agreed!
I'm only planning on using it for development and creating a cron job to save the RAM data (to disk) regularly (e.g. every 15 minutes) so I won't lose much data if battery dies.
Contact: https://www.hook42.com/contact
Drupal 7 Multilingual Sites: http://www.kristen.org/book