Cancel a mysql query

Probably your phpMyAdmin will be stuck showing the "Searching" message. What you can do is to open another tab / open a MySQL session with the console and do the following:

Look for all the processes running:

SHOW PROCESSLIST;

And then kill that specific thread with the KILL command:

KILL <thread_id>;

Resources:

  • SHOW PROCESSLIST page in MySQL
  • KILL page in MySQL

Sometimes, you can't even get to phpmyadmin even on a new tab.

If you have access to the environment via command line,

1) log into mysql mysql -u yourusername -p

2) SHOW PROCESSLIST;

3) KILL <thread_id>;


You could use the KILL statement : http://dev.mysql.com/doc/refman/5.0/en/kill.html


In phpMyAdmin, go to home page > Status; you'll see a list of your MySQL processes and you have a Kill link for each of them.