Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to kill MySQL in batches. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Kill all current MySQL connections

Method 1:

$mysql-u root-p

Enter password: *

Mysql > select concat ('KILL', id,';') from information_schema.processlist where user='root'

+-- +

| | concat ('KILL', id,';') | |

+-- +

| | KILL 9; | |

| | KILL 8; | |

+-- +

2 rows in set (0.02 sec)

Mysql > select concat ('KILL', id,';') from information_schema.processlist where user='root' into outfile'/ tmp/kill.txt'

Query OK, 2 rows affected (0.00 sec)

Mysql > source / tmp/kill.txt

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Method 2:

Shell foot method:

$for id in `mysqladmin processlist | awk'{print $2} '`do mysqladmin-uroot-p123456 kill $id done

The above is the editor for you to share how to mass kill MySQL process, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.