Javascript must be enabled past this point
SQL
Import files
SQL history
Run SQL query/queries on database
performance_schema
:
SELECT * FROM `table_lock_waits_summary_by_table` WHERE 1
Columns
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
COUNT_READ_NORMAL
SUM_TIMER_READ_NORMAL
MIN_TIMER_READ_NORMAL
AVG_TIMER_READ_NORMAL
MAX_TIMER_READ_NORMAL
COUNT_READ_WITH_SHARED_LOCKS
SUM_TIMER_READ_WITH_SHARED_LOCKS
MIN_TIMER_READ_WITH_SHARED_LOCKS
AVG_TIMER_READ_WITH_SHARED_LOCKS
MAX_TIMER_READ_WITH_SHARED_LOCKS
COUNT_READ_HIGH_PRIORITY
SUM_TIMER_READ_HIGH_PRIORITY
MIN_TIMER_READ_HIGH_PRIORITY
AVG_TIMER_READ_HIGH_PRIORITY
MAX_TIMER_READ_HIGH_PRIORITY
COUNT_READ_NO_INSERT
SUM_TIMER_READ_NO_INSERT
MIN_TIMER_READ_NO_INSERT
AVG_TIMER_READ_NO_INSERT
MAX_TIMER_READ_NO_INSERT
COUNT_READ_EXTERNAL
SUM_TIMER_READ_EXTERNAL
MIN_TIMER_READ_EXTERNAL
AVG_TIMER_READ_EXTERNAL
MAX_TIMER_READ_EXTERNAL
COUNT_WRITE_ALLOW_WRITE
SUM_TIMER_WRITE_ALLOW_WRITE
MIN_TIMER_WRITE_ALLOW_WRITE
AVG_TIMER_WRITE_ALLOW_WRITE
MAX_TIMER_WRITE_ALLOW_WRITE
COUNT_WRITE_CONCURRENT_INSERT
SUM_TIMER_WRITE_CONCURRENT_INSERT
MIN_TIMER_WRITE_CONCURRENT_INSERT
AVG_TIMER_WRITE_CONCURRENT_INSERT
MAX_TIMER_WRITE_CONCURRENT_INSERT
COUNT_WRITE_DELAYED
SUM_TIMER_WRITE_DELAYED
MIN_TIMER_WRITE_DELAYED
AVG_TIMER_WRITE_DELAYED
MAX_TIMER_WRITE_DELAYED
COUNT_WRITE_LOW_PRIORITY
SUM_TIMER_WRITE_LOW_PRIORITY
MIN_TIMER_WRITE_LOW_PRIORITY
AVG_TIMER_WRITE_LOW_PRIORITY
MAX_TIMER_WRITE_LOW_PRIORITY
COUNT_WRITE_NORMAL
SUM_TIMER_WRITE_NORMAL
MIN_TIMER_WRITE_NORMAL
AVG_TIMER_WRITE_NORMAL
MAX_TIMER_WRITE_NORMAL
COUNT_WRITE_EXTERNAL
SUM_TIMER_WRITE_EXTERNAL
MIN_TIMER_WRITE_EXTERNAL
AVG_TIMER_WRITE_EXTERNAL
MAX_TIMER_WRITE_EXTERNAL
Do not overwrite this query from outside the window
[ Delimiter
]
Show this query here again