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

[activa]

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

[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

[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]

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.

 

[albatroz]

Hello @activa, did you fixed your problem?

BTW I was wondering how to do to increase the size of the /tmp partition

 

[pwhjenny]

You need to execute..

du -h --max-depth=1

Also check for hidden files using ls -a

In order to increase the /tmp partitioning you can follow below given page.

Increasing the Size of tmpDSK (/tmp) :: The cPanel Admin

 

[jacks_webzia]

See the output of command

cd /tmp
du -sch *