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

Databases
1

Hello,
i
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
this?

Thx

2

Hey
Take a look here: http://dev.mysql.com/doc/refman/5.7/en

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

tmpdir=/mnt/ramdrive

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

3

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