STEP 1.
df -h
STEP 2.
mkdir -p /var/mysqltmp
STEP 3.
chown mysql:mysql /var/mysqltmp
STEP 4.
id mysql
OutPut :
uid=27(mysql) gid=27(mysql) groups=27(mysql)
STEP 5.
vi /etc/fstab
Add the below Line (Custom gid and uid accroding to id mysql output )
tmpfs /var/mysqltmp tmpfs rw,gid=27,uid=27,size=10G,nr_inodes=10k,mode=0700 0 0
STEP 6.
df -h
STEP 7.
vi /etc/my.cnf
Add Line
tmpdir = /var/mysqltmp
STEP 8.
service mysqld restart
STEP 9.
Verify Temp in mysql
mysql -p
STEP 10.
mysql> SHOW VARIABLES LIKE 'tmpdir';
OUTPUT
+---------------+---------------+
| Variable_name | Value |
+---------------+---------------+
| tmpdir | /var/mysqltmp |
+---------------+---------------+
STEP 11.
mysql> exit