content_image/833323.jpg
The firewall_membership  table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists the members (accounts) of registered firewall group profiles. It is used in conjunction with the mysql.firewall_membership  system table that provides persistent storage of firewall data; see MySQL Enterprise Firewall Tables. 

## 27.12.18 Performance Schema Keyring Tables 

The firewall_membership  table has these columns: 

• GROUP_ID 

The group profile name. 

• MEMBER_ID 

The name of an account that is a member of the profile. 

The firewall_membership  table has no indexes. 

TRUNCATE TABLE  is not permitted for the firewall_membership  table. 

The firewall_membership  table was added in MySQL 8.0.23. 

The following sections describe the Performance Schema tables associated with the MySQL keyring (see Section 6.4.4, “The MySQL Keyring” ). They provide information about keyring operation: 

• keyring_component_status : Information about the keyring component in use. 

## 27.12.18.1 The keyring_component_status Table 

• keyring_keys : Metadata for keys in the MySQL keyring. 

The keyring_component_status  table (available as of MySQL 8.0.24) provides status information about the properties of the keyring component in use, if one is installed. The table is empty if no keyring component is installed (for example, if the keyring is not being used, or is configured to manage the keystore using a keyring plugin rather than a keyring component). 

There is no fixed set of properties. Each keyring component is free to define its own set. 

Example keyring_component_status  contents: 

mysql> SELECT * FROM performance_schema.keyring_component_status; 

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

The keyring_component_status  table has these columns: 

• STATUS_KEY 

