• session_status : Not supported. 

• status_by_thread : Aggregates status for all threads to the global status and account status, then resets thread status. If account statistics are not collected, the session status is added to host and user status, if host and user status are collected. 

Account, host, and user statistics are not collected if the performance_schema_accounts_size , performance_schema_hosts_size , and performance_schema_users_size  system variables, respectively, are set to 0. 

FLUSH STATUS  adds the session status from all active sessions to the global status variables, resets the status of all active sessions, and resets account, host, and user status values aggregated from disconnected sessions. 

## 27.12.16 Performance Schema Thread Pool Tables 

Note 

The Performance Schema tables described here are available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA  tables instead; see Section 26.5, “INFORMATION_SCHEMA Thread Pool Tables” . 

The following sections describe the Performance Schema tables associated with the thread pool plugin (see Section 5.6.3, “MySQL Enterprise Thread Pool” ). They provide information about thread pool operation: 

• tp_thread_group_state : Information about thread pool thread group states. 

• tp_thread_group_stats : Thread group statistics. 

• tp_thread_state : Information about thread pool thread states. 

Rows in these tables represent snapshots in time. In the case of tp_thread_state , all rows for a thread group comprise a snapshot in time. Thus, the MySQL server holds the mutex of the thread group while producing the snapshot. But it does not hold mutexes on all thread groups at the same time, to prevent a statement against tp_thread_state  from blocking the entire MySQL server. 

The Performance Schema thread pool tables are implemented by the thread pool plugin and are loaded and unloaded when that plugin is loaded and unloaded (see Section 5.6.3.2, “Thread Pool Installation” ). No special configuration step for the tables is needed. However, the tables depend on the thread pool plugin being enabled. If the thread pool plugin is loaded but disabled, the tables are not created. 

## 27.12.16.1 The tp_thread_group_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.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table” . 

The tp_thread_group_state  table has one row per thread group in the thread pool. Each row provides information about the current state of a group. 

The tp_thread_group_state  table has these columns: 

• TP_GROUP_ID 

