How to kill locked mysql queries
mysql, php
Solution
This can be done from the front page of phpMyAdmin. Look for the "Processes" link.
You can also run the command `SHOW PROCESSLIST` (or `SHOW FULL PROCESSLIST`). This will show you all the queries that you are able to manipulate (i.e. your own). Along with each query will be an identifier. You can issue the `KILL` command to any of those identifiers to kill the query.
Also, you should consider testing your query with `EXPLAIN`.
Problem
I am creating and testing a mysql join query but each time so far it causes the database tables to lockup and the site hangs. I have to then call the host and they kill the locked queries. Is this something I can do from phpmyadmin so not to bother them while I tweak the script to work? Thanks for any reply.