content_image/784852.jpg
• STALLED_THREAD_COUNT 

The number of stalled statements in the thread group. A stalled statement could be executing, but from a thread pool perspective it is stalled and making no progress. A long-running statement quickly ends up in this category. 

• WAITING_THREAD_NUMBER 

If there is a thread handling the polling of statements in the thread group, this specifies the thread number within this thread group. It is possible that this thread could be executing a statement. 

• OLDEST_QUEUED 

How long in milliseconds the oldest queued statement has been waiting for execution. 

• MAX_THREAD_IDS_IN_GROUP 

The maximum thread ID of the threads in the group. This is the same as MAX(TP_THREAD_NUMBER)  for the threads when selected from the tp_thread_state  table. That is, these two queries are equivalent: 

## 27.12.16.2 The tp_thread_group_stats Table 

SELECT TP_GROUP_ID, MAX_THREAD_IDS_IN_GROUP FROM tp_thread_group_state; SELECT TP_GROUP_ID, MAX(TP_THREAD_NUMBER) FROM tp_thread_state GROUP BY TP_GROUP_ID; 

The tp_thread_group_state  table has these indexes: 

•Unique index on ( TP_GROUP_ID ) 

TRUNCATE TABLE  is not permitted for the tp_thread_group_state  table. 

<img src='content_image/784852.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.3, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table” . 

The tp_thread_group_stats  table reports statistics per thread group. There is one row per group. 

The tp_thread_group_stats  table has these columns: 

• TP_GROUP_ID 

The thread group ID. This is a unique key within the table. 

• CONNECTIONS_STARTED 

The number of connections started. 

• CONNECTIONS_CLOSED 

The number of connections closed. 

• QUERIES_EXECUTED 

