MySQL Runaway Process
It’s really annoying when a mysql processes gets stuck or runs away. Here are the commands to stop a run away process, after you have logged into mysql.
SHOW PROCESSLIST;
will show you the list of running processes, then to kill the process run
KILL thread_id;