Debian Codegraph @

mysql-test/suite/perfschema/r/idx_events_waits_history_long.result

raw
1 show create table performance_schema.events_waits_history_long;
2 Table Create Table
3 events_waits_history_long CREATE TABLE `events_waits_history_long` (
4 `THREAD_ID` bigint unsigned NOT NULL,
5 `EVENT_ID` bigint unsigned NOT NULL,
6 `END_EVENT_ID` bigint unsigned DEFAULT NULL,
7 `EVENT_NAME` varchar(128) NOT NULL,
8 `SOURCE` varchar(64) DEFAULT NULL,
9 `TIMER_START` bigint unsigned DEFAULT NULL,
10 `TIMER_END` bigint unsigned DEFAULT NULL,
11 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
12 `SPINS` int unsigned DEFAULT NULL,
13 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
14 `OBJECT_NAME` varchar(512) DEFAULT NULL,
15 `INDEX_NAME` varchar(64) DEFAULT NULL,
16 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
17 `OBJECT_INSTANCE_BEGIN` bigint unsigned NOT NULL,
18 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
19 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
20 `OPERATION` varchar(32) NOT NULL,
21 `NUMBER_OF_BYTES` bigint DEFAULT NULL,
22 `FLAGS` int unsigned DEFAULT NULL
23 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
24 select * from INFORMATION_SCHEMA.STATISTICS
25 where TABLE_SCHEMA = "performance_schema"
26 and TABLE_NAME = "events_waits_history_long";
27 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IS_VISIBLE EXPRESSION