Move MySQL tmpdir to RAM

By admin on January 1, 2011 in MySQL

1. Create the tmp directory:

mkdir /var/lib/mysqltmp

1	mkdir /var/lib/mysqltmp

2. Set permissions:

chown mysql:mysql /var/lib/mysqltmp

1	chown mysql:mysql /var/lib/mysqltmp

3. Determine mysql user id:

id mysql

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

1	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

1	mount /var/lib/mysqltmp

6. Edit /etc/my.cnf and set location of tmp directory:

tmpdir=/var/lib/mysqltmp

1	tmpdir=/var/lib/mysqltmp

7. Restart mysqd

/sbin/service mysqld restart

1	/sbin/service mysqld restart