List,
Re:
<http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:71261:200104:iidpojcdbmgdbajh
aobn#b>
I have this exact problem on a single-CPU P-III 500 running FreeBSD
4.5-RELEASE, generic kernel. MySQL is 4.0.1-alpha. I have tried both the
mysql.com-supplied binary package and rolling my own from sources.
What happens is that after anywhere from 1-2 days of uptime the mysqld
process suddenly starts eating all available CPU:
last pid: 25537; load averages: 1.20, 1.61, 1.43 up 32+17:01:50
20:35:06
51 processes: 2 running, 49 sleeping
CPU states: 21.0% user, 0.0% nice, 77.4% system, 1.6% interrupt, 0.0%
idle
Mem: 208M Active, 154M Inact, 96M Wired, 27M Cache, 60M Buf, 13M Free
Swap: 1024M Total, 64K Used, 1024M Free
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
93402 mysql 54 0 299M 43988K RUN 368:57 98.00% 98.00% mysqld
93461 www 2 0 14400K 9356K sbwait 0:31 0.10% 0.10% httpd
MySQL still answers queries so everything works, at least for as long as I
allow the server to run in this state.
'iostat' shows nothing much happening:
# iostat
tty da0 acd0 sa0 cpu
tin tout KB/t tps MB/s KB/t tps MB/s KB/t tps MB/s us ni sy in id
0 14 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 5 0 14 1 80
#
and 'mysqladmin processlist' shows about 45-50 processes all in "Sleep"
command. The only process in "Query" command is my own 'processlist'.
After a quick restart of the mysqld server load drops to almost 0 and mysqld
settles down to its usual modest CPU utilization:
last pid: 25649; load averages: 0.09, 0.74, 1.07 up 32+17:09:51
20:43:07
51 processes: 1 running, 50 sleeping
CPU states: 0.8% user, 0.0% nice, 1.2% system, 1.9% interrupt, 96.1%
idle
Mem: 188M Active, 159M Inact, 97M Wired, 27M Cache, 60M Buf, 29M Free
Swap: 1024M Total, 64K Used, 1024M Free
PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND
25620 mysql 2 0 293M 23480K poll 0:01 0.05% 0.05% mysqld
37095 bind 2 0 5300K 4780K select 18:37 0.00% 0.00% named
To make things interesting I have another FreeBSD server, this one an SMP
2-CPU P-III 1 GHz running FreeBSD 4.4-RELEASE and MySQL 4.0.0-alpha compiled
from sources. This one is under heavier load but does not display this
problem!
Any ideas? I'm no MySQL expert so I could use a little hand-holding in
running diagnostics.
Please Cc: me on replies. Thanks!
Gunnar
--
Gunnar Helliesen | Bergen IT Consult AS | Open Source activist
Systems Consultant | Bergen, Norway | Jaguar enthusiast
[EMAIL PROTECTED] | www.bitcon.no/~gunnar | Märklin collector
---------------------------------------------------------------------
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
