why mysql eat my memory over 1G?Please help me!Thank you!!!
--------------------------------------------------------------------------------
server1:DELL6300,4cpu,4G memory.solaris5.7 for X86 .
mysql start command:nohup /usr/local/bin/safe_mysqld -O key_buffer=128M -O
table_cache=512 -O sort_buffer=128M -O record_buffer=128M -O max_connections=999 -O
wait_timeout=5000 &
use "top" show:
--------------------------------------------------------------------------------
last pid: 26041; load averages: 6.89, 9.39, 10.01 13:27:36
64 processes: 59 sleeping, 2 running, 3 on cpu
CPU states: 0.8% idle, 68.1% user, 31.1% kernel, 0.0% iowait, 0.0% swap
Memory: 4032M real, 557M free, 1787M swap in use, 3602M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
2838 root 147 20 0 1432M 1317M cpu1 62.1H 53.15% mysqld
3057 publish 1 5 2 18M 12M sleep 67:32 2.08% perl
23734 publish 1 22 0 17M 14M run 0:32 5.10% httpd
16703 publish 1 58 0 17M 11M sleep 0:38 0.00% httpd
--------------------------------------------------------------------------------
server2:SunUltra-4,1cpu,1G memory,solaris5.7.
mysql start command:nohup /usr/local/bin/safe_mysqld -O key_buffer=128M -O
table_cache=512 -O sort_buffer=128M -O record_buffer=128M -O max_connections=999 -O
wait_timeout=5000 &
use "top" show:
--------------------------------------------------------------------------------
load averages: 0.98, 1.09, 1.17 13:32:41
159 processes: 157 sleeping, 1 running, 1 on cpu
CPU states: 0.0% idle, 57.3% user, 42.7% kernel, 0.0% iowait, 0.0% swap
Memory: 1024M real, 16M free, 870M swap in use, 894M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
332 root 9 20 0 779M 400M run 80.6H 89.60% mysqld
370 root 1 59 0 18M 13M sleep 0:15 0.00% Xsun
392 root 1 59 0 7136K 1248K sleep 0:09 0.00% dtgreet
______________________________________
===================================================================
新浪免费电子邮箱 (http://mail.sina.com.cn)
新浪聊天大奖-MP3商务通DVD手机钻戒等着您;并提供聊友速配服务
(http://newchat.sina.com.cn/love/)
---------------------------------------------------------------------
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