mysql

Trying to Troubleshoot extremely high MySQL CPU Usage

MySQL CPU usage was spiking upwards of 1000%. Load average was around 50-60. I could not SSH into the machine though, not immediately. Since I could not actually get into the machine I had it restarted. Just as soon as the machine came back up MySQL CPU usage jumped right back up to 1000%. Once I was able to finally shut MySQL down I had to discover _why_ the load was so ridiculously high.

Continue reading →