批量杀进程mysql_MySQL批量杀进程

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)

[[email protected] export]# more yoon.txt

kill 40;

批量删除会话：

mysql> source /export/yoon.txt

原文：http://www.cnblogs.com/hankyoon/p/5169623.html