<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="data-masking-component-variables">
      </a>
      8.5.2.5 MySQL Enterprise Data Masking and De-Identification Component Variables
     </h4>
    </div>
   </div>
  </div>
  <p>
   The MySQL Enterprise Data Masking and De-Identification components support the following system variables.
        Use these variables to configure related component operations.
        Variables are unavailable unless the appropriate MySQL Enterprise Data Masking and De-Identification
        components are installed (see
   <a class="xref" href="data-masking-components-installation.html" title="8.5.2.1 MySQL Enterprise Data Masking and De-Identification Component Installation">
    Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”
   </a>
   ).
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="sysvar_component_masking.dictionaries_flush_interval_seconds">
      </a>
      <a class="link" href="data-masking-component-variables.html#sysvar_component_masking.dictionaries_flush_interval_seconds">
       <code class="literal">
        component_masking.dictionaries_flush_interval_seconds
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045232570656">
     </a>
     <a class="indexterm" name="idm46045232569616">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for component_masking.dictionaries_flush_interval_seconds">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --component-masking.dictionaries-flush-interval-seconds=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="data-masking-component-variables.html#sysvar_component_masking.dictionaries_flush_interval_seconds">
            component_masking.dictionaries_flush_interval_seconds
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           60
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value (Unix)
         </th>
         <td>
          <code class="literal">
           18446744073709551615
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value (Windows)
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Sets the interval, in seconds, to wait before attempting to
            schedule another flush of the data masking dictionaries
            table to the memory data masking dictionaries cache
            following a restart or previous execution. The value is
            handled as listed here:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         0: No flushing
        </p>
       </li>
       <li class="listitem">
        <p>
         1 - 59 inclusive: Round up to 60, with a warning
        </p>
       </li>
       <li class="listitem">
        <p>
         &gt;= 60: Wait this many seconds to perform flush
        </p>
       </li>
      </ul>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_component_masking.masking_database">
      </a>
      <a class="link" href="data-masking-component-variables.html#sysvar_component_masking.masking_database">
       <code class="literal">
        component_masking.masking_database
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045232532032">
     </a>
     <a class="indexterm" name="idm46045232530992">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for component_masking.masking_database">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --component-masking.masking-database[=value]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="data-masking-component-variables.html#sysvar_component_masking.masking_database">
            component_masking.masking_database
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          <a class="link" href="optimizer-hints.html#optimizer-hints-set-var" title="Variable-Setting Hint Syntax">
           <code class="literal">
            SET_VAR
           </code>
          </a>
          Hint Applies
         </th>
         <td>
          No
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           mysql
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specifies the database to use for data masking dictionaries
            at server startup. This variable is read only.
     </p>
     <p>
      Use this variable to set and persist a schema other than the
            default value (
      <code class="literal">
       mysql
      </code>
      ). For additional
            information about setting up the data-masking components to
            use an alternative location for the data-masking table, see
      <a class="xref" href="data-masking-components-installation.html#data-masking-components-installation-dedicated" title="Install Using a Dedicated Schema">
       Install Using a Dedicated Schema
      </a>
      .
            For general guidelines about using the
      <code class="literal">
       PERSIST
            ONLY
      </code>
      keyword, see
      <a class="xref" href="set-variable.html" title="15.7.6.1 SET Syntax for Variable Assignment">
       Section 15.7.6.1, “SET Syntax for Variable Assignment”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
