Lost connection to MySQL server at 'waiting for initial communication packet', system error: 110

archery报错：
(2013, "Lost connection to MySQL server at 'waiting for initial communication packet', system error: 110")
说明MySQL存在大量错误连接，MySQL配置添加如下配置并重启。

skip-name-resolve
max_connect_errors=9000000000000
max_error_count=65500


此配置并不能解决问题。


cat >> /etc/hosts.allow <<EOF
mysqld : ALL : ALLOW
mysqld-max : ALL :ALLOW
EOF


show processlist 查看状态： 有大量的 unauthenticated user ，并且状态是 Connect
| 388 | unauthenticated user | connecting host   | NULL                     | Connect          |  347 | login                                                           | NULL                                                                                                 |  346597 |         0 |             0 |                                                             | NULL                                                                                                 |  346455 |         1 |             1 |
| 392 | unauthenticated user | connecting host   | NULL                     | Connect          |  347 | login                                                           | NULL                                                                                                 |  346453 |         0 |             0 |                                                              | NULL                                                                                                 |  345759 |         1 |             1 |
| 396 | unauthenticated user | connecting host   | NULL                     | Connect          |  346 | login                                                           | NULL                                                                                                 |  345758 |         0 |             0 |                                                               | NULL                                                                                                 |  344509 |         1 |             1 |
| 400 | unauthenticated user | connecting host   | NULL                     | Connect          |  345 | login                                                           | NULL                                                                                                 |  344506 |         0 |             0 |                                                                | NULL                                                                                                 |  342044 |         0 |             0 |
| 404 | unauthenticated user | connecting host   | NULL                     | Connect          |  342 | login                                                           | NULL                                                                                                 |  341805 |         0 |             0 |                                                               | NULL                                                                                                 |  327798 |         1 |             1 |
| 408 | unauthenticated user | connecting host   | NULL                     | Connect          |  328 | login                                                           | NULL                                                                                                 |  327797 |         0 |             0 |                                                               | NULL                                                                                                 |    5060 |         1 |             1 |
| 412 | unauthenticated user | connecting host   | NULL                     | Connect          |  289 | login                                                           | NULL                                                                                                 |  288456 |         0 |             0 |
| 416 | unauthenticated user | connecting host   | NULL                     | Connect          |  207 | login                                                           | NULL                                                                                                 |  206748 |         0 |             0 |
| 420 | unauthenticated user | connecting host   | NULL                     | Connect          |   47 | login                                                           | NULL                                                                                                 |   47099 |         0 |             0 |                                                             | NULL                                                                                                 |   46097 |         1 |             1 |
| 424 | unauthenticated user | connecting host   | NULL                     | Connect          |   46 | login                                                           | NULL                                                                                                 |   46096 |         0 |             0 |                                                    | NULL                                                                                                 |   45513 |         1 |             1 |
| 428 | unauthenticated user | connecting host   | NULL                     | Connect          |   46 | login                                                           | NULL                                                                                                 |   45512 |         0 |             0 |
| 432 | unauthenticated user | connecting host   | NULL                     | Connect          |   45 | login                                                           | NULL                                                                                                 |   44730 |         0 |             0 |
| 436 | unauthenticated user | connecting host   | NULL                     | Connect          |   42 | login                                                           | NULL                                                                                                 |   41443 |         0 |             0 |
| 440 | unauthenticated user | connecting host   | NULL                     | Connect          |   27 | login                                                           | NULL                                                                                                 |   26734 |         0 |             0 |




修改 线程池相关 相关参数：
set global thread_pool_idle_timeout      = 36600;
set global thread_pool_max_threads       = 100000;
set global thread_pool_size              = 128;
set global thread_pool_stall_limit       = 2500;


参考文档：  出现 unauthenticated user Connect 怎么办【 https://mp.weixin.qq.com/s/O2jmVeSNfhpq-CwR96Rg4w】