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