有时候需要批量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';
- 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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20893244/viewspace-2155057/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20893244/viewspace-2155057/