|
|
1 |
|
enum('EVENT', 'FUNCTION', 'PROCEDURE', 'TABLE', 'T...
|
utf8mb3_general_ci
|
|
Yes |
NULL |
Object type for which the summary is generated.
|
|
|
|
2 |
|
varchar(64)
|
utf8mb3_general_ci
|
|
No |
None |
The schema of the object for which the summary is generated.
|
|
|
|
3 |
|
varchar(64)
|
utf8mb3_general_ci
|
|
No |
None |
The name of the object for which the summary is generated.
|
|
|
|
4 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The number of summarized events (from events_statements_current). This value includes all events, whether timed or nontimed.
|
|
|
|
5 |
|
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 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The minimum wait time of the summarized timed events.
|
|
|
|
7 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The average wait time of the summarized timed events.
|
|
|
|
8 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The maximum wait time of the summarized timed events.
|
|
|
|
9 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
Total number of nested statements invoked during stored program execution.
|
|
|
|
10 |
|
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 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The minimum wait time of the summarized timed statements.
|
|
|
|
12 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The average wait time of the summarized timed statements.
|
|
|
|
13 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The maximum wait time of the summarized timed statements.
|
|
|
|
14 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total time spent (in picoseconds) waiting for table locks for the summarized statements.
|
|
|
|
15 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of errors that occurend for the summarized statements.
|
|
|
|
16 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of warnings that occurend for the summarized statements.
|
|
|
|
17 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of affected rows by the summarized statements.
|
|
|
|
18 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of rows returned by the summarized statements.
|
|
|
|
19 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of rows examined by the summarized statements.
|
|
|
|
20 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of on-disk temporary tables created by the summarized statements.
|
|
|
|
21 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of in-memory temporary tables created by the summarized statements.
|
|
|
|
22 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of full joins executed by the summarized statements.
|
|
|
|
23 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of range search joins executed by the summarized statements.
|
|
|
|
24 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of joins that used ranges on the first table executed by the summarized statements.
|
|
|
|
25 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of joins that check for key usage after each row executed by the summarized statements.
|
|
|
|
26 |
|
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 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of merge passes that the sort algorithm has had to do for the summarized statements.
|
|
|
|
28 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of sorts that were done using ranges for the summarized statements.
|
|
|
|
29 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of sorted rows that were sorted by the summarized statements.
|
|
|
|
30 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of sorts that were done by scanning the table by the summarized statements.
|
|
|
|
31 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of statements that performed a table scan without using an index.
|
|
|
|
32 |
|
bigint(20)
|
|
UNSIGNED |
No |
None |
The total number of statements where no good index was found.
|
|