/tmp full , but inside directory is just a few files

activa

Well-Known Member
May 23, 2006
213
1
168
Morocco
cPanel Access Level
Root Administrator
Hello

i have the /tmp file set to 2 Gb , and i get errors about mysql can't create tmp files , when i check the partition i get the fallowing info

Code:
[email protected] [/tmp]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/md2              916G  459G  411G  53% /
/dev/md1              508M   29M  455M   6% /boot
tmpfs                 4.0G     0  4.0G   0% /dev/shm
/usr/tmpDSK           2.0G  1.9G   21M  99% /tmp
when i enter the /tmp folder i found is just 17Mb usage

Code:
[email protected] [/tmp]# cd ..
[email protected] [/]# cd /tmp
[email protected] [/tmp]# du -sh
17M     .
[email protected] [/tmp]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/md2              916G  459G  411G  53% /
/dev/md1              508M   29M  455M   6% /boot
tmpfs                 4.0G     0  4.0G   0% /dev/shm
/usr/tmpDSK           2.0G  1.8G   81M  96% /tmp
what is the probleme here ? the df usage is not the same as th du usage ? any idea or road to go ?

Note i have the mysql tmp dir set to /tmp .

i have other servers with the same configuration but has not the tmp usage probleme .
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
I would bet they are hidden files by MySQL instead. The temporary table files it creates are all hidden and wouldn't appear on a regular du of the folder. If it is breaching the size, you'll get "Incorrect key" entries in /var/lib/mysql in the error log there (hostname.err where hostname is the server's fully qualified hostname).

You might check for prior threads discussing this. There are numerous ones, frequently one or more a week on this forum.