DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Kill a long running blocking sql statement

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
 

Generated 16:00:37 on Dec 14, 2017