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? -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 16 days, processed 381,298,730 queries (270/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
