SELECT * FROM `table_lock_waits_summary_by_table`
OBJECT_TYPE
Since this table records waits by table, always se… |
OBJECT_SCHEMA
Schema name. |
OBJECT_NAME
Table name. |
COUNT_STAR
Number of summarized events and the sum of the x_R… |
SUM_TIMER_WAIT
Total wait time of the summarized events that are … |
MIN_TIMER_WAIT
Minimum wait time of the summarized events that ar… |
AVG_TIMER_WAIT
Average wait time of the summarized events that ar… |
MAX_TIMER_WAIT
Maximum wait time of the summarized events that ar… |
COUNT_READ
Number of all read operations, and the sum of the … |
SUM_TIMER_READ
Total wait time of all read operations that are ti… |
MIN_TIMER_READ
Minimum wait time of all read operations that are … |
AVG_TIMER_READ
Average wait time of all read operations that are … |
MAX_TIMER_READ
Maximum wait time of all read operations that are … |
COUNT_WRITE
Number of all write operations, and the sum of the… |
SUM_TIMER_WRITE
Total wait time of all write operations that are t… |
MIN_TIMER_WRITE
Minimum wait time of all write operations that are… |
AVG_TIMER_WRITE
Average wait time of all write operations that are… |
MAX_TIMER_WRITE
Maximum wait time of all write operations that are… |
COUNT_READ_NORMAL
Number of all internal read normal locks. |
SUM_TIMER_READ_NORMAL
Total wait time of all internal read normal locks … |
MIN_TIMER_READ_NORMAL
Minimum wait time of all internal read normal lock… |
AVG_TIMER_READ_NORMAL
Average wait time of all internal read normal lock… |
MAX_TIMER_READ_NORMAL
Maximum wait time of all internal read normal lock… |
COUNT_READ_WITH_SHARED_LOCKS
Number of all internal read with shared locks. |
SUM_TIMER_READ_WITH_SHARED_LOCKS
Total wait time of all internal read with shared l… |
MIN_TIMER_READ_WITH_SHARED_LOCKS
Minimum wait time of all internal read with shared… |
AVG_TIMER_READ_WITH_SHARED_LOCKS
Average wait time of all internal read with shared… |
MAX_TIMER_READ_WITH_SHARED_LOCKS
Maximum wait time of all internal read with shared… |
COUNT_READ_HIGH_PRIORITY
Number of all internal read high priority locks. |
SUM_TIMER_READ_HIGH_PRIORITY
Total wait time of all internal read high priority… |
MIN_TIMER_READ_HIGH_PRIORITY
Minimum wait time of all internal read high priori… |
AVG_TIMER_READ_HIGH_PRIORITY
Average wait time of all internal read high priori… |
MAX_TIMER_READ_HIGH_PRIORITY
Maximum wait time of all internal read high priori… |
COUNT_READ_NO_INSERT
Number of all internal read no insert locks. |
SUM_TIMER_READ_NO_INSERT
Total wait time of all internal read no insert loc… |
MIN_TIMER_READ_NO_INSERT
Minimum wait time of all internal read no insert l… |
AVG_TIMER_READ_NO_INSERT
Average wait time of all internal read no insert l… |
MAX_TIMER_READ_NO_INSERT
Maximum wait time of all internal read no insert l… |
COUNT_READ_EXTERNAL
Number of all external read locks. |
SUM_TIMER_READ_EXTERNAL
Total wait time of all external read locks that ar… |
MIN_TIMER_READ_EXTERNAL
Minimum wait time of all external read locks that … |
AVG_TIMER_READ_EXTERNAL
Average wait time of all external read locks that … |
MAX_TIMER_READ_EXTERNAL
Maximum wait time of all external read locks that … |
COUNT_WRITE_ALLOW_WRITE
Number of all internal read normal locks. |
SUM_TIMER_WRITE_ALLOW_WRITE
Total wait time of all internal write allow write … |
MIN_TIMER_WRITE_ALLOW_WRITE
Minimum wait time of all internal write allow writ… |
AVG_TIMER_WRITE_ALLOW_WRITE
Average wait time of all internal write allow writ… |
MAX_TIMER_WRITE_ALLOW_WRITE
Maximum wait time of all internal write allow writ… |
COUNT_WRITE_CONCURRENT_INSERT
Number of all internal concurrent insert write loc… |
SUM_TIMER_WRITE_CONCURRENT_INSERT
Total wait time of all internal concurrent insert … |
MIN_TIMER_WRITE_CONCURRENT_INSERT
Minimum wait time of all internal concurrent inser… |
AVG_TIMER_WRITE_CONCURRENT_INSERT
Average wait time of all internal concurrent inser… |
MAX_TIMER_WRITE_CONCURRENT_INSERT
Maximum wait time of all internal concurrent inser… |
COUNT_WRITE_DELAYED
Number of all internal write delayed locks. |
SUM_TIMER_WRITE_DELAYED
Total wait time of all internal write delayed lock… |
MIN_TIMER_WRITE_DELAYED
Minimum wait time of all internal write delayed lo… |
AVG_TIMER_WRITE_DELAYED
Average wait time of all internal write delayed lo… |
MAX_TIMER_WRITE_DELAYED
Maximum wait time of all internal write delayed lo… |
COUNT_WRITE_LOW_PRIORITY
Number of all internal write low priority locks. |
SUM_TIMER_WRITE_LOW_PRIORITY
Total wait time of all internal write low priority… |
MIN_TIMER_WRITE_LOW_PRIORITY
Minimum wait time of all internal write low priori… |
AVG_TIMER_WRITE_LOW_PRIORITY
Average wait time of all internal write low priori… |
MAX_TIMER_WRITE_LOW_PRIORITY
Maximum wait time of all internal write low priori… |
COUNT_WRITE_NORMAL
Number of all internal write normal locks. |
SUM_TIMER_WRITE_NORMAL
Total wait time of all internal write normal locks… |
MIN_TIMER_WRITE_NORMAL
Minimum wait time of all internal write normal loc… |
AVG_TIMER_WRITE_NORMAL
Average wait time of all internal write normal loc… |
MAX_TIMER_WRITE_NORMAL
Maximum wait time of all internal write normal loc… |
COUNT_WRITE_EXTERNAL
Number of all external write locks. |
SUM_TIMER_WRITE_EXTERNAL
Total wait time of all external write locks that a… |
MIN_TIMER_WRITE_EXTERNAL
Minimum wait time of all external write locks that… |
AVG_TIMER_WRITE_EXTERNAL
Average wait time of all external write locks that… |
MAX_TIMER_WRITE_EXTERNAL
Maximum wait time of all external write locks that… |
---|