Kill Mysql Query [verified] -
To terminate the entire session and the query it is currently running:
Sometimes you run KILL but the query remains in the process list with a state like Killed or Checking table . This means MySQL has acknowledged the kill command but is waiting for an internal resource (e.g., disk I/O, row lock) to release. kill mysql query
These commands will list all currently running queries, along with their IDs ( id column), the user running them, and the command being executed ( info or command column). Look for the query you want to terminate and note its ID. To terminate the entire session and the query