content_image/830554.jpg
The number of THD_WAIT_ROW_LOCK  waits for release of a row lock by another transaction. 

• GLOBAL_LOCK_WAITS 

The number of THD_WAIT_GLOBAL_LOCK  waits for a global lock to be released. 

• META_DATA_LOCK_WAITS 

The number of THD_WAIT_META_DATA_LOCK  waits for a metadata lock to be released. 

• TABLE_LOCK_WAITS 

The number of THD_WAIT_TABLE_LOCK  waits for a table to be unlocked that the statement needs to access. 

• USER_LOCK_WAITS 

The number of THD_WAIT_USER_LOCK  waits for a special lock constructed by the user thread. 

• BINLOG_WAITS 

The number of THD_WAIT_BINLOG_WAITS  waits for the binary log to become free. 

• GROUP_COMMIT_WAITS 

The number of THD_WAIT_GROUP_COMMIT  waits. These occur when a group commit must wait for the other parties to complete their part of a transaction. 

## 27.12.16.3 The tp_thread_state Table 

• FSYNC_WAITS 

The number of THD_WAIT_SYNC  waits for a file sync operation. 

The tp_thread_group_stats  table has these indexes: 

•Unique index on ( TP_GROUP_ID ) 

TRUNCATE TABLE  is not permitted for the tp_thread_group_stats  table. 

<img src='content_image/830554.jpg'>

## Note 

The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA  table instead; see Section 26.5.4, “The INFORMATION_SCHEMA TP_THREAD_STATE Table” . 

The tp_thread_state  table has one row per thread created by the thread pool to handle connections. 

The tp_thread_state  table has these columns: 

• TP_GROUP_ID 

The thread group ID. 

• TP_THREAD_NUMBER 

The ID of the thread within its thread group. TP_GROUP_ID  and TP_THREAD_NUMBER  together provide a unique key within the table. 

