tmp folder 100% full

[blogmaster2003]

Hi

im running a dedicated server cent os 5 64bit with cpanel (latest release)

Everyday my tmp folder is becoming full with several files:

#sql_11f7_0.MYD
#sql_11f7_0.MYI

I think these files are temporary mysql files?

So i think i should change some configuration in my temporary mysql folder?

Or should i resize my tmp folder?

Thank you

[blogmaster2003]

Hi

nobody can help me on this one?

[madaboutlinux]

What is the size of /tmp directory?

df -h

what is the size of the .MYI and .MYD files under /tmp?

du -sh *.MYD
du -sh *.MYI

and were any changes made on the server since the files started creating under /tmp? what are the contents of /etc/my.cnf ?

cat /etc/my.cnf

BTW, you cannot resize the existing partition unless it's a LVM partition which I am sure it is not. You have to create a virtual partition and mount the partition on /tmp.

[blogmaster2003]

i already cleaned it, but i think tomorrow ill have more temp mysql files.

root@server1 [~/tmp]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda6             2.0G  475M  1.4G  26% /
/dev/sda8             196G   12G  174G   7% /home
/dev/sdb1             226G  5.6G  209G   3% /backup
/dev/sda3             9.7G  4.2G  5.1G  45% /var
/dev/sda2             9.7G  5.7G  3.5G  63% /usr
/dev/sda1              99M   29M   65M  31% /boot
tmpfs                 2.0G     0  2.0G   0% /dev/shm
/usr/tmpDSK           2.0G   36M  1.8G   2% /tmp

root@server1 [~/tmp]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
local-infile = 0
skip-locking
skip-bdb
max_connections = 500
key_buffer = 128M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 2M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
table_cache = 1024
record_buffer = 1M
thread_cache_size = 128
wait_timeout = 30
connect_timeout = 10
interactive_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
thread_concurrency = 4

[mysql.server]
user=mysql

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 100M

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

thx