Kill Mysql Query !!top!! -

Use SHOW FULL PROCESSLIST; to see all running threads, including the full text of the query being executed.

If you have many connections, use a standard SELECT to find specific slow queries: kill mysql query

Before you can kill a query, you must find its (also called processlist_id ). Use SHOW FULL PROCESSLIST; to see all running

This finds all non-sleeping queries running for more than 30 seconds. 2. The Kill Command Syntax Use SHOW FULL PROCESSLIST

Terminates the statement the connection is currently executing but keeps the client connection open.