Comments - flush host

10 years, 7 months ago massimo disaro

Mariadb 10 is not GA so i will not move in production. I run Maria 55. The max_connect_errors can increase for many reasons (not only connection errors), that s why i am looking for the hosts in cache and not the connection fail from the hosts. They are different things, please do not confuse.

 
10 years, 7 months ago Federico Razzoli

I forgot about "user statistics": https://kb.askmonty.org/en/user-statistics/ I don't know if CLIENT_STATISTICS table covers all possible causes of an max_connect_errors increment... look at its columns.

 
10 years, 7 months ago massimo disaro

Scusa Federico, but this out of topic. statistics, as u can see, need to be enable and they collect information until u dont disable (userstat = 1). My question is different: how to see the hosts present in the cache , before the command FLUSH HOSTS. Jeremy created "SHOW HOST_CACHE" for a patch, does Maria 55 has something similar?

 
10 years, 7 months ago Federico Razzoli

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.

 
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.