Announcement

Announcement Module
Collapse
No announcement yet.

100% CPU on startup and no queries

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 100% CPU on startup and no queries

    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.

    Last edited by Bruce4; 08-03-2014, 07:56 AM. Reason: Updated with tests
Working...
X