/tmp 100% - MySQL issue?

M

MtK

Verified User
Joined
Aug 2, 2007
Messages
412
hey,
I have a server getting /tmp 100% full:
Code: 
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_tmp
                     1001M  950M  8.0K 100% /tmp

looking at /tmp I can't see anything using so much space, but it does cause MySQL to stop working because it cannot write to /tmp.

so when I restart MySQL available space on /tmp goes down to 2%:
Code: 
<$> service mysqld restart
Shutting down MySQL..................................... SUCCESS!
Starting MySQL.... SUCCESS!
Code: 
<$> df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_tmp
                     1001M   18M  932M   2% /tmp


can anyone help me find the cause?
 
why your server used "tmp" folder mysql?
it should be on /var/lib/mysql

please provide me the /etc/my.cnf file
 
ben29 said:
why your server used "tmp" folder mysql?
it should be on /var/lib/mysql
Click to expand...
no one said that.
MySQL uses /var/lib/mysql which is actually in a different mount.


please provide me the /etc/my.cnf file[/QUOTE]
Code: 
[mysqld]
local-infile=0
bind-address = 127.0.0.1

init-connect="SET NAMES utf8"
#collation_connection=utf8_general_ci
skip-character-set-client-handshake
skip-name-resolve
max_connections = 150
max_user_connections = 15
character-set-server=utf8
collation-server=utf8_general_ci
wait_timeout=3600

query_cache_size = 64M
join_buffer_size = 8M
tmp_table_size   = 64M
max_heap_table_size = 64M
thread_cache_size   = 4
table_cache = 256
innodb_buffer_pool_size = 2048M


max_allowed_packet = 16M
 
lot of persistent connections (like very active forum or similar) can cause this.
 
Hmmz... it's 1 Gig. Must be a very large and busy forum then. We normally create our /tmp partition at least 4 GiB. Never had problems so far, but I'm curious to the cause of this one too.
 
can't find it now but thought there was issue fixed in one of the latest 5.5.x versions also dealing with this. iirc was pretty rare, only saw it once myself on a very large invision forum I was helping with.
 
Hello,

Provide me the output of below command.
cd /var/lib/
ll

Also, I can see that size of tmp partition is too small try to increase the tmp partition or you can set cron to clear the tmp files.

Regards,
24x7server
 
You must log in or register to reply here.
Back
Top