How to find MySQL process list and to kill those processes?
Here is the solution: Login to DB; Run a command show full processlist;to get the process id with status and query itself which causes the database hanging; Select the process id and run a command KILL <pid>; to kill that process. Sometimes it is not enough to kill each process manually. So, for that we’ve to go with … Read more