Replace QUERY_ID with the actual ID of the query you want to kill.
The client receives an error message (e.g., "Query execution was interrupted") but can immediately run a new query. Kill the Connection ( KILL or KILL CONNECTION )
SELECT * FROM information_schema.processlist;
