Re: MySQL using 80-90% of CPU

[John Oliver]

CPU is back up to ~80% but

mysql> show processlist;
+-----+---------+------------------------------------+----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id  | User    | Host                               | db       | Command | Time | State        | Info                                                                                                 |
+-----+---------+------------------------------------+----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 121 | mdauser | mda-services:53274                 | mda3     | Sleep   |    0 |              | NULL                                                                                                 |
| 131 | root    | localhost:40216                    | nextMda3 | Query   |    0 | Sending data | SELECT COUNT(*) INTO eventCount_indicator FROM
    EventCount WHERE dataSourceId = id AND
    receiv |
| 134 | root    | localhost                          | NULL     | Query   |    0 | NULL         | show processlist                                                                                     |
+-----+---------+------------------------------------+----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

And there are still only two established TCP connections, both from the only host that uses this server.



Edited 1 time(s). Last edit at 05/13/2009 03:24PM by John Oliver.