# 100% CPU on startup and no queries **URL:** https://forums.percona.com/t/100-cpu-on-startup-and-no-queries/3649 **Category:** Other MySQL® Questions **Created:** [August 1, 2014, 6:28am UTC](https://forums.percona.com/t/100-cpu-on-startup-and-no-queries/3649 "2014-08-01T06:28:29Z") **Posts on this page:** 1 **Page:** 1
### Author: ![Bruce4](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@Bruce4](https://forums.percona.com/u/Bruce4) #### Post date: [August 1, 2014, 6:28am UTC](https://forums.percona.com/t/100-cpu-on-startup-and-no-queries/3649/1 "2014-08-01T06:28:29Z")
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.