1月 18th, 2009

Host ‘XXXXXX’ is blocked because of many connection errors

Category: mysql, Author: admin, Popularity: 26%

ERROR 1129 (00000): Host ‘XXXXXX’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’

这说明mysqld已经得到了大量(max_connect_errors)的主机’hostname’的在中途被中断了的连接请求。在 max_connect_errors次失败请求后,mysqld认为数据库出错了,并且阻止该站点进一步的连接,直到有人执行命令 mysqladmin flush-hosts。

缺省地,mysqld在10个连接错误后阻塞一台主机。你可以通过很容易地调整它:
set global max_connect_errors=1000;

注意,对给定的主机,如果得到这个错误消息,你应该首先检查该主机的TCP/IP连接有没有问题。如果你的TCP/IP连接不在运行,增加max_connect_errors变量的值也不会有帮助!

热门日志

Tags:.
评论数量() | Add Comments
本文网址:http://www.9usb.net/200901/host-blocked-errors.html

There are No comments.

» You can leave a response

leave a reply