How can i make MySQL to save its items into certain folder / partition?

think that MySQL is creating some temporary tables on the HDD and some
in RAM. I would like to use ramdisk /dev/shm to hold temporary disk
tables. How can i tell MySQL to save temporary data there? And is it
safe if there is a power outage, it is temporary tale so it should not
be big problem if its lost? Is there any tutorial on how to achieve


Take a look here:

You need to change the following directive in your my.cnf file:


You should format your RAM drive and mount it to the /mnt/ramdrive before

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.