MySQL using 103% CPU
Posted: Sun Jul 11, 2010 9:52 am
The MySQL process is using a lot of CPU time, even though theres only one query listed after writing SHOW PROCESSLIST;
I'm running Debian GNU/Linux 5.0, and I'm having 8 * Intel Xeon X5450 @ 3GHz and 6 GB RAM. I've tried to restart the mysql process, and reboot my machine. It holds at like 1% in 5 minutes, but suddently, it's up to 90-120%, and it stays that way until i restart the mysql process.
Code: Select all
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
24234 mysql 20 0 461m 166m 6152 S 103 2.1 10:08.92 mysqld
Code: Select all
Server version: 5.0.51a-24+lenny4-log (Debian)
mysql> SHOW PROCESSLIST;
+------+----------+------------------+----------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+----------+------------------+----------+---------+------+-------+------------------+
| 902 | mysqlusr | 11.11.11.1:33582 | mydatabs | Sleep | 632 | | NULL |
| 1328 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+------+----------+------------------+----------+---------+------+-------+------------------+
2 rows in set (0.00 sec)