olivefan wrote:
>
> 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
>
> ______________________________________
>
Olivefan:
Looks like the Intel box is a little i/o starved. The Sun seems to be getting
along fine, but, still a pretty high load. Not sure why the memory usage
discrepancy, but, a mysqladmin extended might be more helpful.
I'm assuming you're running the solaris on the Dell for filesystem size
reasons. Must be a pretty big and busy dbase. That load's gonna kill the
machine over time. What's the temperature on that thing?
Van
--
=========================================================================
Linux rocks!!! http://www.dedserius.com
=========================================================================
---------------------------------------------------------------------
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