deutsch

MySQL Performance – creating a virtual ramdisk for your temporary tables

1) edit /etc/fstab and insert

none /mnt/ramdisk tmpfs size=1g 0 0

2) Mount drive

mount /mnt/ramdisk

3) configure /etc/my.cnf

tmpdir = /mnt/ramdisk

This entry was posted on Monday, September 24th, 2007 at 8:35 am and is filed under SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply