MySQL Forums
Forum List  »  Connector/ODBC

host_cache operation
Posted by: Louis Seefried
Date: March 05, 2024 11:20AM

We have multiple MySQL servers running 5.7 and 8.x. We are encountering errors with connections to these hosts and when we attempt to connect via telnet to verify network connectivity, we are getting the error:

Host 'x.x.x.x' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host.

We run flush hosts to clear the cache but i am trying to find out if the host_cache counter resets itself for a particular ip address as part of normal operation (maybe after a successful connection from the ip address).

If the value only goes up and would never reset based upon the default behavior, is there any tuning that can be done short of disabling the setting or putting the value to a theoretically unreachable number?

Options: ReplyQuote


Subject
Written By
Posted
host_cache operation
March 05, 2024 11:20AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.