KILL <connection_id>; -- kills the entire connection, not just the query
SHOW FULL PROCESSLIST;
The next morning, Maya added a monitoring alert for queries running longer than 60 seconds. She also taught the dev team how to catch themselves: mysql kill a query
Killing it was the only immediate option. No time for a graceful shutdown. -- kills the entire connection
SHOW PROCESSLIST;
If the connection is valuable (e.g., a persistent connection from a web server) and you only want to stop the specific statement currently running, use KILL QUERY . The connection remains open, but the query stops. The next morning