Mass Killing Mysql Process

  Mass Killing Mysql Process

mysql> select concat('KILL ',id,';') from information_schema.processlist where user='root';

+------------------------+
| concat('KILL ',id,';') |
+------------------------+
| KILL 3101;             |
| KILL 2946;             |
+------------------------+

2 rows in set (0.00 sec)

mysql> select concat('KILL ',id,';') from information_schema.processlist where user='root' into outfile '/tmp/a.txt';

Query OK, 2 rows affected (0.00 sec)

mysql> source /tmp/a.txt;


Query OK, 0 rows affected (0.00 sec)

That's It.