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: Threads_cached 59 Threads_created 68 Threads_connected 2 Threads_running 1 So what seems to be a source of the problem - linux kernel, MySQL 3.23.40 or wrong tunning ? Your comments/ideas are very welcome. -- 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