Hi,
check the niced processes (on BSD #ps aux). These are processes which have been assigned a higher priority and there for kill your server. Also the man page from top (the CPU STATE comes from top ?) writes that the nice % should also be seen in user and system % which is not the case in your snip. Could be of the high CPU overload hope this helps a bit sake. "Sheni R. Meledath" An: MySQL Masters <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Kopie: Thema: Problem with MySQL server - 3.21.33b 15.05.02 11:24 Hello: We are facing a serious problem with the MySQL server installed on our web server (BSD/OS). The server was working fine till last week. Since then it started crashing. It crashes 2-3 times a day. Every time we have to kill the process and restart the server (UNIX). Not only the MySQL server the entire server crashes because of the load on the CPU. ###CPU STATE### load averages: 1.00, 1.00, 0.92 02:47:57 278 processes: 13 running, 265 sleeping CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M PID PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 270 94 4 4420K 2024K run 43:48 97.17% 97.17% mysqld ############## The MySQL version is 3.21.33b . Since its an old version I couldn't find out any information regarding the issue from the MySQL web site. We have got 4-5 MySQL databases on this server. Could anybody help me out to solve this issue. Regards Sheni R Meledath [EMAIL PROTECTED] --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php