How to terminate MySQL query

Sometimes it may required to kill long running queries from MySQL.

In-order to do the same, login to the MySQL shell as root user.

Then list out all the queries running currently and note down the thread ids.

>show processlist;

Terminate the required query.

>kill <thread_id>;

Here thread_id should replaced with the id the query that to be terminated.

That's all…

Leave a Reply