Bug #44894 Expose recorded connect_errors for hosts
Submitted: 15 May 2009 8:23 Modified: 26 Jun 2009 13:50
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:any OS:Any
Assigned to: CPU Architecture:Any
Tags: qc
Triage: Needs Triage: D5 (Feature request)

[15 May 2009 8:23] Peter Laursen
Description:
http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html

.. explains why the "Host 'host_name' is blocked" error may occur.  

But I do not find an option to display 'host connect_status'.  There is no SHOW statement and no data in Information_Schema exposing how many connect_errors were recorded for evey host (correct me if I am wrong and I will be happy!)

How to repeat:
see above.

Suggested fix:
consider to add statements

SHOW HOST_CONNECT_ERRORS

or 

SELECT host, connect_errors FROM I_S

(In my understanding the server must store this information in memory already.  Why not use I_S then? It should be possible to monitor and alert the issue *before* connections are refused)

One concern could be that this information should be privileged information (require SUPER privilege maybe)
[26 Jun 2009 13:50] Valeriy Kravchuk
Thank you for the feature request.