Using tmpfs for temporary folder creation

Rahul Bansal

11 years ago

If you are on Ubuntu, then do this first:

vim /etc/apparmor.d/usr.sbin.mysqld

Add a line:

/run/mysqld/tmp/** rwk,

Restart Apparmor

service apparmor restart

Also create tmp directory and fix ownership/permissions.

mkdir /run/mysqld/tmp/
chown -R mysql:mysql /run/mysqld/tmp/
chmod 1777 /run/mysqld/tmp/

Open my.cnf file

vim /etc/mysql/my.cnf

Set/Change tmpdir location

tmpdir = /run/mysqld/tmp

Restart Mysql

service mysql restart