Hi,
I am running Percona Server 5.6.17-65.0-587.wheezy (Debian)
On
3.2.0-4-amd64 #1 SMP Debian 3.2.57-3 x86_64 GNU/Linux
When I start mysqld and look at ‘top’ output, cpu is running at 99.9%.
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6606 mysql 20 0 898m 656m 9m S 99.5 65.8 26:09.02 mysqld
There are no connections/queries to the database ( 242Mb )
mysql> SHOW PROCESSLIST;
±—±-----±----------±-----±--------±-----±------±-----------------±----------±--------------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
±—±-----±----------±-----±--------±-----±------±-----------------±----------±--------------+
| 39 | root | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0 | 0 |
±—±-----±----------±-----±--------±-----±------±-----------------±----------±--------------+
1 row in set (0.00 sec)
Any ideas what to look for?
Thanks
Bruce
---- UPDATE —
Created another server and put DB on it. No other connections to the database but me. So I have done some tests and found that it appears to be due to queries on table X (665000 rows).
If I perform “check table X extended;” mysql reports back OK but CPU hits 99.6% and stays there. restart mysql, CPU at 0%
If I perform a “select count(*) from X” CPU 99.6% and stays there, result returned OK
It suggests a corrupt table but obviously check table extended says its OK.