mysql 批量kill processlist

首先要查询mysql导出的目录路径

1. show global variables like '%secure_file_priv%';

2. mysql> SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='xxxx' INTO OUTFILE '/var/lib/mysql-files/killlist.txt';

3.mysql> source /var/lib/mysql-files/killlist.txt;