Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

THREAD_POOL_WAITS Table

THREAD_POOL_WAITS provides statistics about reasons that worker threads in a thread group enter the waiting state during SQL statement execution. Reasons for the waiting are UNKNOWN, SLEEP, DISKIO, ROW_LOCK, GLOBAL_LOCK, META_DATA_LOCK, TABLE_LOCK, USER_LOCK, BINLOG, GROUP_COMMIT, SYNC and NET.

Table 1 THREAD_POOL_WAITS

Field

Description

REASON

Reason why a thread enters the waiting state. wait_reasons stores the reasons in the form of an array string.

COUNT

Number of times that a worker thread enters the waiting state due to a certain reason (lock or I/O) since the thread group is initialized