1,使用pt-kill工具
[root@localhost ~]# pt-kill --user=root --password=123456 -hlocalhost --no-version-check --match-command Connect --match-state "Waiting in connection_control plugin" --victims all --interval 2 --print --kill
# 2021-02-18T09:49:28 KILL 218306 (Connect 38 sec) NULL
# 2021-02-18T09:49:28 KILL 218307 (Connect 37 sec) NULL
# 2021-02-18T09:49:28 KILL 218308 (Connect 36 sec) NULL
# 2021-02-18T09:49:28 KILL 218309 (Connect 35 sec) NULL
# 2021-02-18T09:49:28 KILL 218310 (Connect 34 sec) NULL
# 2021-02-18T09:49:28 KILL 218311 (Connect 33 sec) NULL
# 2021-02-18T09:49:28 KILL 218312 (Connect 32 sec) NULL
# 2021-02-18T09:49:28 KILL 218313 (Connect 31 sec) NULL
# 2021-02-18T09:49:28 KILL 218314 (Connect 30 sec) NULL
# 2021-02-18T09:49:28 KILL 218315 (Connect 29 sec) NULL
# 2021-02-18T09:49:28 KILL 218316 (Connect 28 sec) NULL
# 2021-02-18T09:49:28 KILL 218