PDA

View Full Version : MySQL is down


OOagent137
2003-08-14, 11:18 AM
Our mySQL is down. I logged into root and ran the top command and found this:

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
32421 mysql 25 0 22204 12M 2460 R 86.0 2.6 55:22 mysqld

Now, somebody's script is eating up our CPU....how do I figure out what script it is?

awsolutions
2003-08-14, 11:48 AM
I remeber someoene showing me this one time:

watch -n0 mysqladmin processlist -u admin -p

But when I try to do it right now it keeps locking up my shell - so use with caution or get someone else's feedback first!

QT
2003-08-14, 12:44 PM
You can also check the docs at http://www.mysql.com :)