Documentation Home
MySQL Performance Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb
HTML Download (TGZ) - 184.2Kb
HTML Download (Zip) - 202.7Kb

10.19.3 The firewall_group_allowlist Table

The firewall_group_allowlist table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists allowlist rules of registered firewall group profiles. It is used in conjunction with the mysql.firewall_group_allowlist system table that provides persistent storage of firewall data; see MySQL Enterprise Firewall Tables.

The firewall_group_allowlist table has these columns:

  • NAME

    The group profile name.

  • RULE

    A normalized statement indicating an acceptable statement pattern for the profile. A profile allowlist is the union of its rules.

The firewall_group_allowlist table has these indexes:

  • None

TRUNCATE TABLE is not permitted for the firewall_group_allowlist table.

The firewall_group_allowlist table was added in MySQL 8.0.23.