`

is blocked because of many connection errors; unblock with 'mysqladmin flush-hos

阅读更多
查看:
show variables like '%max%connect%er%'
set global max_connect_errors = 1000;

show variables like '%connect%timeout%';

performance_schema库中的 host_cache表

解决:
https://blog.csdn.net/iris_xuting/article/details/102689000/
https://www.cnblogs.com/susuyu/archive/2013/05/28/3104249.html

同一个ip在短时间内产生太多(超过mysql数据库max_connection_errors的最大值)中断的数据库连接而导致的阻塞;

这个表记录了 host 的缓存内容,缓存信息包括主机名和 IP,用于避免 DNS 查找。

show variables like '%max%connect%er%'

truncate performance_schema.host_cache

set global host_cache_size=0;


数据库的connect_timeout = 10,网络延迟基本在 14 秒以上。参数max_connect_errors控制同一个 IP连接连续错误次数多过参数max_connect_errors的值时,这之后的连接mysql会阻止。
分享到:
评论

相关推荐

    Java常见异常

    5. **ERROR 1129 (00000): Host ‘XXXXXX’ is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’** MySQL服务器将主机封锁,因为存在多次连接错误。使用`mysqladmin flush-...

    解决mysql出现大量TIME_WAIT

    如果MySQL出现“Host 'IP' is blocked because of many connection errors”的错误提示,表明由于过多的连接错误,该IP地址已被MySQL服务器封锁。此时,可以通过执行`mysqladmin flush-hosts -h IP -u root -p`命令...

    Your page is blocked due to a security的解决方案

    关于Your page is blocked due to a security的解决方案

    MySQL-Flush命令用法.docx#资源达人分享计划#

    使用 HOSTS 选项可以清空主机名缓存,这个选项通常用于清空主机名缓存以便解决 Host 'host_name' is blocked 错误。 3. LOGS:关闭并重新加载二进制日志文件。 使用 LOGS 选项可以关闭并重新加载二进制日志文件,...

    微软内部资料-SQL性能优化3

    Another type of table lock is a schema stability lock (Sch-S) and is compatible with all table locks except the schema modification lock (Sch-M). The schema modification lock (Sch-M) is incompatible ...

    一个小游戏

    Gameloft的笔试 Rules of Game: ---------... If one sphere is blocked because there is something underneath, the other one will continue falling (with no player control over it) until it reaches something.

    BURNINTEST--硬件检测工具

    Here is a summary of all changes that have been made in each version of BurnInTest. Release 5.3 build 1035 revision 4 WIN32 release 10 November 2008 - Lenovo China specific build. Lenovo system ...

    MySQL常见问题集锦详解-完整版.pdf

    解锁方法是运行`mysqladmin flush-hosts`。可以通过调整`max_connect_errors`变量来设置封锁前允许的最大错误次数。 5. **Too many connections**: 当达到`max_connections`限制时,无法建立更多连接。若需要增加...

    word自动转化为chm

    However, what bothers you most is not using how many kinds of tools, the Word file, the CHM file and the online documents are all need to be modified, this is the real matter. Once the changing work ...

    FlexGraphics_V_1.79_D4-XE10.2_Downloadly.ir

    - ADD: In TFlexPanel.DefaultLinkPoint property added Size field that lets define visual size of the connection points of the flex-connectors. Initialized with DefaultLinkPointSize constant in the ...

    Sakemail

    in the RetrieveHeaders function if the retrieved text was larger than 1024 bytes and the crlf.crlf fall in the middle of two chunks, the function is blocked. I don‘t use this function, btw.1.8.3.1- ...

    iframe跨域问题

    iframe跨域问题:Uncaught DOMException Blocked a frame with origin解决方法

    node-blocked, 检查事件循环是否已经被阻止.zip

    node-blocked, 检查事件循环是否已经被阻止 块检查 node 事件循环是否被阻止。如果运行 node.js ,你可以使用非常类似的阻止阻塞函数,从而使用非常类似的阻止阻塞函数。安装$ npm install blocked描述blocked() ...

    Node.js-当CPU旋转和退出程序的堆栈跟时找出node进程是否受阻

    Figure out if your node process is blocked because the CPU is spinning and exit the program with a stack trace if that is the case

    VclZip pro v3.10.1

    - By defining ZLIB121, VCLZip will use the latest version of ZLib which is included with the registered version. Some optimization improvements which should show some improvement in zipping and ...

    apache-maven-3.5.4

    Since Maven 3.8.1 http repositories are blocked. Possible solutions: - Check that Maven settings.xml does not contain http repositories - Check that Maven pom files do not contain ...

    python_hopelight_calendar_api

    若注册时提示Error:This user account is blocked.Contact support@vercel.com for more information. 这是由于Vercel不支持大部分国内邮箱。可以将github账号主邮箱改为Gmail邮箱。 但是根据群友React,将github...

    EurekaLog_7.5.0.0_Enterprise

    9)....Added: EMemLeaks._ReserveOutOfMemory to control reserve size of out of memory errors (default is 50 Mb) 10)..Added: "MinLeaksLimitObjs" option (EMemLeaks unit) 11)..Added: Fatal memory problem ...

    The Art of Assembly Language Programming

    You are visitor as of October 17, 1996. The Art of Assembly Language Programming <br>Forward Why Would Anyone Learn This Stuff? 1 What's Wrong With Assembly Language 2 What's Right With ...

Global site tag (gtag.js) - Google Analytics