SQL tmp/ and change the tmp dirctory
tmpwatch -av 1 /tmp
to change nysql drictory from tmp to tmp2 you need to add tmpdir=/tmp2 in /etc/my.cnf
then to make sure is changed you need to type
mysql
then you will get
>
then you type
>show variables like “tmpdir”;
so you see the changed