Flush Host Connection Blocked, but some connections allowed
2
votes
1
answer
2058
views
We are running Percona MySQL 5.6.30. We've had an issue where a PHP script on a different host was reporting an issue connecting to the database:
>Database may be down : SQLSTATE[HY000] Host 'x.x.x.101' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
We did the flush hosts, and it resolved the issue.
When we went back to check the Percona Audit Logs for the same time, we see a number of connections at that same time, from that same host ('x.x.x.101').
I'm trying to understand how a host could be blocked, and not blocked, at the same time. :) Any ideas?
Asked by Michael Dugas
(21 rep)
Aug 12, 2016, 07:00 PM
Last activity: Feb 6, 2025, 07:02 AM
Last activity: Feb 6, 2025, 07:02 AM