Comments - flush host
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.
Maybe I'm still misunderstanding, but I think that user stats (when enabled, of course) contain the info you want, or some of them. For example, to see blocked hosts: select client from client_statistics where denied_connections=max_connect_errors. Or denied_connections>0, depending on what you need to know. And when you flush hosts, you just flush client_statistics table ("flush clients") to keep the counter in sync.