1
OBJECT_TYPE
varchar(64)
utf8_general_ci
Sí
NULL
Since this table records waits by table, always set to TABLE.
2
OBJECT_SCHEMA
varchar(64)
utf8_general_ci
Sí
NULL
Schema name.
3
OBJECT_NAME
varchar(64)
utf8_general_ci
Sí
NULL
Table name.
4
COUNT_STAR
bigint(20)
UNSIGNED
No
Ninguna
Number of summarized events and the sum of the x_READ and x_WRITE columns.
5
SUM_TIMER_WAIT
bigint(20)
UNSIGNED
No
Ninguna
Total wait time of the summarized events that are timed.
6
MIN_TIMER_WAIT
bigint(20)
UNSIGNED
No
Ninguna
Minimum wait time of the summarized events that are timed.
7
AVG_TIMER_WAIT
bigint(20)
UNSIGNED
No
Ninguna
Average wait time of the summarized events that are timed.
8
MAX_TIMER_WAIT
bigint(20)
UNSIGNED
No
Ninguna
Maximum wait time of the summarized events that are timed.
9
COUNT_READ
bigint(20)
UNSIGNED
No
Ninguna
Number of all read operations, and the sum of the equivalent x_FETCH columns.
10
SUM_TIMER_READ
bigint(20)
UNSIGNED
No
Ninguna
Total wait time of all read operations that are timed.
11
MIN_TIMER_READ
bigint(20)
UNSIGNED
No
Ninguna
Minimum wait time of all read operations that are timed.
12
AVG_TIMER_READ
bigint(20)
UNSIGNED
No
Ninguna
Average wait time of all read operations that are timed.
13
MAX_TIMER_READ
bigint(20)
UNSIGNED
No
Ninguna
Maximum wait time of all read operations that are timed.
14
COUNT_WRITE
bigint(20)
UNSIGNED
No
Ninguna
Number of all write operations, and the sum of the equivalent x_INSERT, x_UPDATE and x_DELETE columns.
15
SUM_TIMER_WRITE
bigint(20)
UNSIGNED
No
Ninguna
Total wait time of all write operations that are timed.
16
MIN_TIMER_WRITE
bigint(20)
UNSIGNED
No
Ninguna
Minimum wait time of all write operations that are timed.
17
AVG_TIMER_WRITE
bigint(20)
UNSIGNED
No
Ninguna
Average wait time of all write operations that are timed.
18
MAX_TIMER_WRITE
bigint(20)
UNSIGNED
No
Ninguna
Maximum wait time of all write operations that are timed.
19
COUNT_FETCH
bigint(20)
UNSIGNED
No
Ninguna
Number of all fetch operations.
20
SUM_TIMER_FETCH
bigint(20)
UNSIGNED
No
Ninguna
Total wait time of all fetch operations that are timed.
21
MIN_TIMER_FETCH
bigint(20)
UNSIGNED
No
Ninguna
Minimum wait time of all fetch operations that are timed.
22
AVG_TIMER_FETCH
bigint(20)
UNSIGNED
No
Ninguna
Average wait time of all fetch operations that are timed.
23
MAX_TIMER_FETCH
bigint(20)
UNSIGNED
No
Ninguna
Maximum wait time of all fetch operations that are timed.
24
COUNT_INSERT
bigint(20)
UNSIGNED
No
Ninguna
Number of all insert operations.
25
SUM_TIMER_INSERT
bigint(20)
UNSIGNED
No
Ninguna
Total wait time of all insert operations that are timed.
26
MIN_TIMER_INSERT
bigint(20)
UNSIGNED
No
Ninguna
Minimum wait time of all insert operations that are timed.
27
AVG_TIMER_INSERT
bigint(20)
UNSIGNED
No
Ninguna
Average wait time of all insert operations that are timed.
28
MAX_TIMER_INSERT
bigint(20)
UNSIGNED
No
Ninguna
Maximum wait time of all insert operations that are timed.
29
COUNT_UPDATE
bigint(20)
UNSIGNED
No
Ninguna
Number of all update operations.
30
SUM_TIMER_UPDATE
bigint(20)
UNSIGNED
No
Ninguna
Total wait time of all update operations that are timed.
31
MIN_TIMER_UPDATE
bigint(20)
UNSIGNED
No
Ninguna
Minimum wait time of all update operations that are timed.
32
AVG_TIMER_UPDATE
bigint(20)
UNSIGNED
No
Ninguna
Average wait time of all update operations that are timed.
33
MAX_TIMER_UPDATE
bigint(20)
UNSIGNED
No
Ninguna
Maximum wait time of all update operations that are timed.
34
COUNT_DELETE
bigint(20)
UNSIGNED
No
Ninguna
Number of all delete operations.
35
SUM_TIMER_DELETE
bigint(20)
UNSIGNED
No
Ninguna
Total wait time of all delete operations that are timed.
36
MIN_TIMER_DELETE
bigint(20)
UNSIGNED
No
Ninguna
Minimum wait time of all delete operations that are timed.
37
AVG_TIMER_DELETE
bigint(20)
UNSIGNED
No
Ninguna
Average wait time of all delete operations that are timed.
38
MAX_TIMER_DELETE
bigint(20)
UNSIGNED
No
Ninguna
Maximum wait time of all delete operations that are timed.