Runaway Process

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;

Reference

• Mysql.com - Show Processlist
• Mysql.com - Kill
• Killing Mysql Runaway Query - mojocode

Comments

Name *
Email (For verification & Replies)
URL
Code   

Submit Comment

Show/Hide Comment form