I get mysql diskspace error
Can't create/write to file '/tmp/#sql_777_0.MYI' (Errcode: 28)
mainly because my ngnix server is writing file into the tmp folder which doesn't get clean up..
i added this command as per instructions on the nginx manual to the crontab but doesn't seems to be doing the trick, (i don't understand what it does too)
0 */1 * * * /usr/sbin/tmpwatch -am 1 /tmp/nginx_client
then i had to do this commands mannually
cd /tmp/nginx_client find -name * | xargs rm
i need to know what
- should i do to automate this clean up ?
- is there way to increase the /tmp/ -> /var/tmp/ size without reformatting or doing any dangerous things ?
- Can i change the location of the MYSQL -> TMP files ?