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
<mysql@stripped>
<sheni@stripped> 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
sheni@stripped
---------------------------------------------------------------------
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 <mysql-thread109096@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##H@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
