mysql变量之max_connect_errors

max_connect_errors

默认值：10
作用：当某台主机尝试连接超过max_connect_errors后，mysql将屏蔽掉这个主机.
日志：mysqld启动时开启了--log-warnings，会得到一下信息

Host 'host_name' is blocked because of many connection errors.

解决方法：
1 shell> mysqladmin flush-hosts
shell> mysqld_safe --max_connect_errors=10000 &
2 mysql> flush hosts;
mysql> set global max_connect_errors=10000;