首页 > 数据库技术 > 详细

MySQL批量杀进程

时间:2016-01-29 20:48:27      阅读:301      评论:0      收藏:0      [点我收藏+]

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

MySQL批量杀进程

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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!