MySQL Bug Spikes CPU Load With No Queries Running

by Daniel Convissor at 2015-09-22 09:45:00

Here's a funny one. I ran top the other day on a lightly used server and found MySQL pushing the CPU between 50% and 100%. "Am I under attack?" was my first thought. Oddly, SHOW PROCESSLIST was empty. "High CPU usage but no queries were running? WTF!"

Turns out MySQL's has a bug handling leap seconds. Clearing the condition was as simple as running date -s "`date`"

Tags: mysql

View all posts

Email me a comment:

(I'll append it here when I get a chance.)

Your Name:
Your Email Address:
Subject:
Message:
(1000 chars. max.)