mysql怎么批量kill session

有时候需要批量kill掉session，可以用以下办法，按照用户查出来，然后session信息，放到一个文件里，然后执行

select concat('KILL ',id,';') from information_schema.processlist where user='xxx' into outfile '/var/lib/mysql-files/xxx.txt';

select concat('KILL ',id,';') from information_schema.processlist where user='for_fin' into outfile '/var/lib/mysql-files/for_fin.txt';

select concat('KILL ',id,';') from information_schema.processlist where user='for_201' into outfile '/var/lib/mysql-files/for_201.txt';

select concat('KILL ',id,';') from information_schema.processlist where user='for_fin_ro' into outfile '/var/lib/mysql-files/for_fin_ro.txt';

下面是执行这些session

source /var/lib/mysql-files/xxx.txt;

source /var/lib/mysql-files/for_fin.txt;

source /var/lib/mysql-files/for_201.txt;

source /var/lib/mysql-files/for_fin_ro.txt;