mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) utilizing readline 5.1
Periodically I’ve to run
mysqladmin flush-hosts or else mysql refuses all of the connections in my subnet. Once I run this command, every little thing works once more. This often happens when different servers within the chain of occasions get backed up and this poor machine is left holding onto an enormous workload.
Every part I learn says flush hosts ’empties the host_cache desk’ however I do not see something referred to as that. I would not have a efficiency schema on this previous model of mysql.
In an effort to seek out out why these connections are problematic, I’ve turned on SET GLOBAL log_warnings = 2, no knowledge but however hopefully quickly. I’ve learn that generally Nagios causes this drawback and that along with solely having max_connect_errors set to 10, this may make sense. I’ve additionally learn that VPC peering can generally trigger this concern. I’m trying into these potentialities as nicely.