MySQL Process Inspection - Kill

When MySQL seems slow, there may be a process that has runaway. To see what is happening on MySQL, from your terminal run


mtop

This will show you a list of the MySQL processes currently running on that server. Look for any process that has been running from more than a few seconds by looking at the "TIME" column.

[[{"type":"media","view_mode":"media_original","fid":"70","attributes":{"alt":"","class":"media-image","typeof":"foaf:Image"}}]]

If you spot one that is really bad and does not seem to be ending you can type "k" followed by the ID of the process to try to kill it. If after a few attempts to kill it, it is still there, you will need to contact someone from the Server Team to restart MySQL.

'z' (for zoom) and the ID number will show you the full query being run by that process.

section: