Viewing 1 item
Archive | April 24, 2013

How to setup MySQL temp directory on RAM disk?

Follow the below mentioned steps to setup MySQL temp directory on a RAM disk. Create a tmpfs directory : mkdir /var/tmpfs Now change the ownership of the newly created directory. chown mysql:mysql /var/tmpfs id mysql Make sure to get the uid and gid for mysql vi /etc/fstab tmpfs /var/tmpfs tmpfs rw,uid=498,gid=499,size=500M,nr_inodes=10k,mode=0700 0 0 Save and  Full Article…

0