1
OBJECT_TYPE
enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'T...
utf8mb3_general_ci
Yes
NULL
Object type for which the summary is generated.
2
OBJECT_SCHEMA
varchar(64)
utf8mb3_general_ci
No
None
The schema of the object for which the summary is generated.
3
OBJECT_NAME
varchar(64)
utf8mb3_general_ci
No
None
The name of the object for which the summary is generated.
4
COUNT_STAR
bigint(20)
UNSIGNED
No
None
The number of summarized events (from events_statements_current). This value includes all events, whether timed or nontimed.
5
SUM_TIMER_WAIT
bigint(20)
UNSIGNED
No
None
The total wait time of the summarized timed events. This value is calculated only for timed events because nontimed events have a wait time of NULL. The same is true for the other xxx_TIMER_WAIT values.
6
MIN_TIMER_WAIT
bigint(20)
UNSIGNED
No
None
The minimum wait time of the summarized timed events.
7
AVG_TIMER_WAIT
bigint(20)
UNSIGNED
No
None
The average wait time of the summarized timed events.
8
MAX_TIMER_WAIT
bigint(20)
UNSIGNED
No
None
The maximum wait time of the summarized timed events.
9
COUNT_STATEMENTS
bigint(20)
UNSIGNED
No
None
Total number of nested statements invoked during stored program execution.
10
SUM_STATEMENTS_WAIT
bigint(20)
UNSIGNED
No
None
The total wait time of the summarized timed statements. This value is calculated only for timed statements because nontimed statements have a wait time of NULL. The same is true for the other xxx_STATEMENT_WAIT values.
11
MIN_STATEMENTS_WAIT
bigint(20)
UNSIGNED
No
None
The minimum wait time of the summarized timed statements.
12
AVG_STATEMENTS_WAIT
bigint(20)
UNSIGNED
No
None
The average wait time of the summarized timed statements.
13
MAX_STATEMENTS_WAIT
bigint(20)
UNSIGNED
No
None
The maximum wait time of the summarized timed statements.
14
SUM_LOCK_TIME
bigint(20)
UNSIGNED
No
None
The total time spent (in picoseconds) waiting for table locks for the summarized statements.
15
SUM_ERRORS
bigint(20)
UNSIGNED
No
None
The total number of errors that occurend for the summarized statements.
16
SUM_WARNINGS
bigint(20)
UNSIGNED
No
None
The total number of warnings that occurend for the summarized statements.
17
SUM_ROWS_AFFECTED
bigint(20)
UNSIGNED
No
None
The total number of affected rows by the summarized statements.
18
SUM_ROWS_SENT
bigint(20)
UNSIGNED
No
None
The total number of rows returned by the summarized statements.
19
SUM_ROWS_EXAMINED
bigint(20)
UNSIGNED
No
None
The total number of rows examined by the summarized statements.
20
SUM_CREATED_TMP_DISK_TABLES
bigint(20)
UNSIGNED
No
None
The total number of on-disk temporary tables created by the summarized statements.
21
SUM_CREATED_TMP_TABLES
bigint(20)
UNSIGNED
No
None
The total number of in-memory temporary tables created by the summarized statements.
22
SUM_SELECT_FULL_JOIN
bigint(20)
UNSIGNED
No
None
The total number of full joins executed by the summarized statements.
23
SUM_SELECT_FULL_RANGE_JOIN
bigint(20)
UNSIGNED
No
None
The total number of range search joins executed by the summarized statements.
24
SUM_SELECT_RANGE
bigint(20)
UNSIGNED
No
None
The total number of joins that used ranges on the first table executed by the summarized statements.
25
SUM_SELECT_RANGE_CHECK
bigint(20)
UNSIGNED
No
None
The total number of joins that check for key usage after each row executed by the summarized statements.
26
SUM_SELECT_SCAN
bigint(20)
UNSIGNED
No
None
The total number of joins that did a full scan of the first table executed by the summarized statements.
27
SUM_SORT_MERGE_PASSES
bigint(20)
UNSIGNED
No
None
The total number of merge passes that the sort algorithm has had to do for the summarized statements.
28
SUM_SORT_RANGE
bigint(20)
UNSIGNED
No
None
The total number of sorts that were done using ranges for the summarized statements.
29
SUM_SORT_ROWS
bigint(20)
UNSIGNED
No
None
The total number of sorted rows that were sorted by the summarized statements.
30
SUM_SORT_SCAN
bigint(20)
UNSIGNED
No
None
The total number of sorts that were done by scanning the table by the summarized statements.
31
SUM_NO_INDEX_USED
bigint(20)
UNSIGNED
No
None
The total number of statements that performed a table scan without using an index.
32
SUM_NO_GOOD_INDEX_USED
bigint(20)
UNSIGNED
No
None
The total number of statements where no good index was found.