content_image/723196.jpg content_image/723191.jpg
• PROCESS_COUNT 

The 10ms interval in which the statement that uses this thread is currently executing. 0 means no statement is executing, 1 means it is in the first 10ms, and so forth. 

• WAIT_TYPE 

The type of wait for the thread. NULL  means the thread is not blocked. Otherwise, the thread is blocked by a call to thd_wait_begin()  and the value specifies the type of wait. The xxx _WAIT  columns of the tp_thread_group_stats  table accumulate counts for each wait type. 

The WAIT_TYPE  value is a string that describes the type of wait, as shown in the following table. 

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

## 27.12.17 Performance Schema Firewall Tables 

The tp_thread_state  table has these indexes: 

•Unique index on ( TP_GROUP_ID , TP_THREAD_NUMBER ) 

TRUNCATE TABLE  is not permitted for the tp_thread_state  table. 

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

## Note 

The Performance Schema tables described here are available as of MySQL 8.0.23. Prior to MySQL 8.0.23, use the corresponding INFORMATION_SCHEMA  tables instead; see MySQL Enterprise Firewall Tables. 

The following sections describe the Performance Schema tables associated with MySQL Enterprise Firewall (see Section 6.4.7, “MySQL Enterprise Firewall” ). They provide information about firewall operation: 

• firewall_groups : Information about firewall group profiles. 

• firewall_group_allowlist : Allowlist rules of registered firewall group profiles. 

• firewall_membership : Members (accounts) of registered firewall group profiles. 

## 27.12.17.1 The firewall_groups Table 

