Kill a long running blocking sql statement
This article has not been rated yet. After reading, feel free to leave comments and rate it.
Question:I mistakenly started a SQL statement through a web interface that selects and inserts way to many records. How can I interrupt this?
Answer:If you had issued the SQL command in the mysql shell, you could just hit 'Control+C'. In your case, you can look at the process list and kill the process there.
If you have phpMyAdmin (web interface to mysql) installed, use this because it shows the process list with a KILL link for each.
You can also use the command line tool mysqladmin to view processes which returns the processes with their IDs. Then use the kill option of mysqladmin to kill your blocking process by its process ID.