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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 Jul 1 '12 at 15:39

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

up vote 9 down vote accepted

had the same problem, here is a solution:

Everything happens because of "1" second.

share|improve this answer
The most recent "leap second" was triggered on July 1st 2015 (see I just noticed my MySql-Daemon spinning (probably going unnoticed for several days). Following the instructions helped! – Marcus Rickert Jul 7 '15 at 22:55

Your Answer


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