MySQL Process

How to kill all MySQL sleep process.

If you want to kill all sleep process in MySQL go to MySQL terminal and follow:-


mysql >select concat('KILL ',id,';') FROM information_schema.processlist where user='root' into outfile '/tmp/xyz.txt';
mysql> source /tmp/zyz.txt;​