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/kill.txt’;
Query OK, 2 rows affected (0.00 sec)
mysql> source /tmp/kill.txt;
Query OK, 0 rows affected (0.00 sec)
mysql>SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root' INTO OUTFILE '/var/lib/mysql-files/kill.txt';
mysql>source /var/lib/mysql-files/kill.txt;