How to Find and Delete Queries in Mysql
Every once in a while I need to find and delete some rouge queries in MySQL. Here is how to show the list of queries for the current users:
SHOW PROCESSLIST;
Once the correct query has been identified the query can be killed like this:
KILL QUERY <ID>