1 # Helper for hostcache_*.test
3 --echo
"Dumping performance_schema.host_cache"
8 IP, HOST, HOST_VALIDATED, SUM_CONNECT_ERRORS,
9 COUNT_HOST_BLOCKED_ERRORS,
10 COUNT_NAMEINFO_TRANSIENT_ERRORS,
11 COUNT_NAMEINFO_PERMANENT_ERRORS,
13 COUNT_ADDRINFO_TRANSIENT_ERRORS,
14 COUNT_ADDRINFO_PERMANENT_ERRORS,
16 COUNT_HOST_ACL_ERRORS,
17 COUNT_NO_AUTH_PLUGIN_ERRORS,
18 COUNT_AUTH_PLUGIN_ERRORS,
19 COUNT_HANDSHAKE_ERRORS,
20 COUNT_PROXY_USER_ERRORS,
21 COUNT_PROXY_USER_ACL_ERRORS,
22 COUNT_AUTHENTICATION_ERRORS,
24 COUNT_MAX_USER_CONNECTIONS_ERRORS,
25 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS,
26 COUNT_DEFAULT_DATABASE_ERRORS,
27 COUNT_INIT_CONNECT_ERRORS,
30 if (FIRST_ERROR_SEEN is not null,
31 if (FIRST_ERROR_SEEN > date(
"2012-01-01"),
"set",
"wrong epoch"),
32 "null") as FIRST_ERROR_SEEN,
33 if (LAST_ERROR_SEEN is not null,
34 if (FIRST_ERROR_SEEN > date(
"2012-01-01"),
"set",
"wrong epoch"),
35 "null") as LAST_ERROR_SEEN
36 from performance_schema.host_cache;