1
OBJECT_TYPE
varchar(64)
utf8_general_ci
Sim
NULL
Since this table records waits by table, always set to TABLE.
2
OBJECT_SCHEMA
varchar(64)
utf8_general_ci
Sim
NULL
Schema name.
3
OBJECT_NAME
varchar(64)
utf8_general_ci
Sim
NULL
Table name.
4
COUNT_STAR
bigint(20)
UNSIGNED
Não
Nenhum
Number of summarized events and the sum of the x_READ and x_WRITE columns.
5
SUM_TIMER_WAIT
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of the summarized events that are timed.
6
MIN_TIMER_WAIT
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of the summarized events that are timed.
7
AVG_TIMER_WAIT
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of the summarized events that are timed.
8
MAX_TIMER_WAIT
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of the summarized events that are timed.
9
COUNT_READ
bigint(20)
UNSIGNED
Não
Nenhum
Number of all read operations, and the sum of the equivalent x_READ_NORMAL, x_READ_WITH_SHARED_LOCKS, x_READ_HIGH_PRIORITY and x_READ_NO_INSERT columns.
10
SUM_TIMER_READ
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all read operations that are timed.
11
MIN_TIMER_READ
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all read operations that are timed.
12
AVG_TIMER_READ
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all read operations that are timed.
13
MAX_TIMER_READ
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all read operations that are timed.
14
COUNT_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Number of all write operations, and the sum of the equivalent x_WRITE_ALLOW_WRITE, x_WRITE_CONCURRENT_INSERT, x_WRITE_DELAYED, x_WRITE_LOW_PRIORITY and x_WRITE_NORMAL columns.
15
SUM_TIMER_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all write operations that are timed.
16
MIN_TIMER_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all write operations that are timed.
17
AVG_TIMER_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all write operations that are timed.
18
MAX_TIMER_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all write operations that are timed.
19
COUNT_READ_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal read normal locks.
20
SUM_TIMER_READ_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal read normal locks that are timed.
21
MIN_TIMER_READ_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal read normal locks that are timed.
22
AVG_TIMER_READ_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal read normal locks that are timed.
23
MAX_TIMER_READ_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal read normal locks that are timed.
24
COUNT_READ_WITH_SHARED_LOCKS
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal read with shared locks.
25
SUM_TIMER_READ_WITH_SHARED_LOCKS
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal read with shared locks that are timed.
26
MIN_TIMER_READ_WITH_SHARED_LOCKS
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal read with shared locks that are timed.
27
AVG_TIMER_READ_WITH_SHARED_LOCKS
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal read with shared locks that are timed.
28
MAX_TIMER_READ_WITH_SHARED_LOCKS
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal read with shared locks that are timed.
29
COUNT_READ_HIGH_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal read high priority locks.
30
SUM_TIMER_READ_HIGH_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal read high priority locks that are timed.
31
MIN_TIMER_READ_HIGH_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal read high priority locks that are timed.
32
AVG_TIMER_READ_HIGH_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal read high priority locks that are timed.
33
MAX_TIMER_READ_HIGH_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal read high priority locks that are timed.
34
COUNT_READ_NO_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal read no insert locks.
35
SUM_TIMER_READ_NO_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal read no insert locks that are timed.
36
MIN_TIMER_READ_NO_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal read no insert locks that are timed.
37
AVG_TIMER_READ_NO_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal read no insert locks that are timed.
38
MAX_TIMER_READ_NO_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal read no insert locks that are timed.
39
COUNT_READ_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Number of all external read locks.
40
SUM_TIMER_READ_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all external read locks that are timed.
41
MIN_TIMER_READ_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all external read locks that are timed.
42
AVG_TIMER_READ_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all external read locks that are timed.
43
MAX_TIMER_READ_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all external read locks that are timed.
44
COUNT_WRITE_ALLOW_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal read normal locks.
45
SUM_TIMER_WRITE_ALLOW_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal write allow write locks that are timed.
46
MIN_TIMER_WRITE_ALLOW_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal write allow write locks that are timed.
47
AVG_TIMER_WRITE_ALLOW_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal write allow write locks that are timed.
48
MAX_TIMER_WRITE_ALLOW_WRITE
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal write allow write locks that are timed.
49
COUNT_WRITE_CONCURRENT_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal concurrent insert write locks.
50
SUM_TIMER_WRITE_CONCURRENT_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal concurrent insert write locks that are timed.
51
MIN_TIMER_WRITE_CONCURRENT_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal concurrent insert write locks that are timed.
52
AVG_TIMER_WRITE_CONCURRENT_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal concurrent insert write locks that are timed.
53
MAX_TIMER_WRITE_CONCURRENT_INSERT
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal concurrent insert write locks that are timed.
54
COUNT_WRITE_DELAYED
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal write delayed locks.
55
SUM_TIMER_WRITE_DELAYED
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal write delayed locks that are timed.
56
MIN_TIMER_WRITE_DELAYED
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal write delayed locks that are timed.
57
AVG_TIMER_WRITE_DELAYED
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal write delayed locks that are timed.
58
MAX_TIMER_WRITE_DELAYED
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal write delayed locks that are timed.
59
COUNT_WRITE_LOW_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal write low priority locks.
60
SUM_TIMER_WRITE_LOW_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal write low priority locks that are timed.
61
MIN_TIMER_WRITE_LOW_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal write low priority locks that are timed.
62
AVG_TIMER_WRITE_LOW_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal write low priority locks that are timed.
63
MAX_TIMER_WRITE_LOW_PRIORITY
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal write low priority locks that are timed.
64
COUNT_WRITE_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Number of all internal write normal locks.
65
SUM_TIMER_WRITE_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all internal write normal locks that are timed.
66
MIN_TIMER_WRITE_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all internal write normal locks that are timed.
67
AVG_TIMER_WRITE_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all internal write normal locks that are timed.
68
MAX_TIMER_WRITE_NORMAL
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all internal write normal locks that are timed.
69
COUNT_WRITE_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Number of all external write locks.
70
SUM_TIMER_WRITE_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Total wait time of all external write locks that are timed.
71
MIN_TIMER_WRITE_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Minimum wait time of all external write locks that are timed.
72
AVG_TIMER_WRITE_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Average wait time of all external write locks that are timed.
73
MAX_TIMER_WRITE_EXTERNAL
bigint(20)
UNSIGNED
Não
Nenhum
Maximum wait time of all external write locks that are timed.