host_cache

ColumnTypeNullDefault Comments
IP varchar(64)No    
HOST varchar(255)Yes NULL   
HOST_VALIDATED enum('YES', 'NO')No    
SUM_CONNECT_ERRORS bigint(20)No    
COUNT_HOST_BLOCKED_ERRORS bigint(20)No    
COUNT_NAMEINFO_TRANSIENT_ERRORS bigint(20)No    
COUNT_NAMEINFO_PERMANENT_ERRORS bigint(20)No    
COUNT_FORMAT_ERRORS bigint(20)No    
COUNT_ADDRINFO_TRANSIENT_ERRORS bigint(20)No    
COUNT_ADDRINFO_PERMANENT_ERRORS bigint(20)No    
COUNT_FCRDNS_ERRORS bigint(20)No    
COUNT_HOST_ACL_ERRORS bigint(20)No    
COUNT_NO_AUTH_PLUGIN_ERRORS bigint(20)No    
COUNT_AUTH_PLUGIN_ERRORS bigint(20)No    
COUNT_HANDSHAKE_ERRORS bigint(20)No    
COUNT_PROXY_USER_ERRORS bigint(20)No    
COUNT_PROXY_USER_ACL_ERRORS bigint(20)No    
COUNT_AUTHENTICATION_ERRORS bigint(20)No    
COUNT_SSL_ERRORS bigint(20)No    
COUNT_MAX_USER_CONNECTIONS_ERRORS bigint(20)No    
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS bigint(20)No    
COUNT_DEFAULT_DATABASE_ERRORS bigint(20)No    
COUNT_INIT_CONNECT_ERRORS bigint(20)No    
COUNT_LOCAL_ERRORS bigint(20)No    
COUNT_UNKNOWN_ERRORS bigint(20)No    
FIRST_SEEN timestampNo 0000-00-00 00:00:00   
LAST_SEEN timestampNo 0000-00-00 00:00:00   
FIRST_ERROR_SEEN timestampYes 0000-00-00 00:00:00   
LAST_ERROR_SEEN timestampYes 0000-00-00 00:00:00