On Wed, May 01, 2002 at 09:15:25PM +0200, Gunnar Helliesen wrote: > 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.
I've seen it too. No on my primary servers, but on some that I occasionally work on. > '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 > # Same. > and 'mysqladmin processlist' shows about 45-50 processes all in "Sleep" > command. The only process in "Query" command is my own 'processlist'. Same. > After a quick restart of the mysqld server load drops to almost 0 and mysqld > settles down to its usual modest CPU utilization: Same. > 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. Odd. The only boxes I've seen it on so far were dual-CPU FreeBSD 4.5 machines. I've heard that it also hit one single-cpu FreeBSD 4.5 machine too, but I never got all the details on that one. The trick is to figure out how to reliably reproduce the problem. Once that happens, fixing it will be rather easy I think. So if anyone comes up with a way of doing it, please speak up. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 83 days, processed 2,169,755,750 queries (300/sec. avg) --------------------------------------------------------------------- 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
