nginx tmp file folder runing out of diskspace

Posted by user1179459 on Server Fault See other posts from Server Fault or by user1179459
Published on 2012-10-08T02:11:01Z Indexed on 2012/10/08 3:38 UTC
Read the original article Hit count: 703

Filed under:
|
|

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

  1. should i do to automate this clean up ?
  2. is there way to increase the /tmp/ -> /var/tmp/ size without reformatting or doing any dangerous things ?
  3. Can i change the location of the MYSQL -> TMP files ?

© Server Fault or respective owner

Related posts about linux

Related posts about mysql