Shulou(Shulou.com)06/01 Report--

If a process is found to be abnormal under normal circumstances.

The process can be killed by kill id

But if the access is deleted in large quantities, it can't be killed by hand.

The command is as follows

Handling method (get the abnormal id through mysql-e, and then pass the value to mysqladmin through the xargs command)

This is the result of the test environment itself.

Mysql-udba-paired recording procedures *-h 192.1.1.1-P 3700-BNe\

"select id from information_schema.processlist where time > = '500' and command='sleep';"\

| | / usr/bin/xargs-n 1 mysqladmin-udba-p *-h 192.1.1.1-P 3700 kill |

If it is a production environment

Mysql-udba-paired recording procedures *-h 192.1.1.1-P 3700-BNe\

"select id from information_schema.processlist where STATE='Sending data';"\

| | / usr/bin/xargs-n 1 mysqladmin-udba-paired kill *-h 192.1.1.1-P 3700 kill |

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.