MySQL

Kill a runaway MySQL Query

If you run a Query on a MySQL database that is taking too long and locking out other processes – then you might want to kill it and allow the other processes to run.

Get the thread id of the offending job with SHOW PROCESSLIST:

SHOW PROCESSLIST;

Then kill that thread:

KILL <thread_id>;

Leave a Reply