summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/schema.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/perfschema/r/schema.result')
-rw-r--r--mysql-test/suite/perfschema/r/schema.result34
1 files changed, 1 insertions, 33 deletions
diff --git a/mysql-test/suite/perfschema/r/schema.result b/mysql-test/suite/perfschema/r/schema.result
index 7f1e1190634..d3b5572c383 100644
--- a/mysql-test/suite/perfschema/r/schema.result
+++ b/mysql-test/suite/perfschema/r/schema.result
@@ -38,7 +38,6 @@ events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
-host_cache
hosts
mutex_instances
objects_summary_global_by_type
@@ -649,38 +648,7 @@ file_summary_by_instance CREATE TABLE `file_summary_by_instance` (
`MAX_TIMER_MISC` bigint(20) unsigned NOT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
show create table host_cache;
-Table Create Table
-host_cache CREATE TABLE `host_cache` (
- `IP` varchar(64) NOT NULL,
- `HOST` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
- `HOST_VALIDATED` enum('YES','NO') NOT NULL,
- `SUM_CONNECT_ERRORS` bigint(20) NOT NULL,
- `COUNT_HOST_BLOCKED_ERRORS` bigint(20) NOT NULL,
- `COUNT_NAMEINFO_TRANSIENT_ERRORS` bigint(20) NOT NULL,
- `COUNT_NAMEINFO_PERMANENT_ERRORS` bigint(20) NOT NULL,
- `COUNT_FORMAT_ERRORS` bigint(20) NOT NULL,
- `COUNT_ADDRINFO_TRANSIENT_ERRORS` bigint(20) NOT NULL,
- `COUNT_ADDRINFO_PERMANENT_ERRORS` bigint(20) NOT NULL,
- `COUNT_FCRDNS_ERRORS` bigint(20) NOT NULL,
- `COUNT_HOST_ACL_ERRORS` bigint(20) NOT NULL,
- `COUNT_NO_AUTH_PLUGIN_ERRORS` bigint(20) NOT NULL,
- `COUNT_AUTH_PLUGIN_ERRORS` bigint(20) NOT NULL,
- `COUNT_HANDSHAKE_ERRORS` bigint(20) NOT NULL,
- `COUNT_PROXY_USER_ERRORS` bigint(20) NOT NULL,
- `COUNT_PROXY_USER_ACL_ERRORS` bigint(20) NOT NULL,
- `COUNT_AUTHENTICATION_ERRORS` bigint(20) NOT NULL,
- `COUNT_SSL_ERRORS` bigint(20) NOT NULL,
- `COUNT_MAX_USER_CONNECTIONS_ERRORS` bigint(20) NOT NULL,
- `COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS` bigint(20) NOT NULL,
- `COUNT_DEFAULT_DATABASE_ERRORS` bigint(20) NOT NULL,
- `COUNT_INIT_CONNECT_ERRORS` bigint(20) NOT NULL,
- `COUNT_LOCAL_ERRORS` bigint(20) NOT NULL,
- `COUNT_UNKNOWN_ERRORS` bigint(20) NOT NULL,
- `FIRST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `LAST_SEEN` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- `FIRST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00',
- `LAST_ERROR_SEEN` timestamp NULL DEFAULT '0000-00-00 00:00:00'
-) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8
+ERROR 42S02: Table 'performance_schema.host_cache' doesn't exist
show create table hosts;
Table Create Table
hosts CREATE TABLE `hosts` (