Hi, after a few days, mysql take too much memory and sometimes causing
swap
memory exhausts. I'm sure that only one client accessing mysql server,
but I see too many threads. So I shutdown MySQL periodically. I use
mysql-large.cnf configuration file. If the client was killed by
KILL signal, or terminated unexpectly, does mySQL thread exit
automatically? Any
one
have suggestion?
Here is some output from top.
3:32pm up 48 days, 6:16, 24 users, load average: 0.00, 0.00, 0.00
111 processes: 110 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: 0.3% user, 3.4% system, 0.0% nice, 96.1% idle
Mem: 517120K av, 490796K used, 26324K free, 54476K shrd, 237444K
buff
Swap: 1052216K av, 74728K used, 977488K free 12024K
cached
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
22801 mysql 0 0 258M 200M 832 S 0 0.0 39.7 0:00 mysqld
22803 mysql 0 0 258M 200M 832 S 0 0.0 39.7 0:10 mysqld
22804 mysql 0 0 258M 200M 832 S 0 0.0 39.7 3:00 mysqld
22889 mysql 0 0 258M 200M 832 S 0 0.0 39.7 47:00 mysqld
23036 mysql 0 0 258M 200M 832 S 0 0.0 39.7 20:26 mysqld
23053 mysql 0 0 258M 200M 832 S 0 0.0 39.7 120:01 mysqld
23086 mysql 0 0 258M 200M 832 S 0 0.0 39.7 5598m mysqld
24875 mysql 0 0 258M 200M 832 S 0 0.0 39.7 30:06 mysqld
25090 mysql 0 0 258M 200M 832 S 0 0.0 39.7 3:07 mysqld
25110 mysql 0 0 258M 200M 832 S 0 0.0 39.7 0:00 mysqld
regards,
-ilham-
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
