| 1 |
# Helper for hostcache_*.test |
| 2 |
|
| 3 |
--echo "Dumping performance_schema.host_cache" |
| 4 |
|
| 5 |
--disable_query_log |
| 6 |
--vertical_results |
| 7 |
select |
| 8 |
IP, HOST, HOST_VALIDATED, SUM_CONNECT_ERRORS, |
| 9 |
COUNT_HOST_BLOCKED_ERRORS, |
| 10 |
COUNT_NAMEINFO_TRANSIENT_ERRORS, |
| 11 |
COUNT_NAMEINFO_PERMANENT_ERRORS, |
| 12 |
COUNT_FORMAT_ERRORS, |
| 13 |
COUNT_ADDRINFO_TRANSIENT_ERRORS, |
| 14 |
COUNT_ADDRINFO_PERMANENT_ERRORS, |
| 15 |
COUNT_FCRDNS_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, |
| 23 |
COUNT_SSL_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, |
| 28 |
COUNT_LOCAL_ERRORS, |
| 29 |
COUNT_UNKNOWN_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; |
| 37 |
--horizontal_results |
| 38 |
--enable_query_log |
| 39 |
|