Debian Codegraph @

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

raw
1 show create table performance_schema.events_transactions_history_long;
2 Table Create Table
3 events_transactions_history_long CREATE TABLE `events_transactions_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 `STATE` enum('ACTIVE','COMMITTED','ROLLED BACK') DEFAULT NULL,
9 `TRX_ID` bigint unsigned DEFAULT NULL,
10 `GTID` varchar(64) DEFAULT NULL,
11 `XID_FORMAT_ID` int DEFAULT NULL,
12 `XID_GTRID` varchar(130) DEFAULT NULL,
13 `XID_BQUAL` varchar(130) DEFAULT NULL,
14 `XA_STATE` varchar(64) DEFAULT NULL,
15 `SOURCE` varchar(64) DEFAULT NULL,
16 `TIMER_START` bigint unsigned DEFAULT NULL,
17 `TIMER_END` bigint unsigned DEFAULT NULL,
18 `TIMER_WAIT` bigint unsigned DEFAULT NULL,
19 `ACCESS_MODE` enum('READ ONLY','READ WRITE') DEFAULT NULL,
20 `ISOLATION_LEVEL` varchar(64) DEFAULT NULL,
21 `AUTOCOMMIT` enum('YES','NO') NOT NULL,
22 `NUMBER_OF_SAVEPOINTS` bigint unsigned DEFAULT NULL,
23 `NUMBER_OF_ROLLBACK_TO_SAVEPOINT` bigint unsigned DEFAULT NULL,
24 `NUMBER_OF_RELEASE_SAVEPOINT` bigint unsigned DEFAULT NULL,
25 `OBJECT_INSTANCE_BEGIN` bigint unsigned DEFAULT NULL,
26 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
27 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL
28 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
29 select * from INFORMATION_SCHEMA.STATISTICS
30 where TABLE_SCHEMA = "performance_schema"
31 and TABLE_NAME = "events_transactions_history_long";
32 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