MySQL + /usr/tmpDSK

[racz]

Hi all,

There is a very strange problem here (for me):

Sometimes, the /tmp is become full suddenly -> php can't make session files etc.
but
when i restart mysql, the /tmp is become empty.
i have 5 servers with centos+cpanel, 4 works fine, but this one is wrong with same settings.

the /tmp usage graph: wrong-restart-ok-wrong-restart....


Any idea?

 

[racz]

Anybody? give me some tips pls.

 

[mitul]

Check this out.

http://forums.cpanel.net/showthread.php?t=64526&highlight=tmp+mysql

 

[racz]

Ok thanks, it seems to work

 

[racz]

Hmm it doesn't work. the problem have returned. I need help.

 

[Infopro]

Have you actually looked in the /tmp directory to see what's filling it up? Who is the owner of the files in there?

 

[racz]

i dont know, when the /tmp seems to be filled, there are the same files. When i restart the mysql, everything became OK but i think it's not the mysql's fault.

 

[cPanelKenneth]

i dont know, when the /tmp seems to be filled, there are the same files. When i restart the mysql, everything became OK but i think it's not the mysql's fault.

Could you provide some sample file names?

MySQL uses /tmp when performing actions such as table and database renames, as well as certain queries. It's possible those temporary files are not being removed, for whatever reason.

What is your MySQL version?

 

[racz]

mysql Ver 14.12 Distrib 5.0.67, CentOS

file names:

lot of: sess_ff8f45b79xxxxxxxxxxxxx - php sessions, but apache remove this after use, and these size maximum some kB.
and the symlink of mysql.sock

That's all files stored in /tmp


"temporary files are not being removed, for whatever reason." - ok i see, but what could be the reason?

 

[Infopro]

How large is your tmp/ directory? You may just need to increase the size of it. The files you mention are normal, and if they're being removed then the system is working as expected I would think.