Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I noticed that MySQL is using way more CPU than usual on my workstation (usual is 1% or less, because this is my workstation, not a server).

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                   
14004 mysql     20   0  536m  44m 7136 S  141  1.2  65:24.72 mysqld           

I looked in my slow log and there are no queries at all. I ran tail -f on the general log to see what was running and there was nothing at all there either. The MySQL processlist is empty as well.

+-----+------+-----------+----+---------+------+-------+------------------+
| Id  | User | Host      | db | Command | Time | State | Info             |
+-----+------+-----------+----+---------+------+-------+------------------+
| 165 | root | localhost |    | Query   | 0    |       | show processlist |
+-----+------+-----------+----+---------+------+-------+------------------+

Every other post I've seen is related to high CPU usage due to a specific query, but I've got no queries running at all. Does anyone know how to determine why MySQL is using all that CPU?

In case it matters, here's more info about my system:

Linux kubuntu 3.2.0-26-generic

Server version          5.5.24-0ubuntu0.12.04.1-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 57 min 8 sec

Threads: 1  Questions: 406  Slow queries: 0  Opens: 567  Flush tables: 1  
Open tables: 140  Queries per second avg: 0.118
share|improve this question

migrated from stackoverflow.com Jul 1 '12 at 15:39

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 6 down vote accepted

had the same problem, here is a solution:

http://blog.mozilla.org/it/2012/06/30/mysql-and-the-leap-second-high-cpu-and-the-fix/

Everything happens because of "1" second.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.