table_lock_waits_summary_by_table

4096 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_TYPE VARCHAR 64 √ null
OBJECT_SCHEMA VARCHAR 64 √ null
OBJECT_NAME VARCHAR 64 √ null
setup_consumers.NAME Implied ConstraintR
COUNT_STAR BIGINT UNSIGNED 20 null
SUM_TIMER_WAIT BIGINT UNSIGNED 20 null
MIN_TIMER_WAIT BIGINT UNSIGNED 20 null
AVG_TIMER_WAIT BIGINT UNSIGNED 20 null
MAX_TIMER_WAIT BIGINT UNSIGNED 20 null
COUNT_READ BIGINT UNSIGNED 20 null
SUM_TIMER_READ BIGINT UNSIGNED 20 null
MIN_TIMER_READ BIGINT UNSIGNED 20 null
AVG_TIMER_READ BIGINT UNSIGNED 20 null
MAX_TIMER_READ BIGINT UNSIGNED 20 null
COUNT_WRITE BIGINT UNSIGNED 20 null
SUM_TIMER_WRITE BIGINT UNSIGNED 20 null
MIN_TIMER_WRITE BIGINT UNSIGNED 20 null
AVG_TIMER_WRITE BIGINT UNSIGNED 20 null
MAX_TIMER_WRITE BIGINT UNSIGNED 20 null
COUNT_READ_NORMAL BIGINT UNSIGNED 20 null
SUM_TIMER_READ_NORMAL BIGINT UNSIGNED 20 null
MIN_TIMER_READ_NORMAL BIGINT UNSIGNED 20 null
AVG_TIMER_READ_NORMAL BIGINT UNSIGNED 20 null
MAX_TIMER_READ_NORMAL BIGINT UNSIGNED 20 null
COUNT_READ_WITH_SHARED_LOCKS BIGINT UNSIGNED 20 null
SUM_TIMER_READ_WITH_SHARED_LOCKS BIGINT UNSIGNED 20 null
MIN_TIMER_READ_WITH_SHARED_LOCKS BIGINT UNSIGNED 20 null
AVG_TIMER_READ_WITH_SHARED_LOCKS BIGINT UNSIGNED 20 null
MAX_TIMER_READ_WITH_SHARED_LOCKS BIGINT UNSIGNED 20 null
COUNT_READ_HIGH_PRIORITY BIGINT UNSIGNED 20 null
SUM_TIMER_READ_HIGH_PRIORITY BIGINT UNSIGNED 20 null
MIN_TIMER_READ_HIGH_PRIORITY BIGINT UNSIGNED 20 null
AVG_TIMER_READ_HIGH_PRIORITY BIGINT UNSIGNED 20 null
MAX_TIMER_READ_HIGH_PRIORITY BIGINT UNSIGNED 20 null
COUNT_READ_NO_INSERT BIGINT UNSIGNED 20 null
SUM_TIMER_READ_NO_INSERT BIGINT UNSIGNED 20 null
MIN_TIMER_READ_NO_INSERT BIGINT UNSIGNED 20 null
AVG_TIMER_READ_NO_INSERT BIGINT UNSIGNED 20 null
MAX_TIMER_READ_NO_INSERT BIGINT UNSIGNED 20 null
COUNT_READ_EXTERNAL BIGINT UNSIGNED 20 null
SUM_TIMER_READ_EXTERNAL BIGINT UNSIGNED 20 null
MIN_TIMER_READ_EXTERNAL BIGINT UNSIGNED 20 null
AVG_TIMER_READ_EXTERNAL BIGINT UNSIGNED 20 null
MAX_TIMER_READ_EXTERNAL BIGINT UNSIGNED 20 null
COUNT_WRITE_ALLOW_WRITE BIGINT UNSIGNED 20 null
SUM_TIMER_WRITE_ALLOW_WRITE BIGINT UNSIGNED 20 null
MIN_TIMER_WRITE_ALLOW_WRITE BIGINT UNSIGNED 20 null
AVG_TIMER_WRITE_ALLOW_WRITE BIGINT UNSIGNED 20 null
MAX_TIMER_WRITE_ALLOW_WRITE BIGINT UNSIGNED 20 null
COUNT_WRITE_CONCURRENT_INSERT BIGINT UNSIGNED 20 null
SUM_TIMER_WRITE_CONCURRENT_INSERT BIGINT UNSIGNED 20 null
MIN_TIMER_WRITE_CONCURRENT_INSERT BIGINT UNSIGNED 20 null
AVG_TIMER_WRITE_CONCURRENT_INSERT BIGINT UNSIGNED 20 null
MAX_TIMER_WRITE_CONCURRENT_INSERT BIGINT UNSIGNED 20 null
COUNT_WRITE_LOW_PRIORITY BIGINT UNSIGNED 20 null
SUM_TIMER_WRITE_LOW_PRIORITY BIGINT UNSIGNED 20 null
MIN_TIMER_WRITE_LOW_PRIORITY BIGINT UNSIGNED 20 null
AVG_TIMER_WRITE_LOW_PRIORITY BIGINT UNSIGNED 20 null
MAX_TIMER_WRITE_LOW_PRIORITY BIGINT UNSIGNED 20 null
COUNT_WRITE_NORMAL BIGINT UNSIGNED 20 null
SUM_TIMER_WRITE_NORMAL BIGINT UNSIGNED 20 null
MIN_TIMER_WRITE_NORMAL BIGINT UNSIGNED 20 null
AVG_TIMER_WRITE_NORMAL BIGINT UNSIGNED 20 null
MAX_TIMER_WRITE_NORMAL BIGINT UNSIGNED 20 null
COUNT_WRITE_EXTERNAL BIGINT UNSIGNED 20 null
SUM_TIMER_WRITE_EXTERNAL BIGINT UNSIGNED 20 null
MIN_TIMER_WRITE_EXTERNAL BIGINT UNSIGNED 20 null
AVG_TIMER_WRITE_EXTERNAL BIGINT UNSIGNED 20 null
MAX_TIMER_WRITE_EXTERNAL BIGINT UNSIGNED 20 null

Indexes

Constraint Name Type Sort Column(s)
OBJECT Must be unique Asc/Asc/Asc OBJECT_TYPE + OBJECT_SCHEMA + OBJECT_NAME

Relationships

Close relationships within degrees of separation