`

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会阻止。
分享到:
评论

相关推荐

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

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

    微软内部资料-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 ...

    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 ...

    The Cache Performance and Optimizations of Blocked Algorithms - 1991 (lam-asplos91)-计算机科学

    WolfComputer Systems LaboratoryStanford University, CA 94305AbstractBlocking is a well-known optimization technique for improvingthe effectiveness of memory hierarchies. Instead of operating onentire...

    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- ...

    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 ...

    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 ...

    图像特征提取方法的研究.caj

    On the other hand, in real application efficiency is also an important indicator to assess one algorithm, because in many cases only algorithms with high efficiency can satisfy request of real task....

    python_github_calendar_api

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

    iframe跨域问题

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

    精美的js日期控件,可以多个参数设定。

    There is an optional additional value which is day of the week (0 - 6 with 0 being Sunday). For example blocked: ['0 * 2007 0,6'] would disable all weekends (saturdays and sundays) in 2007. * ...

    tci6636k2h

    KeyStone is the first of its kind in that it provides adequate internal bandwidth for nonblocking access to all processing cores, peripherals, coprocessors, and I/O. This is achieved with four main ...

    SQL Server并发性:锁定,阻止和行版本控制SQL Server Concurrency: Locking, Blocking and Row Versioning

    一本面向想要了解SQL Server并发性以及如何解决过多的阻塞或死锁问题的DBA和开发人员的书。

Global site tag (gtag.js) - Google Analytics