<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="performance-schema-system-variables">
      </a>
      29.15 Performance Schema System Variables
     </h2>
    </div>
   </div>
  </div>
  <p>
   The Performance Schema implements several system variables that
      provide configuration information:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa37783118"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">VARIABLES</span> <span class="token operator">LIKE</span> <span class="token string">'perf%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Variable_name                                            <span class="token punctuation">|</span> Value <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema                                       <span class="token punctuation">|</span> ON    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_accounts_size                         <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_digests_size                          <span class="token punctuation">|</span> 10000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_error_size                            <span class="token punctuation">|</span> 5377  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_events_stages_history_long_size       <span class="token punctuation">|</span> 10000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_events_stages_history_size            <span class="token punctuation">|</span> 10    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_events_statements_history_long_size   <span class="token punctuation">|</span> 10000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_events_statements_history_size        <span class="token punctuation">|</span> 10    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_events_transactions_history_long_size <span class="token punctuation">|</span> 10000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_events_transactions_history_size      <span class="token punctuation">|</span> 10    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_events_waits_history_long_size        <span class="token punctuation">|</span> 10000 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_events_waits_history_size             <span class="token punctuation">|</span> 10    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_hosts_size                            <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_cond_classes                      <span class="token punctuation">|</span> 150   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_cond_instances                    <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_digest_length                     <span class="token punctuation">|</span> 1024  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_digest_sample_age                 <span class="token punctuation">|</span> 60    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_file_classes                      <span class="token punctuation">|</span> 80    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_file_handles                      <span class="token punctuation">|</span> 32768 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_file_instances                    <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_index_stat                        <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_memory_classes                    <span class="token punctuation">|</span> 470   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_metadata_locks                    <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_meter_classes                     <span class="token punctuation">|</span> 30    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_metric_classes                    <span class="token punctuation">|</span> 600   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_mutex_classes                     <span class="token punctuation">|</span> 350   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_mutex_instances                   <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_prepared_statements_instances     <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_program_instances                 <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_rwlock_classes                    <span class="token punctuation">|</span> 100   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_rwlock_instances                  <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_socket_classes                    <span class="token punctuation">|</span> 10    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_socket_instances                  <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_sql_text_length                   <span class="token punctuation">|</span> 1024  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_stage_classes                     <span class="token punctuation">|</span> 175   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_statement_classes                 <span class="token punctuation">|</span> 220   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_statement_stack                   <span class="token punctuation">|</span> 10    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_table_handles                     <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_table_instances                   <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_table_lock_stat                   <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_thread_classes                    <span class="token punctuation">|</span> 100   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_max_thread_instances                  <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_session_connect_attrs_size            <span class="token punctuation">|</span> 512   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_setup_actors_size                     <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_setup_objects_size                    <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_show_processlist                      <span class="token punctuation">|</span> OFF   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> performance_schema_users_size                            <span class="token punctuation">|</span> <span class="token punctuation">-</span>1    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   Performance Schema system variables can be set at server startup
      on the command line or in option files, and many can be set at
      runtime. See
   <a class="xref" href="performance-schema-option-variable-reference.html" title="29.13 Performance Schema Option and Variable Reference">
    Section 29.13, “Performance Schema Option and Variable Reference”
   </a>
   .
  </p>
  <p>
   The Performance Schema automatically sizes the values of several
      of its parameters at server startup if they are not set
      explicitly. For more information, see
   <a class="xref" href="performance-schema-startup-configuration.html" title="29.3 Performance Schema Startup Configuration">
    Section 29.3, “Performance Schema Startup Configuration”
   </a>
   .
  </p>
  <p>
   Performance Schema system variables have the following meanings:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema">
       <code class="literal">
        performance_schema
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066140320">
     </a>
     <a class="indexterm" name="idm46045066139280">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema[={OFF|ON}]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema">
            performance_schema
           </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>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           ON
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The value of this variable is
      <code class="literal">
       ON
      </code>
      or
      <code class="literal">
       OFF
      </code>
      to indicate whether the Performance
          Schema is enabled. By default, the value is
      <code class="literal">
       ON
      </code>
      . At server startup, you can specify this
          variable with no value or a value of
      <code class="literal">
       ON
      </code>
      or
          1 to enable it, or with a value of
      <code class="literal">
       OFF
      </code>
      or 0
          to disable it.
     </p>
     <p>
      Even when the Performance Schema is disabled, it continues to
          populate the
      <a class="link" href="performance-schema-system-variable-tables.html" title="29.12.14 Performance Schema System Variable Tables">
       <code class="literal">
        global_variables
       </code>
      </a>
      ,
      <a class="link" href="performance-schema-system-variable-tables.html" title="29.12.14 Performance Schema System Variable Tables">
       <code class="literal">
        session_variables
       </code>
      </a>
      ,
      <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
       <code class="literal">
        global_status
       </code>
      </a>
      , and
      <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
       <code class="literal">
        session_status
       </code>
      </a>
      tables. This
          occurs as necessary to permit the results for the
      <a class="link" href="show-variables.html" title="15.7.7.41 SHOW VARIABLES Statement">
       <code class="literal">
        SHOW VARIABLES
       </code>
      </a>
      and
      <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
       <code class="literal">
        SHOW STATUS
       </code>
      </a>
      statements to be
          drawn from those tables. The Performance Schema also populates
          some of the replication tables when disabled.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_accounts_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_accounts_size">
       <code class="literal">
        performance_schema_accounts_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066102720">
     </a>
     <a class="indexterm" name="idm46045066101616">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_accounts_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-accounts-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_accounts_size">
            performance_schema_accounts_size
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-accounts-table.html" title="29.12.8.1 The accounts Table">
       <code class="literal">
        accounts
       </code>
      </a>
      table. If this variable
          is 0, the Performance Schema does not maintain connection
          statistics in the
      <a class="link" href="performance-schema-accounts-table.html" title="29.12.8.1 The accounts Table">
       <code class="literal">
        accounts
       </code>
      </a>
      table
          or status variable information in the
      <a class="link" href="performance-schema-status-variable-summary-tables.html" title="29.12.20.12 Status Variable Summary Tables">
       <code class="literal">
        status_by_account
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_digests_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_digests_size">
       <code class="literal">
        performance_schema_digests_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066067744">
     </a>
     <a class="indexterm" name="idm46045066066640">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_digests_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-digests-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_digests_size">
            performance_schema_digests_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of rows in the
      <a class="link" href="performance-schema-statement-summary-tables.html" title="29.12.20.3 Statement Summary Tables">
       <code class="literal">
        events_statements_summary_by_digest
       </code>
      </a>
      table. If this maximum is exceeded such that a digest cannot
          be instrumented, the Performance Schema increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_digest_lost">
       <code class="literal">
        Performance_schema_digest_lost
       </code>
      </a>
      status variable.
     </p>
     <p>
      For more information about statement digesting, see
      <a class="xref" href="performance-schema-statement-digests.html" title="29.10 Performance Schema Statement Digests and Sampling">
       Section 29.10, “Performance Schema Statement Digests and Sampling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_error_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_error_size">
       <code class="literal">
        performance_schema_error_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045066032832">
     </a>
     <a class="indexterm" name="idm46045066031728">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_error_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-error-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_error_size">
            performance_schema_error_size
           </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">
           number of server error codes
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of instrumented server error codes. The default
          value is the actual number of server error codes. Although the
          value can be set anywhere from 0 to its maximum, the intended
          use is to set it to either its default (to instrument all
          errors) or 0 (to instrument no errors).
     </p>
     <p>
      Error information is aggregated in summary tables; see
      <a class="xref" href="performance-schema-error-summary-tables.html" title="29.12.20.11 Error Summary Tables">
       Section 29.12.20.11, “Error Summary Tables”
      </a>
      . If
          an error occurs that is not instrumented, information for the
          occurrence is aggregated to the
      <code class="literal">
       NULL
      </code>
      row in
          each summary table; that is, to the row with
      <code class="literal">
       ERROR_NUMBER=0
      </code>
      ,
      <code class="literal">
       ERROR_NAME=NULL
      </code>
      , and
      <code class="literal">
       SQLSTATE=NULL
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_events_stages_history_long_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_stages_history_long_size">
       <code class="literal">
        performance_schema_events_stages_history_long_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065997536">
     </a>
     <a class="indexterm" name="idm46045065996496">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_events_stages_history_long_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-events-stages-history-long-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_stages_history_long_size">
            performance_schema_events_stages_history_long_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-events-stages-history-long-table.html" title="29.12.5.3 The events_stages_history_long Table">
       <code class="literal">
        events_stages_history_long
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_events_stages_history_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_stages_history_size">
       <code class="literal">
        performance_schema_events_stages_history_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065965088">
     </a>
     <a class="indexterm" name="idm46045065963968">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_events_stages_history_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-events-stages-history-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_stages_history_size">
            performance_schema_events_stages_history_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows per thread in the
      <a class="link" href="performance-schema-events-stages-history-table.html" title="29.12.5.2 The events_stages_history Table">
       <code class="literal">
        events_stages_history
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_events_statements_history_long_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_statements_history_long_size">
       <code class="literal">
        performance_schema_events_statements_history_long_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065932448">
     </a>
     <a class="indexterm" name="idm46045065931408">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_events_statements_history_long_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-events-statements-history-long-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_statements_history_long_size">
            performance_schema_events_statements_history_long_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-events-statements-history-long-table.html" title="29.12.6.3 The events_statements_history_long Table">
       <code class="literal">
        events_statements_history_long
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_events_statements_history_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_statements_history_size">
       <code class="literal">
        performance_schema_events_statements_history_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065899888">
     </a>
     <a class="indexterm" name="idm46045065898848">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_events_statements_history_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-events-statements-history-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_statements_history_size">
            performance_schema_events_statements_history_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows per thread in the
      <a class="link" href="performance-schema-events-statements-history-table.html" title="29.12.6.2 The events_statements_history Table">
       <code class="literal">
        events_statements_history
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_events_transactions_history_long_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_transactions_history_long_size">
       <code class="literal">
        performance_schema_events_transactions_history_long_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065867408">
     </a>
     <a class="indexterm" name="idm46045065866272">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_events_transactions_history_long_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-events-transactions-history-long-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_transactions_history_long_size">
            performance_schema_events_transactions_history_long_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-events-transactions-history-long-table.html" title="29.12.7.3 The events_transactions_history_long Table">
       <code class="literal">
        events_transactions_history_long
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_events_transactions_history_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_transactions_history_size">
       <code class="literal">
        performance_schema_events_transactions_history_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065834624">
     </a>
     <a class="indexterm" name="idm46045065833584">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_events_transactions_history_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-events-transactions-history-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_transactions_history_size">
            performance_schema_events_transactions_history_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows per thread in the
      <a class="link" href="performance-schema-events-transactions-history-table.html" title="29.12.7.2 The events_transactions_history Table">
       <code class="literal">
        events_transactions_history
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_events_waits_history_long_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_waits_history_long_size">
       <code class="literal">
        performance_schema_events_waits_history_long_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065802064">
     </a>
     <a class="indexterm" name="idm46045065801024">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_events_waits_history_long_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-events-waits-history-long-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_waits_history_long_size">
            performance_schema_events_waits_history_long_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-events-waits-history-long-table.html" title="29.12.4.3 The events_waits_history_long Table">
       <code class="literal">
        events_waits_history_long
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_events_waits_history_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_waits_history_size">
       <code class="literal">
        performance_schema_events_waits_history_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065769616">
     </a>
     <a class="indexterm" name="idm46045065768496">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_events_waits_history_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-events-waits-history-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_events_waits_history_size">
            performance_schema_events_waits_history_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows per thread in the
      <a class="link" href="performance-schema-events-waits-history-table.html" title="29.12.4.2 The events_waits_history Table">
       <code class="literal">
        events_waits_history
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_hosts_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_hosts_size">
       <code class="literal">
        performance_schema_hosts_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065737264">
     </a>
     <a class="indexterm" name="idm46045065736160">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_hosts_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-hosts-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_hosts_size">
            performance_schema_hosts_size
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-hosts-table.html" title="29.12.8.2 The hosts Table">
       <code class="literal">
        hosts
       </code>
      </a>
      table. If this variable is 0, the Performance Schema does not
          maintain connection statistics in the
      <a class="link" href="performance-schema-hosts-table.html" title="29.12.8.2 The hosts Table">
       <code class="literal">
        hosts
       </code>
      </a>
      table or status variable
          information in the
      <a class="link" href="performance-schema-status-variable-summary-tables.html" title="29.12.20.12 Status Variable Summary Tables">
       <code class="literal">
        status_by_host
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_cond_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_cond_classes">
       <code class="literal">
        performance_schema_max_cond_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065702176">
     </a>
     <a class="indexterm" name="idm46045065701136">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_cond_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-cond-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_cond_classes">
            performance_schema_max_cond_classes
           </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">
           150
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of condition instruments. For information
          about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_cond_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_cond_instances">
       <code class="literal">
        performance_schema_max_cond_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065670592">
     </a>
     <a class="indexterm" name="idm46045065669552">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_cond_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-cond-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_cond_instances">
            performance_schema_max_cond_instances
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of instrumented condition objects. For
          information about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_digest_length">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_digest_length">
       <code class="literal">
        performance_schema_max_digest_length
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065638752">
     </a>
     <a class="indexterm" name="idm46045065637712">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_digest_length">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-digest-length=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_digest_length">
            performance_schema_max_digest_length
           </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">
           1024
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of bytes of memory reserved per statement
          for computation of normalized statement digest values in the
          Performance Schema. This variable is related to
      <a class="link" href="server-system-variables.html#sysvar_max_digest_length">
       <code class="literal">
        max_digest_length
       </code>
      </a>
      ; see the
          description of that variable in
      <a class="xref" href="server-system-variables.html" title="7.1.8 Server System Variables">
       Section 7.1.8, “Server System Variables”
      </a>
      .
     </p>
     <p>
      For more information about statement digesting, including
          considerations regarding memory use, see
      <a class="xref" href="performance-schema-statement-digests.html" title="29.10 Performance Schema Statement Digests and Sampling">
       Section 29.10, “Performance Schema Statement Digests and Sampling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_digest_sample_age">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_digest_sample_age">
       <code class="literal">
        performance_schema_max_digest_sample_age
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065602720">
     </a>
     <a class="indexterm" name="idm46045065601600">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_digest_sample_age">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-digest-sample-age=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_digest_sample_age">
            performance_schema_max_digest_sample_age
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </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">
           60
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          seconds
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      This variable affects statement sampling for the
      <a class="link" href="performance-schema-statement-summary-tables.html" title="29.12.20.3 Statement Summary Tables">
       <code class="literal">
        events_statements_summary_by_digest
       </code>
      </a>
      table. When a new table row is inserted, the statement that
          produced the row digest value is stored as the current sample
          statement associated with the digest. Thereafter, when the
          server sees other statements with the same digest value, it
          determines whether to use the new statement to replace the
          current sample statement (that is, whether to resample).
          Resampling policy is based on the comparative wait times of
          the current sample statement and new statement and,
          optionally, the age of the current sample statement:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         Resampling based on wait times: If the new statement wait
              time has a wait time greater than that of the current
              sample statement, it becomes the current sample statement.
        </p>
       </li>
       <li class="listitem">
        <p>
         Resampling based on age: If the
         <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_digest_sample_age">
          <code class="literal">
           performance_schema_max_digest_sample_age
          </code>
         </a>
         system variable has a value greater than zero and the
              current sample statement is more than that many seconds
              old, the current statement is considered
         <span class="quote">
          “
          <span class="quote">
           too
              old
          </span>
          ”
         </span>
         and the new statement replaces it. This occurs
              even if the new statement wait time is less than that of
              the current sample statement.
        </p>
       </li>
      </ul>
     </div>
     <p>
      For information about statement sampling, see
      <a class="xref" href="performance-schema-statement-digests.html" title="29.10 Performance Schema Statement Digests and Sampling">
       Section 29.10, “Performance Schema Statement Digests and Sampling”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_file_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_file_classes">
       <code class="literal">
        performance_schema_max_file_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065562480">
     </a>
     <a class="indexterm" name="idm46045065561440">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_file_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-file-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_file_classes">
            performance_schema_max_file_classes
           </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">
           80
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of file instruments. For information about
          how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_file_handles">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_file_handles">
       <code class="literal">
        performance_schema_max_file_handles
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065531088">
     </a>
     <a class="indexterm" name="idm46045065530048">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_file_handles">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-file-handles=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_file_handles">
            performance_schema_max_file_handles
           </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">
           32768
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of opened file objects. For information
          about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
     <p>
      The value of
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_file_handles">
       <code class="literal">
        performance_schema_max_file_handles
       </code>
      </a>
      should be greater than the value of
      <a class="link" href="server-system-variables.html#sysvar_open_files_limit">
       <code class="literal">
        open_files_limit
       </code>
      </a>
      :
      <a class="link" href="server-system-variables.html#sysvar_open_files_limit">
       <code class="literal">
        open_files_limit
       </code>
      </a>
      affects the
          maximum number of open file handles the server can support and
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_file_handles">
       <code class="literal">
        performance_schema_max_file_handles
       </code>
      </a>
      affects how many of these file handles can be instrumented.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_file_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_file_instances">
       <code class="literal">
        performance_schema_max_file_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065493952">
     </a>
     <a class="indexterm" name="idm46045065492912">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_file_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-file-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_file_instances">
            performance_schema_max_file_instances
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of instrumented file objects. For
          information about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_index_stat">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_index_stat">
       <code class="literal">
        performance_schema_max_index_stat
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065462112">
     </a>
     <a class="indexterm" name="idm46045065461072">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_index_stat">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-index-stat=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_index_stat">
            performance_schema_max_index_stat
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of indexes for which the Performance Schema
          maintains statistics. If this maximum is exceeded such that
          index statistics are lost, the Performance Schema increments
          the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_index_stat_lost">
       <code class="literal">
        Performance_schema_index_stat_lost
       </code>
      </a>
      status variable. The default value is autosized using the
          value of
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_table_instances">
       <code class="literal">
        performance_schema_max_table_instances
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_memory_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_memory_classes">
       <code class="literal">
        performance_schema_max_memory_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065428192">
     </a>
     <a class="indexterm" name="idm46045065427152">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_memory_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-memory-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_memory_classes">
            performance_schema_max_memory_classes
           </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">
           470
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           450
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of memory instruments. For information
          about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_metadata_locks">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_metadata_locks">
       <code class="literal">
        performance_schema_max_metadata_locks
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065394272">
     </a>
     <a class="indexterm" name="idm46045065393232">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_metadata_locks">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-metadata-locks=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_metadata_locks">
            performance_schema_max_metadata_locks
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           10485760
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of metadata lock instruments. This value
          controls the size of the
      <a class="link" href="performance-schema-metadata-locks-table.html" title="29.12.13.3 The metadata_locks Table">
       <code class="literal">
        metadata_locks
       </code>
      </a>
      table. If this
          maximum is exceeded such that a metadata lock cannot be
          instrumented, the Performance Schema increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_metadata_lock_lost">
       <code class="literal">
        Performance_schema_metadata_lock_lost
       </code>
      </a>
      status variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_meter_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_meter_classes">
       <code class="literal">
        performance_schema_max_meter_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065360368">
     </a>
     <a class="indexterm" name="idm46045065359280">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_meter_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-meter-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_meter_classes">
            performance_schema_max_meter_classes
           </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">
           30
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           64
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Maximum number of meter instruments which can be created
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_metric_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_metric_classes">
       <code class="literal">
        performance_schema_max_metric_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065329760">
     </a>
     <a class="indexterm" name="idm46045065328672">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_metric_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-metric-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_metric_classes">
            performance_schema_max_metric_classes
           </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">
           600
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           30
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           11000
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Maximum number of metric instruments which can be created.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_mutex_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_mutex_classes">
       <code class="literal">
        performance_schema_max_mutex_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065299120">
     </a>
     <a class="indexterm" name="idm46045065298080">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_mutex_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-mutex-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_mutex_classes">
            performance_schema_max_mutex_classes
           </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">
           350
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of mutex instruments. For information about
          how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_mutex_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_mutex_instances">
       <code class="literal">
        performance_schema_max_mutex_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065267664">
     </a>
     <a class="indexterm" name="idm46045065266624">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_mutex_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-mutex-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_mutex_instances">
            performance_schema_max_mutex_instances
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           104857600
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of instrumented mutex objects. For
          information about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_prepared_statements_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_prepared_statements_instances">
       <code class="literal">
        performance_schema_max_prepared_statements_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065235664">
     </a>
     <a class="indexterm" name="idm46045065234624">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_prepared_statements_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-prepared-statements-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_prepared_statements_instances">
            performance_schema_max_prepared_statements_instances
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4194304
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of rows in the
      <a class="link" href="performance-schema-prepared-statements-instances-table.html" title="29.12.6.4 The prepared_statements_instances Table">
       <code class="literal">
        prepared_statements_instances
       </code>
      </a>
      table. If this maximum is exceeded such that a prepared
          statement cannot be instrumented, the Performance Schema
          increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_prepared_statements_lost">
       <code class="literal">
        Performance_schema_prepared_statements_lost
       </code>
      </a>
      status variable. For information about how to set and use this
          variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
     <p>
      The default value of this variable is autosized based on the
          value of the
      <a class="link" href="server-system-variables.html#sysvar_max_prepared_stmt_count">
       <code class="literal">
        max_prepared_stmt_count
       </code>
      </a>
      system variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_rwlock_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_rwlock_classes">
       <code class="literal">
        performance_schema_max_rwlock_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065199072">
     </a>
     <a class="indexterm" name="idm46045065198032">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_rwlock_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-rwlock-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_rwlock_classes">
            performance_schema_max_rwlock_classes
           </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">
           100
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of rwlock instruments. For information
          about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_program_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_program_instances">
       <code class="literal">
        performance_schema_max_program_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065167648">
     </a>
     <a class="indexterm" name="idm46045065166528">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_program_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-program-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_program_instances">
            performance_schema_max_program_instances
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of stored programs for which the
          Performance Schema maintains statistics. If this maximum is
          exceeded, the Performance Schema increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_program_lost">
       <code class="literal">
        Performance_schema_program_lost
       </code>
      </a>
      status variable. For information about how to set and use this
          variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_rwlock_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_rwlock_instances">
       <code class="literal">
        performance_schema_max_rwlock_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065134256">
     </a>
     <a class="indexterm" name="idm46045065133216">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_rwlock_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-rwlock-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_rwlock_instances">
            performance_schema_max_rwlock_instances
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           104857600
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of instrumented rwlock objects. For
          information about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_socket_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_socket_classes">
       <code class="literal">
        performance_schema_max_socket_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065102352">
     </a>
     <a class="indexterm" name="idm46045065101312">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_socket_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-socket-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_socket_classes">
            performance_schema_max_socket_classes
           </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">
           10
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of socket instruments. For information
          about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_socket_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_socket_instances">
       <code class="literal">
        performance_schema_max_socket_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065070944">
     </a>
     <a class="indexterm" name="idm46045065069904">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_socket_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-socket-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_socket_instances">
            performance_schema_max_socket_instances
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of instrumented socket objects. For
          information about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_sql_text_length">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_sql_text_length">
       <code class="literal">
        performance_schema_max_sql_text_length
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045065039104">
     </a>
     <a class="indexterm" name="idm46045065038064">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_sql_text_length">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-sql-text-length=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_sql_text_length">
            performance_schema_max_sql_text_length
           </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">
           1024
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of bytes used to store SQL statements. The
          value applies to storage required for these columns:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         The
         <code class="literal">
          SQL_TEXT
         </code>
         column of the
         <a class="link" href="performance-schema-events-statements-current-table.html" title="29.12.6.1 The events_statements_current Table">
          <code class="literal">
           events_statements_current
          </code>
         </a>
         ,
         <a class="link" href="performance-schema-events-statements-history-table.html" title="29.12.6.2 The events_statements_history Table">
          <code class="literal">
           events_statements_history
          </code>
         </a>
         ,
              and
         <a class="link" href="performance-schema-events-statements-history-long-table.html" title="29.12.6.3 The events_statements_history_long Table">
          <code class="literal">
           events_statements_history_long
          </code>
         </a>
         statement event tables.
        </p>
       </li>
       <li class="listitem">
        <p>
         The
         <code class="literal">
          QUERY_SAMPLE_TEXT
         </code>
         column of the
         <a class="link" href="performance-schema-statement-summary-tables.html" title="29.12.20.3 Statement Summary Tables">
          <code class="literal">
           events_statements_summary_by_digest
          </code>
         </a>
         summary table.
        </p>
       </li>
      </ul>
     </div>
     <p>
      Any bytes in excess of
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_sql_text_length">
       <code class="literal">
        performance_schema_max_sql_text_length
       </code>
      </a>
      are discarded and do not appear in the column. Statements
          differing only after that many initial bytes are
          indistinguishable in the column.
     </p>
     <p>
      Decreasing the
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_sql_text_length">
       <code class="literal">
        performance_schema_max_sql_text_length
       </code>
      </a>
      value reduces memory use but causes more statements to become
          indistinguishable if they differ only at the end. Increasing
          the value increases memory use but permits longer statements
          to be distinguished.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_stage_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_stage_classes">
       <code class="literal">
        performance_schema_max_stage_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064992688">
     </a>
     <a class="indexterm" name="idm46045064991648">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_stage_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-stage-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_stage_classes">
            performance_schema_max_stage_classes
           </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">
           175
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of stage instruments. For information about
          how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_statement_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_statement_classes">
       <code class="literal">
        performance_schema_max_statement_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064961280">
     </a>
     <a class="indexterm" name="idm46045064960160">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_statement_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-statement-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_statement_classes">
            performance_schema_max_statement_classes
           </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>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           256
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of statement instruments. For information
          about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
     <p>
      The default value is calculated at server build time based on
          the number of commands in the client/server protocol and the
          number of SQL statement types supported by the server.
     </p>
     <p>
      This variable should not be changed, unless to set it to 0 to
          disable all statement instrumentation and save all memory
          associated with it. Setting the variable to nonzero values
          other than the default has no benefit; in particular, values
          larger than the default cause more memory to be allocated then
          is needed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_statement_stack">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_statement_stack">
       <code class="literal">
        performance_schema_max_statement_stack
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064930720">
     </a>
     <a class="indexterm" name="idm46045064929680">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_statement_stack">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-statement-stack=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_statement_stack">
            performance_schema_max_statement_stack
           </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">
           10
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           256
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum depth of nested stored program calls for which the
          Performance Schema maintains statistics. When this maximum is
          exceeded, the Performance Schema increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_nested_statement_lost">
       <code class="literal">
        Performance_schema_nested_statement_lost
       </code>
      </a>
      status variable for each stored program statement executed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_table_handles">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_table_handles">
       <code class="literal">
        performance_schema_max_table_handles
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064898576">
     </a>
     <a class="indexterm" name="idm46045064897536">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_table_handles">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-table-handles=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_table_handles">
            performance_schema_max_table_handles
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of opened table objects. This value
          controls the size of the
      <a class="link" href="performance-schema-table-handles-table.html" title="29.12.13.4 The table_handles Table">
       <code class="literal">
        table_handles
       </code>
      </a>
      table. If this
          maximum is exceeded such that a table handle cannot be
          instrumented, the Performance Schema increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_table_handles_lost">
       <code class="literal">
        Performance_schema_table_handles_lost
       </code>
      </a>
      status variable. For information about how to set and use this
          variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_table_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_table_instances">
       <code class="literal">
        performance_schema_max_table_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064863888">
     </a>
     <a class="indexterm" name="idm46045064862848">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_table_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-table-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_table_instances">
            performance_schema_max_table_instances
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of instrumented table objects. For
          information about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_table_lock_stat">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_table_lock_stat">
       <code class="literal">
        performance_schema_max_table_lock_stat
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064832048">
     </a>
     <a class="indexterm" name="idm46045064831008">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_table_lock_stat">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-table-lock-stat=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_table_lock_stat">
            performance_schema_max_table_lock_stat
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of tables for which the Performance Schema
          maintains lock statistics. If this maximum is exceeded such
          that table lock statistics are lost, the Performance Schema
          increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_table_lock_stat_lost">
       <code class="literal">
        Performance_schema_table_lock_stat_lost
       </code>
      </a>
      status variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_thread_classes">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_thread_classes">
       <code class="literal">
        performance_schema_max_thread_classes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064799408">
     </a>
     <a class="indexterm" name="idm46045064798368">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_thread_classes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-thread-classes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_thread_classes">
            performance_schema_max_thread_classes
           </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">
           100
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of thread instruments. For information
          about how to set and use this variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_max_thread_instances">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_thread_instances">
       <code class="literal">
        performance_schema_max_thread_instances
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064767936">
     </a>
     <a class="indexterm" name="idm46045064766896">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_max_thread_instances">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-max-thread-instances=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_thread_instances">
            performance_schema_max_thread_instances
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The maximum number of instrumented thread objects. The value
          controls the size of the
      <a class="link" href="performance-schema-threads-table.html" title="29.12.22.8 The threads Table">
       <code class="literal">
        threads
       </code>
      </a>
      table. If this maximum is exceeded such that a thread cannot
          be instrumented, the Performance Schema increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_thread_instances_lost">
       <code class="literal">
        Performance_schema_thread_instances_lost
       </code>
      </a>
      status variable. For information about how to set and use this
          variable, see
      <a class="xref" href="performance-schema-status-monitoring.html" title="29.7 Performance Schema Status Monitoring">
       Section 29.7, “Performance Schema Status Monitoring”
      </a>
      .
     </p>
     <p>
      The
      <a class="link" href="server-system-variables.html#sysvar_max_connections">
       <code class="literal">
        max_connections
       </code>
      </a>
      system
          variable affects how many threads can run in the server.
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_max_thread_instances">
       <code class="literal">
        performance_schema_max_thread_instances
       </code>
      </a>
      affects how many of these running threads can be instrumented.
     </p>
     <p>
      The
      <a class="link" href="performance-schema-system-variable-tables.html" title="29.12.14 Performance Schema System Variable Tables">
       <code class="literal">
        variables_by_thread
       </code>
      </a>
      and
      <a class="link" href="performance-schema-status-variable-tables.html" title="29.12.15 Performance Schema Status Variable Tables">
       <code class="literal">
        status_by_thread
       </code>
      </a>
      tables contain
          system and status variable information only about foreground
          threads. If not all threads are instrumented by the
          Performance Schema, this table misses some rows. In this case,
          the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_thread_instances_lost">
       <code class="literal">
        Performance_schema_thread_instances_lost
       </code>
      </a>
      status variable is greater than zero.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_session_connect_attrs_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_session_connect_attrs_size">
       <code class="literal">
        performance_schema_session_connect_attrs_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064725600">
     </a>
     <a class="indexterm" name="idm46045064724480">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_session_connect_attrs_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-session-connect-attrs-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_session_connect_attrs_size">
            performance_schema_session_connect_attrs_size
           </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">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The amount of preallocated memory per thread reserved to hold
          connection attribute key-value pairs. If the aggregate size of
          connection attribute data sent by a client is larger than this
          amount, the Performance Schema truncates the attribute data,
          increments the
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_session_connect_attrs_lost">
       <code class="literal">
        Performance_schema_session_connect_attrs_lost
       </code>
      </a>
      status variable, and writes a message to the error log
          indicating that truncation occurred if the
      <a class="link" href="server-system-variables.html#sysvar_log_error_verbosity">
       <code class="literal">
        log_error_verbosity
       </code>
      </a>
      system
          variable is greater than 1. A
      <code class="literal">
       _truncated
      </code>
      attribute is also added to the session attributes with a value
          indicating how many bytes were lost, if the attribute buffer
          has sufficient space. This enables the Performance Schema to
          expose per-connection truncation information in the connection
          attribute tables. This information can be examined without
          having to check the error log.
     </p>
     <p>
      The default value of
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_session_connect_attrs_size">
       <code class="literal">
        performance_schema_session_connect_attrs_size
       </code>
      </a>
      is autosized at server startup. This value may be small, so if
          truncation occurs
          (
      <a class="link" href="performance-schema-status-variables.html#statvar_Performance_schema_session_connect_attrs_lost">
       <code class="literal">
        Performance_schema_session_connect_attrs_lost
       </code>
      </a>
      becomes nonzero), you may wish to set
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_session_connect_attrs_size">
       <code class="literal">
        performance_schema_session_connect_attrs_size
       </code>
      </a>
      explicitly to a larger value.
     </p>
     <p>
      Although the maximum permitted
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_session_connect_attrs_size">
       <code class="literal">
        performance_schema_session_connect_attrs_size
       </code>
      </a>
      value is 1MB, the effective maximum is 64KB because the server
          imposes a limit of 64KB on the aggregate size of connection
          attribute data it accepts. If a client attempts to send more
          than 64KB of attribute data, the server rejects the
          connection. For more information, see
      <a class="xref" href="performance-schema-connection-attribute-tables.html" title="29.12.9 Performance Schema Connection Attribute Tables">
       Section 29.12.9, “Performance Schema Connection Attribute Tables”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_setup_actors_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_setup_actors_size">
       <code class="literal">
        performance_schema_setup_actors_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064680832">
     </a>
     <a class="indexterm" name="idm46045064679792">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_setup_actors_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-setup-actors-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_setup_actors_size">
            performance_schema_setup_actors_size
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autosizing; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-setup-actors-table.html" title="29.12.2.1 The setup_actors Table">
       <code class="literal">
        setup_actors
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_setup_objects_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_setup_objects_size">
       <code class="literal">
        performance_schema_setup_objects_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064648528">
     </a>
     <a class="indexterm" name="idm46045064647488">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_setup_objects_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-setup-objects-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_setup_objects_size">
            performance_schema_setup_objects_size
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-setup-objects-table.html" title="29.12.2.4 The setup_objects Table">
       <code class="literal">
        setup_objects
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_show_processlist">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_show_processlist">
       <code class="literal">
        performance_schema_show_processlist
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064616160">
     </a>
     <a class="indexterm" name="idm46045064615120">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_show_processlist">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-show-processlist[={OFF|ON}]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Deprecated
         </th>
         <td>
          Yes
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_show_processlist">
            performance_schema_show_processlist
           </a>
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Scope
         </th>
         <td>
          Global
         </td>
        </tr>
        <tr>
         <th>
          Dynamic
         </th>
         <td>
          Yes
         </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>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           OFF
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The
      <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
       <code class="literal">
        SHOW PROCESSLIST
       </code>
      </a>
      statement
          provides process information by collecting thread data from
          all active threads. The
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_show_processlist">
       <code class="literal">
        performance_schema_show_processlist
       </code>
      </a>
      variable determines which
      <code class="literal">
       SHOW PROCESSLIST
      </code>
      implementation to use:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         The default implementation iterates across active threads
              from within the thread manager while holding a global
              mutex. This has negative performance consequences,
              particularly on busy systems.
        </p>
       </li>
       <li class="listitem">
        <p>
         The alternative
         <a class="link" href="show-processlist.html" title="15.7.7.31 SHOW PROCESSLIST Statement">
          <code class="literal">
           SHOW
              PROCESSLIST
          </code>
         </a>
         implementation is based on the
              Performance Schema
         <a class="link" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
          <code class="literal">
           processlist
          </code>
         </a>
         table. This
              implementation queries active thread data from the
              Performance Schema rather than the thread manager and does
              not require a mutex.
        </p>
       </li>
      </ul>
     </div>
     <p>
      To enable the alternative implementation, enable the
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_show_processlist">
       <code class="literal">
        performance_schema_show_processlist
       </code>
      </a>
      system variable. To ensure that the default and alternative
          implementations yield the same information, certain
          configuration requirements must be met; see
      <a class="xref" href="performance-schema-processlist-table.html" title="29.12.22.7 The processlist Table">
       Section 29.12.22.7, “The processlist Table”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="sysvar_performance_schema_users_size">
      </a>
      <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_users_size">
       <code class="literal">
        performance_schema_users_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045064577392">
     </a>
     <a class="indexterm" name="idm46045064576288">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for performance_schema_users_size">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --performance-schema-users-size=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          System Variable
         </th>
         <td>
          <code class="literal">
           <a class="link" href="performance-schema-system-variables.html#sysvar_performance_schema_users_size">
            performance_schema_users_size
           </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">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           -1
          </code>
          (signifies autoscaling; do not assign this literal value)
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           1048576
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      The number of rows in the
      <a class="link" href="performance-schema-users-table.html" title="29.12.8.3 The users Table">
       <code class="literal">
        users
       </code>
      </a>
      table. If this variable is 0, the Performance Schema does not
          maintain connection statistics in the
      <a class="link" href="performance-schema-users-table.html" title="29.12.8.3 The users Table">
       <code class="literal">
        users
       </code>
      </a>
      table or status variable
          information in the
      <a class="link" href="performance-schema-status-variable-summary-tables.html" title="29.12.20.12 Status Variable Summary Tables">
       <code class="literal">
        status_by_user
       </code>
      </a>
      table.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
