I find it really annoying when my mysql processes run away. This doesn't happen very often so I can never remember the command.

Here are the commands to stop a run away process.

SHOW PROCESSLIST;

will show you the list of running processes, then to kill the process run

KILL thread_id;