Saturday, January 19, 2002, 9:21:04 AM, Jeremy Zawodny wrote: > On Fri, Jan 18, 2002 at 10:38:43AM +0200, Dmitry Alyabyev wrote: >> Hello >> >> Time to time I see strange overload of MySQL on dedicated >> server. The server is powerful enough to handle ~ 500 req/s. MySQL >> version is 3.23.40 and runs on Linux 2.4.16-SMP. The overload which >> I mean leds to stop answering to queries and looks like: >> >> 6:24pm up 6 days, 2:34, 2 users, load average: 164.18, 91.07, 39.56 >> 270 processes: 73 sleeping, 197 running, 0 zombie, 0 stopped >> CPU0 states: 99.23% user, 0.15% system, 0.0% nice, 0.1% idle >> CPU1 states: 97.17% user, 2.21% system, 0.0% nice, 0.0% idle >> Mem: 513504K av, 500000K used, 13504K free, 0K shrd, 22892K buff >> Swap: 1036184K av, 7540K used, 1028644K free 305928K cached >> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND >> 30453 mysql 14 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld >> 30454 mysql 14 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld >> [skip] >> 30460 mysql 16 0 19204 18M 2224 R 6.9 3.7 0:02 mysqld >> >> On the other hand I see Slow_launch_threads counter equal to 2 that >> means there were a problem with thread create (took more then 2 sec). >> Others thread-related counters:
> Can you get a SHOW FULL PROCESSLIST out of the server? Unfortunately I can't - server operates very slowly at the moment. -- Dimitry --------------------------------------------------------------------- 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
