Kill a long running blocking sql statement

Databases
InterBase (29)
MS-SQL (5)
mysql (37)
Oracle (1)

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.


	// get process ID of blocking process mysqladmin -uroot -pROOT_PASSWORD_HERE processlist // kill it mysqladmin -uroot -pROOT_PASSWORD_HERE kill 1234

Content-type: text/html

Send a message to
Subject

Comments:

NEW: Optional: Register Login Email address (not necessary): Rate as	Hide my email when showing my comment. Please notify me once a day about new comments on this topic. Please provide a valid email address if you select this option, or post under a registered account.

	Show city and country Show country only Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material. Add a picture:


	Search: