flush host

i have looking for info how to 'read' info which are the hosts that hit the max_connect_errors. I have found there was a patch of Jeremy Cole, but i have not found anything for Mariadb. Is there a way to know which hosts increase the max_connect_errors?? any from SHOW or information_schema?

thanks a lot

Answer Answered by Daniel Bartholomew in this comment.

I don't think there's anything like SHOW HOST_CACHE in MariaDB 5.5.

In MariaDB 10.0, if you enable the performance_schema there is a hosts table that I think has the information you're looking for. This table does not exist in the MariaDB 5.5 performance_schema.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.