1
SCHEMA_NAME
varchar(64)
utf8_general_ci
Yes
NULL
Database name. Records are summarised together with DIGEST.
2
DIGEST
varchar(32)
utf8_general_ci
Yes
NULL
Performance Schema digest. Records are summarised together with SCHEMA NAME.
3
DIGEST_TEXT
longtext
utf8_general_ci
Yes
NULL
The unhashed form of the digest.
4
COUNT_STAR
bigint(20)
UNSIGNED
No
None
Number of summarized events
5
SUM_TIMER_WAIT
bigint(20)
UNSIGNED
No
None
Total wait time of the summarized events that are timed.
6
MIN_TIMER_WAIT
bigint(20)
UNSIGNED
No
None
Minimum wait time of the summarized events that are timed.
7
AVG_TIMER_WAIT
bigint(20)
UNSIGNED
No
None
Average wait time of the summarized events that are timed.
8
MAX_TIMER_WAIT
bigint(20)
UNSIGNED
No
None
Maximum wait time of the summarized events that are timed.
9
SUM_LOCK_TIME
bigint(20)
UNSIGNED
No
None
Sum of the LOCK_TIME column in the events_statements_current table.
10
SUM_ERRORS
bigint(20)
UNSIGNED
No
None
Sum of the ERRORS column in the events_statements_current table.
11
SUM_WARNINGS
bigint(20)
UNSIGNED
No
None
Sum of the WARNINGS column in the events_statements_current table.
12
SUM_ROWS_AFFECTED
bigint(20)
UNSIGNED
No
None
Sum of the ROWS_AFFECTED column in the events_statements_current table.
13
SUM_ROWS_SENT
bigint(20)
UNSIGNED
No
None
Sum of the ROWS_SENT column in the events_statements_current table.
14
SUM_ROWS_EXAMINED
bigint(20)
UNSIGNED
No
None
Sum of the ROWS_EXAMINED column in the events_statements_current table.
15
SUM_CREATED_TMP_DISK_TABLES
bigint(20)
UNSIGNED
No
None
Sum of the CREATED_TMP_DISK_TABLES column in the events_statements_current table.
16
SUM_CREATED_TMP_TABLES
bigint(20)
UNSIGNED
No
None
Sum of the CREATED_TMP_TABLES column in the events_statements_current table.
17
SUM_SELECT_FULL_JOIN
bigint(20)
UNSIGNED
No
None
Sum of the SELECT_FULL_JOIN column in the events_statements_current table.
18
SUM_SELECT_FULL_RANGE_JOIN
bigint(20)
UNSIGNED
No
None
Sum of the SELECT_FULL_RANGE_JOIN column in the events_statements_current table.
19
SUM_SELECT_RANGE
bigint(20)
UNSIGNED
No
None
Sum of the SELECT_RANGE column in the events_statements_current table.
20
SUM_SELECT_RANGE_CHECK
bigint(20)
UNSIGNED
No
None
Sum of the SELECT_RANGE_CHECK column in the events_statements_current table.
21
SUM_SELECT_SCAN
bigint(20)
UNSIGNED
No
None
Sum of the SELECT_SCAN column in the events_statements_current table.
22
SUM_SORT_MERGE_PASSES
bigint(20)
UNSIGNED
No
None
Sum of the SORT_MERGE_PASSES column in the events_statements_current table.
23
SUM_SORT_RANGE
bigint(20)
UNSIGNED
No
None
Sum of the SORT_RANGE column in the events_statements_current table.
24
SUM_SORT_ROWS
bigint(20)
UNSIGNED
No
None
Sum of the SORT_ROWS column in the events_statements_current table.
25
SUM_SORT_SCAN
bigint(20)
UNSIGNED
No
None
Sum of the SORT_SCAN column in the events_statements_current table.
26
SUM_NO_INDEX_USED
bigint(20)
UNSIGNED
No
None
Sum of the NO_INDEX_USED column in the events_statements_current table.
27
SUM_NO_GOOD_INDEX_USED
bigint(20)
UNSIGNED
No
None
Sum of the NO_GOOD_INDEX_USED column in the events_statements_current table.
28
FIRST_SEEN
timestamp
No
0000-00-00 00:00:00
Time at which the digest was first seen.
29
LAST_SEEN
timestamp
No
0000-00-00 00:00:00
Time at which the digest was most recently seen.