1. Create the tmp directory: mkdir /var/lib/mysqltmp 2. Set permissions: chown mysql:mysql /var/lib/mysqltmp 3. Determine mysql user id: id mysql 4. Edit /etc/fstab and add the following line: tmpfs /var/lib/mysqltmp tmpfs rw,gid=27,uid=27,size=256M,nr_inodes=10k,mode=0700 0 0 5. Mount the new tmpfs partition: mount /var/lib/mysqltmp 6. Edit /etc/my.cnf and set location of tmp directory: tmpdir=/var/lib/mysqltmp 7. Restart mysqd [...]
1. Create the tmp directory:
mkdir /var/lib/mysqltmp
2. Set permissions:
chown mysql:mysql /var/lib/mysqltmp
3. Determine mysql user id:
id mysql
4. Edit /etc/fstab and add the following line:
tmpfs /var/lib/mysqltmp tmpfs rw,gid=27,uid=27,size=256M,nr_inodes=10k,mode=0700 0 0
5. Mount the new tmpfs partition:
mount /var/lib/mysqltmp
6. Edit /etc/my.cnf and set location of tmp directory:
tmpdir=/var/lib/mysqltmp
7. Restart mysqd
/sbin/service mysqld restart
