<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="performance-schema-firewall-groups-table">
      </a>
      29.12.17.1 The firewall_groups Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045069587648">
  </a>
  <a class="indexterm" name="idm46045069586160">
  </a>
  <p>
   The
   <a class="link" href="performance-schema-firewall-groups-table.html" title="29.12.17.1 The firewall_groups Table">
    <code class="literal">
     firewall_groups
    </code>
   </a>
   table
          provides a view into the in-memory data cache for MySQL Enterprise Firewall. It
          lists names and operational modes of registered firewall group
          profiles. It is used in conjunction with the
   <code class="literal">
    mysql.firewall_groups
   </code>
   system table that
          provides persistent storage of firewall data; see
   <a class="xref" href="firewall-reference.html#firewall-tables" title="MySQL Enterprise Firewall Tables">
    MySQL Enterprise Firewall Tables
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="performance-schema-firewall-groups-table.html" title="29.12.17.1 The firewall_groups Table">
    <code class="literal">
     firewall_groups
    </code>
   </a>
   table has
          these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       NAME
      </code>
     </p>
     <p>
      The group profile name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       MODE
      </code>
     </p>
     <p>
      The current operational mode for the profile. Permitted
              mode values are
      <code class="literal">
       OFF
      </code>
      ,
      <code class="literal">
       DETECTING
      </code>
      ,
      <code class="literal">
       PROTECTING
      </code>
      , and
      <code class="literal">
       RECORDING
      </code>
      . For details about their
              meanings, see
      <a class="xref" href="firewall-usage.html#firewall-concepts" title="Firewall Concepts">
       Firewall Concepts
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       USERHOST
      </code>
     </p>
     <p>
      The training account for the group profile, to be used
              when the profile is in
      <code class="literal">
       RECORDING
      </code>
      mode.
              The value is
      <code class="literal">
       NULL
      </code>
      , or a
              non-
      <code class="literal">
       NULL
      </code>
      account that has the format
      <code class="literal">
       <em class="replaceable">
        <code>
         user_name
        </code>
       </em>
       @
       <em class="replaceable">
        <code>
         host_name
        </code>
       </em>
      </code>
      :
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         If the value is
         <code class="literal">
          NULL
         </code>
         , the firewall
                  records allowlist rules for statements received from
                  any account that is a member of the group.
        </p>
       </li>
       <li class="listitem">
        <p>
         If the value is non-
         <code class="literal">
          NULL
         </code>
         , the
                  firewall records allowlist rules only for statements
                  received from the named account (which should be a
                  member of the group).
        </p>
       </li>
      </ul>
     </div>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="performance-schema-firewall-groups-table.html" title="29.12.17.1 The firewall_groups Table">
    <code class="literal">
     firewall_groups
    </code>
   </a>
   table has no
          indexes.
  </p>
  <p>
   <a class="link" href="truncate-table.html" title="15.1.37 TRUNCATE TABLE Statement">
    <code class="literal">
     TRUNCATE TABLE
    </code>
   </a>
   is not permitted
          for the
   <a class="link" href="performance-schema-firewall-groups-table.html" title="29.12.17.1 The firewall_groups Table">
    <code class="literal">
     firewall_groups
    </code>
   </a>
   table.
  </p>
 </div>
 <br/>
</div>
