mysqld_safe and high cpu usage
I've added a drupal site and postfix.
I get email alerts that I am using over 100% of cpu
here is top readout: (mysqld_safe holds at 100% all the time)
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19016 root 20 0 1764 44 20 R 100 0.0 2069:34 mysqld_safe
578 root 20 0 2484 1184 884 R 0 0.1 0:01.70 top
1 root 20 0 2536 592 372 S 0 0.0 0:00.62 init
2 root 20 0 0 0 0 S 0 0.0 0:00.00 kthreadd
3 root RT 0 0 0 0 S 0 0.0 0:00.05 migration/0
Is that enough info for anyone to help with suggestions on how to reduce my cpu usage?
1 Reply
In which case if it's using any meaningful amount of CPU at all it's probably just broken. Try shutting down the MySQL server using init or service or whatever, then just force kill the mysqld_safe and reboot when you're sure it's gone, sounds like it'd be the safest quick, easy fix that might work.
[ Edit: After thinking this couldn't be that rare,