Speed1972
By:
Speed1972

Mysql 100% CPU on 1 database after restore backup

October 6, 2014 947 views

After restore from digital oacean backup i am getting 100% CPU

TOP gives that MYSQLD eats the CPU
5297 mysql 20 0 146m 36m 5232 S 84.2 3.6 1184:51 mysqld

Show full proceslist gives:

SHOW FULL PROCESSLIST;
+----+------------+-----------+------------------+---------+------+-------+-----                                               ------------------+
| Id | User       | Host      | db               | Command | Time | State | Info                                                                 |
+----+------------+-----------+------------------+---------+------+-------+-----                                               ------------------+
|  8 | Xuser | localhost | db | Sleep   |  107 |       | NULL                                                                 |
|  9 | xuser | localhost | db | Sleep   |   26 |       | NULL                                                                 |
| 28 | xuser | localhost | db | Sleep   |  148 |       | NULL                                                                 |
| 49 | xuser | localhost | db | Sleep   |   67 |       | NULL                                                                 |
| 55 | xuser | localhost | db | Sleep   |  188 |       | NULL                                                                 |
| 68 | root       | localhost | NULL             | Query   |    0 | NULL  | SHOW                                                FULL PROCESSLIST |
+----+------------+-----------+------------------+---------+------+-------+-----                                               ------------------+
6 rows in set (0.00 sec)

Mytop gives:

MySQL on localhost (5.1.73) up 1+18:46:43 [12:32:19]
Queries: 34.0 qps: 0 Slow: 0.0 Se/In/Up/De(%): 00/00/00/00
qps now: 0 Slow qps: 0.0 Threads: 1 ( 1/ 0) 00/00/00/00
Key Efficiency: 97.8% Bps in/out: 0.0/ 0.8 Now in/out: 8.3/ 1.5k

Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
6891 xuser localhost bd 0 Query show full processlist

MySQL on localhost (5.1.73) up 1+18:46:48 [12:32:24]
Queries: 36.0 qps: 0 Slow: 0.0 Se/In/Up/De(%): 00/00/00/00
qps now: 0 Slow qps: 0.0 Threads: 1 ( 1/ 0) 00/00/00/00
Key Efficiency: 97.8% Bps in/out: 0.0/ 0.9 Now in/out: 8.3/ 1.5k

Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
6891 xuser localhost bd 0 Query show full processlist 

I am stuck no. How do i get more info and you do i know how to kill queries

Be the first one to answer this question.