Debian Codegraph @

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

raw
1 show create table performance_schema.events_statements_history_long;
2 Table Create Table
3 events_statements_history_long CREATE TABLE `events_statements_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 `LOCK_TIME` bigint unsigned NOT NULL,
13 `SQL_TEXT` longtext,
14 `DIGEST` varchar(64) DEFAULT NULL,
15 `DIGEST_TEXT` longtext,
16 `CURRENT_SCHEMA` varchar(64) DEFAULT NULL,
17 `OBJECT_TYPE` varchar(64) DEFAULT NULL,
18 `OBJECT_SCHEMA` varchar(64) DEFAULT NULL,
19 `OBJECT_NAME` varchar(64) DEFAULT NULL,
20 `OBJECT_INSTANCE_BEGIN` bigint unsigned DEFAULT NULL,
21 `MYSQL_ERRNO` int DEFAULT NULL,
22 `RETURNED_SQLSTATE` varchar(5) DEFAULT NULL,
23 `MESSAGE_TEXT` varchar(128) DEFAULT NULL,
24 `ERRORS` bigint unsigned NOT NULL,
25 `WARNINGS` bigint unsigned NOT NULL,
26 `ROWS_AFFECTED` bigint unsigned NOT NULL,
27 `ROWS_SENT` bigint unsigned NOT NULL,
28 `ROWS_EXAMINED` bigint unsigned NOT NULL,
29 `CREATED_TMP_DISK_TABLES` bigint unsigned NOT NULL,
30 `CREATED_TMP_TABLES` bigint unsigned NOT NULL,
31 `SELECT_FULL_JOIN` bigint unsigned NOT NULL,
32 `SELECT_FULL_RANGE_JOIN` bigint unsigned NOT NULL,
33 `SELECT_RANGE` bigint unsigned NOT NULL,
34 `SELECT_RANGE_CHECK` bigint unsigned NOT NULL,
35 `SELECT_SCAN` bigint unsigned NOT NULL,
36 `SORT_MERGE_PASSES` bigint unsigned NOT NULL,
37 `SORT_RANGE` bigint unsigned NOT NULL,
38 `SORT_ROWS` bigint unsigned NOT NULL,
39 `SORT_SCAN` bigint unsigned NOT NULL,
40 `NO_INDEX_USED` bigint unsigned NOT NULL,
41 `NO_GOOD_INDEX_USED` bigint unsigned NOT NULL,
42 `NESTING_EVENT_ID` bigint unsigned DEFAULT NULL,
43 `NESTING_EVENT_TYPE` enum('TRANSACTION','STATEMENT','STAGE','WAIT') DEFAULT NULL,
44 `NESTING_EVENT_LEVEL` int DEFAULT NULL,
45 `STATEMENT_ID` bigint unsigned DEFAULT NULL,
46 `CPU_TIME` bigint unsigned NOT NULL,
47 `MAX_CONTROLLED_MEMORY` bigint unsigned NOT NULL,
48 `MAX_TOTAL_MEMORY` bigint unsigned NOT NULL,
49 `EXECUTION_ENGINE` enum('PRIMARY','SECONDARY') DEFAULT NULL
50 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
51 select * from INFORMATION_SCHEMA.STATISTICS
52 where TABLE_SCHEMA = "performance_schema"
53 and TABLE_NAME = "events_statements_history_long";
54 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