Not the answer you need?
Register and ask your own question!

100% CPU on startup and no queries

Bruce4Bruce4 EntrantCurrent User Role Beginner
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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.