Performance Schema Thread Pool Tables The number of  THD_WAIT_GLOBAL_LOCK  waits for a global lock to be released. The number of  THD_WAIT_ROW_LOCK  waits for release of a row lock by another transaction. The number of  THD_WAIT_META_DATA_LOCK  waits for a metadata lock to be released. The number of  THD_WAIT_TABLE_LOCK  waits for a table to be unlocked that the statement needs to access. The number of  THD_WAIT_USER_LOCK  waits for a special lock constructed by the user thread. • GLOBAL_LOCK_WAITS • META_DATA_LOCK_WAITS • USER_LOCK_WAITS • TABLE_LOCK_WAITS • BINLOG_WAITS • GROUP_COMMIT_WAITS • FSYNC_WAITS •Unique index on ( TP_GROUP_ID ) 27.12.16.3 The tp_thread_state Table 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: The thread group ID. The ID of the thread within its thread group.  TP_GROUP_ID  and  TP_THREAD_NUMBER  together provide a unique key within the table. 5041 • TP_THREAD_NUMBER • TP_GROUP_ID The number of  THD_WAIT_SYNC  waits for a file sync operation. The  tp_thread_group_stats  table has these indexes: TRUNCATE TABLE  is not permitted for the  tp_thread_group_stats  table. 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. The number of  THD_WAIT_BINLOG_WAITS  waits for the binary log to become free.