Use the slow query log.

Look up how to use it. It's a really, really useful log.
JmZ Reviewed by JmZ on . MySQL Help! Hey =) I noticed that one of my servers MySQL is causing the CPU to spike for some reason. I thought of moving it to another server to even the load, but i kind of do not want to do that yet if i can fix the problem. As you can see, mysql is using 212% CPU, it keeps spiking for some reason and i haven't been able to figure out why. If anyone could help me that would be great =) Rating: 5