denrepo

MySQLSessions

Kill a query or connection

KILL QUERY stops the statement and keeps the connection; KILL closes the connection and rolls back its transaction.

Changes data

Not yet verified. How scripts are tested

This script changes the database. Check the names and values before you run it.
b-my-kill.sql 
1-- Replace 1234 with the processlist id2KILL QUERY 1234;  -- stop the running statement only3KILL 1234;        -- close the connection

Paste it into your query tool.

Open in denrepo

More MySQL scripts: Sessions