OS: CentOS 6.3
DB:5.5.14
mysql> show processlist;
+----+------+-----------+--------------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+-----------+--------------------+---------+------+-------+------------------+
| 37 | root | localhost | information_schema | Query | 0 | NULL | show processlist |
| 38 | root | localhost | NULL | Sleep | 559 | | NULL |
+----+------+-----------+--------------------+---------+------+-------+------------------+
mysql> kill 40;
1 row in set (0.00 sec)
mysql> use information_schema
mysql> select id from processlist;
+----+
| id |
+----+
| 40 |
+----+
1 row in set (0.00 sec)
mysql> select concat('kill ',id,';') from information_schema.processlist where user='root' into outfile '/export/yoon.txt';
Query OK, 1 row affected (0.09 sec)
[root@db01 export]# more yoon.txt
kill 40;
批量删除会话:
mysql> source /export/yoon.txt