Performance Schema Firewall Tables • PROCESS_COUNT • WAIT_TYPE •Unique index on ( TP_GROUP_ID ,  TP_THREAD_NUMBER ) • 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. 5042 27.12.17 Performance Schema Firewall Tables Note 27.12.17.1 The firewall_groups Table TRUNCATE TABLE  is not permitted for the  tp_thread_state  table. 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: The  tp_thread_state  table has these indexes: Table 27.4 tp_thread_state Table WAIT_TYPE Values 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. 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. Wait Type Meaning THD_WAIT_SLEEP Waiting for sleep THD_WAIT_DISKIO Waiting for Disk IO THD_WAIT_ROW_LOCK Waiting for row lock THD_WAIT_GLOBAL_LOCK Waiting for global lock THD_WAIT_META_DATA_LOCK Waiting for metadata lock THD_WAIT_TABLE_LOCK Waiting for table lock THD_WAIT_USER_LOCK Waiting for user lock THD_WAIT_BINLOG Waiting for binlog THD_WAIT_GROUP_COMMIT Waiting for group commit THD_WAIT_SYNC Waiting for fsync