<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="server-status-variables">
      </a>
      7.1.10 Server Status Variables
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045263608544">
  </a>
  <a class="indexterm" name="idm46045263607472">
  </a>
  <p>
   The MySQL server maintains many status variables that provide
      information about its operation. You can view these variables and
      their values by using the
   <code class="literal">
    SHOW [GLOBAL | SESSION]
      STATUS
   </code>
   statement (see
   <a class="xref" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
    Section 15.7.7.37, “SHOW STATUS Statement”
   </a>
   ).
      The optional
   <code class="literal">
    GLOBAL
   </code>
   keyword aggregates the
      values over all connections, and
   <code class="literal">
    SESSION
   </code>
   shows
      the values for the current connection.
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa34608703"><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">GLOBAL</span> <span class="token keyword">STATUS</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>
<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>
<span class="token output"><span class="token punctuation">|</span> Aborted_clients                   <span class="token punctuation">|</span> 0          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Aborted_connects                  <span class="token punctuation">|</span> 0          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Bytes_received                    <span class="token punctuation">|</span> 155372598  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Bytes_sent                        <span class="token punctuation">|</span> 1176560426 <span class="token punctuation">|</span></span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token output"><span class="token punctuation">|</span> Connections                       <span class="token punctuation">|</span> 30023      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Created_tmp_disk_tables           <span class="token punctuation">|</span> 0          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Created_tmp_files                 <span class="token punctuation">|</span> 3          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Created_tmp_tables                <span class="token punctuation">|</span> 2          <span class="token punctuation">|</span></span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token output"><span class="token punctuation">|</span> Threads_created                   <span class="token punctuation">|</span> 217        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Threads_running                   <span class="token punctuation">|</span> 88         <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Uptime                            <span class="token punctuation">|</span> 1389872    <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></code></pre>
  </div>
  <p>
   Many status variables are reset to 0 by the
   <a class="link" href="flush.html#flush-status">
    <code class="literal">
     FLUSH STATUS
    </code>
   </a>
   statement.
  </p>
  <p>
   This section provides a description of each status variable. For a
      status variable summary, see
   <a class="xref" href="server-status-variable-reference.html" title="7.1.6 Server Status Variable Reference">
    Section 7.1.6, “Server Status Variable Reference”
   </a>
   . For
      information about status variables specific to NDB Cluster, see
   <a class="xref" href="mysql-cluster-options-variables.html#mysql-cluster-status-variables" title="25.4.3.9.3 NDB Cluster Status Variables">
    Section 25.4.3.9.3, “NDB Cluster Status Variables”
   </a>
   .
  </p>
  <p>
   The status variables have the following meanings.
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="statvar_Aborted_clients">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Aborted_clients">
       <code class="literal">
        Aborted_clients
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263593936">
     </a>
     <a class="indexterm" name="idm46045263592848">
     </a>
     <p>
      The number of connections that were aborted because the client
          died without closing the connection properly. See
      <a class="xref" href="communication-errors.html" title="B.3.2.9 Communication Errors and Aborted Connections">
       Section B.3.2.9, “Communication Errors and Aborted Connections”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Aborted_connects">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Aborted_connects">
       <code class="literal">
        Aborted_connects
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263587520">
     </a>
     <a class="indexterm" name="idm46045263586480">
     </a>
     <p>
      The number of failed attempts to connect to the MySQL server.
          See
      <a class="xref" href="communication-errors.html" title="B.3.2.9 Communication Errors and Aborted Connections">
       Section B.3.2.9, “Communication Errors and Aborted Connections”
      </a>
      .
     </p>
     <p>
      For additional connection-related information, check the
      <a class="link" href="server-status-variables.html#statvar_Connection_errors_xxx">
       <code class="literal">
        Connection_errors_
        <em class="replaceable">
         <code>
          xxx
         </code>
        </em>
       </code>
      </a>
      status variables and the
      <a class="link" href="performance-schema-host-cache-table.html" title="29.12.22.3 The host_cache Table">
       <code class="literal">
        host_cache
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Authentication_ldap_sasl_supported_methods">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Authentication_ldap_sasl_supported_methods">
       <code class="literal">
        Authentication_ldap_sasl_supported_methods
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263577808">
     </a>
     <a class="indexterm" name="idm46045263576688">
     </a>
     <p>
      The
      <code class="literal">
       authentication_ldap_sasl
      </code>
      plugin that
          implements SASL LDAP authentication supports multiple
          authentication methods, but depending on host system
          configuration, they might not all be available. The
      <a class="link" href="server-status-variables.html#statvar_Authentication_ldap_sasl_supported_methods">
       <code class="literal">
        Authentication_ldap_sasl_supported_methods
       </code>
      </a>
      variable provides discoverability for the supported methods.
          Its value is a string consisting of supported method names
          separated by spaces. Example:
      <code class="literal">
       "SCRAM-SHA 1
          SCRAM-SHA-256 GSSAPI"
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Binlog_cache_disk_use">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Binlog_cache_disk_use">
       <code class="literal">
        Binlog_cache_disk_use
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263569168">
     </a>
     <a class="indexterm" name="idm46045263568128">
     </a>
     <p>
      The number of transactions that used the temporary binary log
          cache but that exceeded the value of
      <a class="link" href="replication-options-binary-log.html#sysvar_binlog_cache_size">
       <code class="literal">
        binlog_cache_size
       </code>
      </a>
      and used a
          temporary file to store statements from the transaction.
     </p>
     <p>
      The number of nontransactional statements that caused the
          binary log transaction cache to be written to disk is tracked
          separately in the
      <a class="link" href="server-status-variables.html#statvar_Binlog_stmt_cache_disk_use">
       <code class="literal">
        Binlog_stmt_cache_disk_use
       </code>
      </a>
      status variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Acl_cache_items_count">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Acl_cache_items_count">
       <code class="literal">
        Acl_cache_items_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263560464">
     </a>
     <a class="indexterm" name="idm46045263559424">
     </a>
     <a class="indexterm" name="idm46045263557936">
     </a>
     <a class="indexterm" name="idm46045263556848">
     </a>
     <p>
      The number of cached privilege objects. Each object is the
          privilege combination of a user and its active roles.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Binlog_cache_use">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Binlog_cache_use">
       <code class="literal">
        Binlog_cache_use
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263552368">
     </a>
     <a class="indexterm" name="idm46045263551328">
     </a>
     <p>
      The number of transactions that used the binary log cache.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Binlog_stmt_cache_disk_use">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Binlog_stmt_cache_disk_use">
       <code class="literal">
        Binlog_stmt_cache_disk_use
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263546880">
     </a>
     <a class="indexterm" name="idm46045263545776">
     </a>
     <p>
      The number of nontransaction statements that used the binary
          log statement cache but that exceeded the value of
      <a class="link" href="replication-options-binary-log.html#sysvar_binlog_stmt_cache_size">
       <code class="literal">
        binlog_stmt_cache_size
       </code>
      </a>
      and
          used a temporary file to store those statements.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Binlog_stmt_cache_use">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Binlog_stmt_cache_use">
       <code class="literal">
        Binlog_stmt_cache_use
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263539952">
     </a>
     <a class="indexterm" name="idm46045263538912">
     </a>
     <p>
      The number of nontransactional statements that used the binary
          log statement cache.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Bytes_received">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Bytes_received">
       <code class="literal">
        Bytes_received
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263534512">
     </a>
     <a class="indexterm" name="idm46045263533424">
     </a>
     <p>
      The number of bytes received from all clients.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Bytes_sent">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Bytes_sent">
       <code class="literal">
        Bytes_sent
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263529136">
     </a>
     <a class="indexterm" name="idm46045263528048">
     </a>
     <p>
      The number of bytes sent to all clients.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Caching_sha2_password_rsa_public_key">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Caching_sha2_password_rsa_public_key">
       <code class="literal">
        Caching_sha2_password_rsa_public_key
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263523552">
     </a>
     <a class="indexterm" name="idm46045263522512">
     </a>
     <p>
      The public key used by the
      <code class="literal">
       caching_sha2_password
      </code>
      authentication plugin
          for RSA key pair-based password exchange. The value is
          nonempty only if the server successfully initializes the
          private and public keys in the files named by the
      <a class="link" href="server-system-variables.html#sysvar_caching_sha2_password_private_key_path">
       <code class="literal">
        caching_sha2_password_private_key_path
       </code>
      </a>
      and
      <a class="link" href="server-system-variables.html#sysvar_caching_sha2_password_public_key_path">
       <code class="literal">
        caching_sha2_password_public_key_path
       </code>
      </a>
      system variables. The value of
      <a class="link" href="server-status-variables.html#statvar_Caching_sha2_password_rsa_public_key">
       <code class="literal">
        Caching_sha2_password_rsa_public_key
       </code>
      </a>
      comes from the latter file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Com_xxx">
      </a>
      <code class="literal">
       Com_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
     </p>
     <p>
      The
      <code class="literal">
       Com_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      statement counter variables indicate the number of times each
      <em class="replaceable">
       <code>
        xxx
       </code>
      </em>
      statement has been executed.
          There is one status variable for each type of statement. For
          example,
      <code class="literal">
       Com_delete
      </code>
      and
      <code class="literal">
       Com_update
      </code>
      count
      <a class="link" href="delete.html" title="15.2.2 DELETE Statement">
       <code class="literal">
        DELETE
       </code>
      </a>
      and
      <a class="link" href="update.html" title="15.2.17 UPDATE Statement">
       <code class="literal">
        UPDATE
       </code>
      </a>
      statements,
          respectively.
      <code class="literal">
       Com_delete_multi
      </code>
      and
      <code class="literal">
       Com_update_multi
      </code>
      are similar but apply to
      <a class="link" href="delete.html" title="15.2.2 DELETE Statement">
       <code class="literal">
        DELETE
       </code>
      </a>
      and
      <a class="link" href="update.html" title="15.2.17 UPDATE Statement">
       <code class="literal">
        UPDATE
       </code>
      </a>
      statements that use
          multiple-table syntax.
     </p>
     <p>
      All
      <code class="literal">
       Com_stmt_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      variables are increased even if a prepared statement argument
          is unknown or an error occurred during execution. In other
          words, their values correspond to the number of requests
          issued, not to the number of requests successfully completed.
          For example, because status variables are initialized for each
          server startup and do not persist across restarts, the
      <code class="literal">
       Com_restart
      </code>
      and
      <code class="literal">
       Com_shutdown
      </code>
      variables that track
      <a class="link" href="restart.html" title="15.7.8.8 RESTART Statement">
       <code class="literal">
        RESTART
       </code>
      </a>
      and
      <a class="link" href="shutdown.html" title="15.7.8.9 SHUTDOWN Statement">
       <code class="literal">
        SHUTDOWN
       </code>
      </a>
      statements normally
          have a value of zero, but can be nonzero if
      <a class="link" href="restart.html" title="15.7.8.8 RESTART Statement">
       <code class="literal">
        RESTART
       </code>
      </a>
      or
      <a class="link" href="shutdown.html" title="15.7.8.9 SHUTDOWN Statement">
       <code class="literal">
        SHUTDOWN
       </code>
      </a>
      statements were
          executed but failed.
     </p>
     <p>
      The
      <code class="literal">
       Com_stmt_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      status variables are as follows:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          Com_stmt_prepare
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Com_stmt_execute
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Com_stmt_fetch
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Com_stmt_send_long_data
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Com_stmt_reset
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Com_stmt_close
         </code>
        </p>
       </li>
      </ul>
     </div>
     <p>
      Those variables stand for prepared statement commands. Their
          names refer to the
      <code class="literal">
       COM_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      command
          set used in the network layer. In other words, their values
          increase whenever prepared statement API calls such as
      <span class="command">
       <strong>
        mysql_stmt_prepare()
       </strong>
      </span>
      ,
      <span class="command">
       <strong>
        mysql_stmt_execute()
       </strong>
      </span>
      , and so forth are
          executed. However,
      <code class="literal">
       Com_stmt_prepare
      </code>
      ,
      <code class="literal">
       Com_stmt_execute
      </code>
      and
      <code class="literal">
       Com_stmt_close
      </code>
      also increase for
      <a class="link" href="prepare.html" title="15.5.1 PREPARE Statement">
       <code class="literal">
        PREPARE
       </code>
      </a>
      ,
      <a class="link" href="execute.html" title="15.5.2 EXECUTE Statement">
       <code class="literal">
        EXECUTE
       </code>
      </a>
      , or
      <a class="link" href="deallocate-prepare.html" title="15.5.3 DEALLOCATE PREPARE Statement">
       <code class="literal">
        DEALLOCATE PREPARE
       </code>
      </a>
      ,
          respectively. Additionally, the values of the older statement
          counter variables
      <code class="literal">
       Com_prepare_sql
      </code>
      ,
      <code class="literal">
       Com_execute_sql
      </code>
      , and
      <code class="literal">
       Com_dealloc_sql
      </code>
      increase for the
      <a class="link" href="prepare.html" title="15.5.1 PREPARE Statement">
       <code class="literal">
        PREPARE
       </code>
      </a>
      ,
      <a class="link" href="execute.html" title="15.5.2 EXECUTE Statement">
       <code class="literal">
        EXECUTE
       </code>
      </a>
      , and
      <a class="link" href="deallocate-prepare.html" title="15.5.3 DEALLOCATE PREPARE Statement">
       <code class="literal">
        DEALLOCATE PREPARE
       </code>
      </a>
      statements.
      <code class="literal">
       Com_stmt_fetch
      </code>
      stands for the total number
          of network round-trips issued when fetching from cursors.
     </p>
     <p>
      <code class="literal">
       Com_stmt_reprepare
      </code>
      indicates the number of
          times statements were automatically reprepared by the server,
          for example, after metadata changes to tables or views
          referred to by the statement. A reprepare operation increments
      <code class="literal">
       Com_stmt_reprepare
      </code>
      , and also
      <code class="literal">
       Com_stmt_prepare
      </code>
      .
     </p>
     <p>
      <code class="literal">
       Com_explain_other
      </code>
      indicates the number of
      <a class="link" href="explain.html" title="15.8.2 EXPLAIN Statement">
       <code class="literal">
        EXPLAIN FOR
          CONNECTION
       </code>
      </a>
      statements executed. See
      <a class="xref" href="explain-for-connection.html" title="10.8.4 Obtaining Execution Plan Information for a Named Connection">
       Section 10.8.4, “Obtaining Execution Plan Information for a Named Connection”
      </a>
      .
     </p>
     <p>
      <code class="literal">
       Com_change_repl_filter
      </code>
      indicates the number
          of
      <a class="link" href="change-replication-filter.html" title="15.4.2.1 CHANGE REPLICATION FILTER Statement">
       <code class="literal">
        CHANGE REPLICATION FILTER
       </code>
      </a>
      statements executed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Compression">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Compression">
       <code class="literal">
        Compression
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263457376">
     </a>
     <a class="indexterm" name="idm46045263456288">
     </a>
     <p>
      Whether the client connection uses compression in the
          client/server protocol.
     </p>
     <p>
      This status variable is deprecated; expect it to be removed in
          a future version of MySQL. See
      <a class="xref" href="connection-compression-control.html#connection-compression-legacy-configuration" title="Configuring Legacy Connection Compression">
       Configuring Legacy Connection Compression
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Compression_algorithm">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Compression_algorithm">
       <code class="literal">
        Compression_algorithm
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263450576">
     </a>
     <a class="indexterm" name="idm46045263449536">
     </a>
     <p>
      The name of the compression algorithm in use for the current
          connection to the server. The value can be any algorithm
          permitted in the value of the
      <a class="link" href="server-system-variables.html#sysvar_protocol_compression_algorithms">
       <code class="literal">
        protocol_compression_algorithms
       </code>
      </a>
      system variable. For example, the value is
      <code class="literal">
       uncompressed
      </code>
      if the connection does not use
          compression, or
      <code class="literal">
       zlib
      </code>
      if the connection uses
          the
      <code class="literal">
       zlib
      </code>
      algorithm.
     </p>
     <p>
      For more information, see
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Compression_level">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Compression_level">
       <code class="literal">
        Compression_level
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263440240">
     </a>
     <a class="indexterm" name="idm46045263439200">
     </a>
     <p>
      The compression level in use for the current connection to the
          server. The value is 6 for
      <code class="literal">
       zlib
      </code>
      connections
          (the default
      <code class="literal">
       zlib
      </code>
      algorithm compression
          level), 1 to 22 for
      <code class="literal">
       zstd
      </code>
      connections, and 0
          for
      <code class="literal">
       uncompressed
      </code>
      connections.
     </p>
     <p>
      For more information, see
      <a class="xref" href="connection-compression-control.html" title="6.2.8 Connection Compression Control">
       Section 6.2.8, “Connection Compression Control”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Connection_errors_xxx">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Connection_errors_xxx">
       <code class="literal">
        Connection_errors_
        <em class="replaceable">
         <code>
          xxx
         </code>
        </em>
       </code>
      </a>
     </p>
     <p>
      These variables provide information about errors that occur
          during the client connection process. They are global only and
          represent error counts aggregated across connections from all
          hosts. These variables track errors not accounted for by the
          host cache (see
      <a class="xref" href="host-cache.html" title="7.1.12.3 DNS Lookups and the Host Cache">
       Section 7.1.12.3, “DNS Lookups and the Host Cache”
      </a>
      ), such as errors
          that are not associated with TCP connections, occur very early
          in the connection process (even before an IP address is
          known), or are not specific to any particular IP address (such
          as out-of-memory conditions).
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <a name="statvar_Connection_errors_accept">
         </a>
         <a class="link" href="server-status-variables.html#statvar_Connection_errors_accept">
          <code class="literal">
           Connection_errors_accept
          </code>
         </a>
        </p>
        <a class="indexterm" name="idm46045263426128">
        </a>
        <a class="indexterm" name="idm46045263425024">
        </a>
        <p>
         The number of errors that occurred during calls to
         <code class="literal">
          accept()
         </code>
         on the listening port.
        </p>
       </li>
       <li class="listitem">
        <p>
         <a name="statvar_Connection_errors_internal">
         </a>
         <a class="link" href="server-status-variables.html#statvar_Connection_errors_internal">
          <code class="literal">
           Connection_errors_internal
          </code>
         </a>
        </p>
        <a class="indexterm" name="idm46045263419888">
        </a>
        <a class="indexterm" name="idm46045263418784">
        </a>
        <p>
         The number of connections refused due to internal errors
              in the server, such as failure to start a new thread or an
              out-of-memory condition.
        </p>
       </li>
       <li class="listitem">
        <p>
         <a name="statvar_Connection_errors_max_connections">
         </a>
         <a class="link" href="server-status-variables.html#statvar_Connection_errors_max_connections">
          <code class="literal">
           Connection_errors_max_connections
          </code>
         </a>
        </p>
        <a class="indexterm" name="idm46045263414144">
        </a>
        <a class="indexterm" name="idm46045263413104">
        </a>
        <p>
         The number of connections refused because the server
         <a class="link" href="server-system-variables.html#sysvar_max_connections">
          <code class="literal">
           max_connections
          </code>
         </a>
         limit was
              reached.
        </p>
       </li>
       <li class="listitem">
        <p>
         <a name="statvar_Connection_errors_peer_address">
         </a>
         <a class="link" href="server-status-variables.html#statvar_Connection_errors_peer_address">
          <code class="literal">
           Connection_errors_peer_address
          </code>
         </a>
        </p>
        <a class="indexterm" name="idm46045263407376">
        </a>
        <a class="indexterm" name="idm46045263406272">
        </a>
        <p>
         The number of errors that occurred while searching for
              connecting client IP addresses.
        </p>
       </li>
       <li class="listitem">
        <p>
         <a name="statvar_Connection_errors_select">
         </a>
         <a class="link" href="server-status-variables.html#statvar_Connection_errors_select">
          <code class="literal">
           Connection_errors_select
          </code>
         </a>
        </p>
        <a class="indexterm" name="idm46045263401824">
        </a>
        <a class="indexterm" name="idm46045263400720">
        </a>
        <p>
         The number of errors that occurred during calls to
         <code class="literal">
          select()
         </code>
         or
         <code class="literal">
          poll()
         </code>
         on the listening port. (Failure of this operation does not
              necessarily means a client connection was rejected.)
        </p>
       </li>
       <li class="listitem">
        <p>
         <a name="statvar_Connection_errors_tcpwrap">
         </a>
         <a class="link" href="server-status-variables.html#statvar_Connection_errors_tcpwrap">
          <code class="literal">
           Connection_errors_tcpwrap
          </code>
         </a>
        </p>
        <a class="indexterm" name="idm46045263394736">
        </a>
        <a class="indexterm" name="idm46045263393632">
        </a>
        <p>
         The number of connections refused by the
         <code class="literal">
          libwrap
         </code>
         library.
        </p>
       </li>
      </ul>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Connections">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Connections">
       <code class="literal">
        Connections
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263388288">
     </a>
     <a class="indexterm" name="idm46045263387200">
     </a>
     <p>
      The number of connection attempts (successful or not) to the
          MySQL server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Created_tmp_disk_tables">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Created_tmp_disk_tables">
       <code class="literal">
        Created_tmp_disk_tables
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263382688">
     </a>
     <a class="indexterm" name="idm46045263381648">
     </a>
     <p>
      The number of internal on-disk temporary tables created by the
          server while executing statements.
     </p>
     <p>
      You can compare the number of internal on-disk temporary
          tables created to the total number of internal temporary
          tables created by comparing
      <a class="link" href="server-status-variables.html#statvar_Created_tmp_disk_tables">
       <code class="literal">
        Created_tmp_disk_tables
       </code>
      </a>
      and
      <a class="link" href="server-status-variables.html#statvar_Created_tmp_tables">
       <code class="literal">
        Created_tmp_tables
       </code>
      </a>
      values.
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       Due to a known limitation,
       <a class="link" href="server-status-variables.html#statvar_Created_tmp_disk_tables">
        <code class="literal">
         Created_tmp_disk_tables
        </code>
       </a>
       does not count on-disk temporary tables created in
            memory-mapped files. By default, the TempTable storage
            engine overflow mechanism creates internal temporary tables
            in memory-mapped files. This behavior is controlled by the
       <a class="link" href="server-system-variables.html#sysvar_temptable_use_mmap">
        <code class="literal">
         temptable_use_mmap
        </code>
       </a>
       variable.
      </p>
     </div>
     <p>
      See also
      <a class="xref" href="internal-temporary-tables.html" title="10.4.4 Internal Temporary Table Use in MySQL">
       Section 10.4.4, “Internal Temporary Table Use in MySQL”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Created_tmp_files">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Created_tmp_files">
       <code class="literal">
        Created_tmp_files
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263369312">
     </a>
     <a class="indexterm" name="idm46045263368272">
     </a>
     <p>
      How many temporary files
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
      has
          created.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Created_tmp_tables">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Created_tmp_tables">
       <code class="literal">
        Created_tmp_tables
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263362592">
     </a>
     <a class="indexterm" name="idm46045263361552">
     </a>
     <p>
      The number of internal temporary tables created by the server
          while executing statements.
     </p>
     <p>
      You can compare the number of internal on-disk temporary
          tables created to the total number of internal temporary
          tables created by comparing
      <a class="link" href="server-status-variables.html#statvar_Created_tmp_disk_tables">
       <code class="literal">
        Created_tmp_disk_tables
       </code>
      </a>
      and
      <a class="link" href="server-status-variables.html#statvar_Created_tmp_tables">
       <code class="literal">
        Created_tmp_tables
       </code>
      </a>
      values.
     </p>
     <p>
      See also
      <a class="xref" href="internal-temporary-tables.html" title="10.4.4 Internal Temporary Table Use in MySQL">
       Section 10.4.4, “Internal Temporary Table Use in MySQL”
      </a>
      .
     </p>
     <p>
      Each invocation of the
      <a class="link" href="show-status.html" title="15.7.7.37 SHOW STATUS Statement">
       <code class="literal">
        SHOW
          STATUS
       </code>
      </a>
      statement uses an internal temporary table
          and increments the global
      <a class="link" href="server-status-variables.html#statvar_Created_tmp_tables">
       <code class="literal">
        Created_tmp_tables
       </code>
      </a>
      value.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_ca">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263349920">
     </a>
     <a class="indexterm" name="idm46045263348832">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_ssl_ca">
       <code class="literal">
        ssl_ca
       </code>
      </a>
      value in
          the SSL context that the server uses for new connections. This
          context value may differ from the current
      <a class="link" href="server-system-variables.html#sysvar_ssl_ca">
       <code class="literal">
        ssl_ca
       </code>
      </a>
      system variable value
          if the system variable has been changed but
      <a class="link" href="alter-instance.html#alter-instance-reload-tls">
       <code class="literal">
        ALTER INSTANCE RELOAD TLS
       </code>
      </a>
      has
          not subsequently been executed to reconfigure the SSL context
          from the context-related system variable values and update the
          corresponding status variables. (This potential difference in
          values applies to each corresponding pair of context-related
          system and status variables. See
      <a class="xref" href="using-encrypted-connections.html#using-encrypted-connections-server-side-runtime-configuration" title="Server-Side Runtime Configuration and Monitoring for Encrypted Connections">
       Server-Side Runtime Configuration and Monitoring for Encrypted
        Connections
      </a>
      .)
     </p>
     <p>
      The
      <code class="literal">
       Current_tls_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
      status variable values are also available through the
          Performance Schema
      <a class="link" href="performance-schema-tls-channel-status-table.html" title="29.12.22.9 The tls_channel_status Table">
       <code class="literal">
        tls_channel_status
       </code>
      </a>
      table. See
      <a class="xref" href="performance-schema-tls-channel-status-table.html" title="29.12.22.9 The tls_channel_status Table">
       Section 29.12.22.9, “The tls_channel_status Table”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_capath">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_capath">
       <code class="literal">
        Current_tls_capath
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263335584">
     </a>
     <a class="indexterm" name="idm46045263334544">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_ssl_capath">
       <code class="literal">
        ssl_capath
       </code>
      </a>
      value
          in the TLS context that the server uses for new connections.
          For notes about the relationship between this status variable
          and its corresponding system variable, see the description of
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_cert">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_cert">
       <code class="literal">
        Current_tls_cert
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263327504">
     </a>
     <a class="indexterm" name="idm46045263326464">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_ssl_cert">
       <code class="literal">
        ssl_cert
       </code>
      </a>
      value in
          the TLS context that the server uses for new connections. For
          notes about the relationship between this status variable and
          its corresponding system variable, see the description of
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_cipher">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_cipher">
       <code class="literal">
        Current_tls_cipher
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263319360">
     </a>
     <a class="indexterm" name="idm46045263318320">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_ssl_cipher">
       <code class="literal">
        ssl_cipher
       </code>
      </a>
      value
          in the TLS context that the server uses for new connections.
          For notes about the relationship between this status variable
          and its corresponding system variable, see the description of
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_ciphersuites">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ciphersuites">
       <code class="literal">
        Current_tls_ciphersuites
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263311248">
     </a>
     <a class="indexterm" name="idm46045263310144">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_tls_ciphersuites">
       <code class="literal">
        tls_ciphersuites
       </code>
      </a>
      value in the TLS context that the server uses for new
          connections. For notes about the relationship between this
          status variable and its corresponding system variable, see the
          description of
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_crl">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_crl">
       <code class="literal">
        Current_tls_crl
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263303200">
     </a>
     <a class="indexterm" name="idm46045263302112">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_ssl_crl">
       <code class="literal">
        ssl_crl
       </code>
      </a>
      value in
          the TLS context that the server uses for new connections. For
          notes about the relationship between this status variable and
          its corresponding system variable, see the description of
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
      .
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       When you reload the TLS context, OpenSSL reloads the file
            containing the CRL (certificate revocation list) as part of
            the process. If the CRL file is large, the server allocates
            a large chunk of memory (ten times the file size), which is
            doubled while the new instance is being loaded and the old
            one has not yet been released. The process resident memory
            is not immediately reduced after a large allocation is
            freed, so if you issue the
       <code class="literal">
        ALTER INSTANCE RELOAD
            TLS
       </code>
       statement repeatedly with a large CRL file,
            the process resident memory usage may grow as a result of
            this.
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_crlpath">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_crlpath">
       <code class="literal">
        Current_tls_crlpath
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263292896">
     </a>
     <a class="indexterm" name="idm46045263291856">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_ssl_crlpath">
       <code class="literal">
        ssl_crlpath
       </code>
      </a>
      value
          in the TLS context that the server uses for new connections.
          For notes about the relationship between this status variable
          and its corresponding system variable, see the description of
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_key">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_key">
       <code class="literal">
        Current_tls_key
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263284928">
     </a>
     <a class="indexterm" name="idm46045263283840">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_ssl_key">
       <code class="literal">
        ssl_key
       </code>
      </a>
      value in
          the TLS context that the server uses for new connections. For
          notes about the relationship between this status variable and
          its corresponding system variable, see the description of
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Current_tls_version">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Current_tls_version">
       <code class="literal">
        Current_tls_version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263276736">
     </a>
     <a class="indexterm" name="idm46045263275696">
     </a>
     <p>
      The active
      <a class="link" href="server-system-variables.html#sysvar_tls_version">
       <code class="literal">
        tls_version
       </code>
      </a>
      value
          in the TLS context that the server uses for new connections.
          For notes about the relationship between this status variable
          and its corresponding system variable, see the description of
      <a class="link" href="server-status-variables.html#statvar_Current_tls_ca">
       <code class="literal">
        Current_tls_ca
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Delayed_errors">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Delayed_errors">
       <code class="literal">
        Delayed_errors
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263268704">
     </a>
     <a class="indexterm" name="idm46045263267616">
     </a>
     <p>
      This status variable is deprecated (because
      <code class="literal">
       DELAYED
      </code>
      inserts are not supported); expect
          it to be removed in a future release.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Delayed_insert_threads">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Delayed_insert_threads">
       <code class="literal">
        Delayed_insert_threads
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263262432">
     </a>
     <a class="indexterm" name="idm46045263261392">
     </a>
     <p>
      This status variable is deprecated (because
      <code class="literal">
       DELAYED
      </code>
      inserts are not supported); expect
          it to be removed in a future release.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Delayed_writes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Delayed_writes">
       <code class="literal">
        Delayed_writes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263256240">
     </a>
     <a class="indexterm" name="idm46045263255152">
     </a>
     <p>
      This status variable is deprecated (because
      <code class="literal">
       DELAYED
      </code>
      inserts are not supported); expect
          it to be removed in a future release.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Deprecated_use_i_s_processlist_count">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Deprecated_use_i_s_processlist_count">
       <code class="literal">
        Deprecated_use_i_s_processlist_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263249792">
     </a>
     <a class="indexterm" name="idm46045263248752">
     </a>
     <p>
      How many times the
      <a class="link" href="information-schema-processlist-table.html" title="28.3.23 The INFORMATION_SCHEMA PROCESSLIST Table">
       <code class="literal">
        information_schema.processlist
       </code>
      </a>
      table has been accessed since the last restart.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Deprecated_use_i_s_processlist_last_timestamp">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Deprecated_use_i_s_processlist_last_timestamp">
       <code class="literal">
        Deprecated_use_i_s_processlist_last_timestamp
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263242976">
     </a>
     <a class="indexterm" name="idm46045263241856">
     </a>
     <p>
      A timestamp indicating the last time the
      <a class="link" href="information-schema-processlist-table.html" title="28.3.23 The INFORMATION_SCHEMA PROCESSLIST Table">
       <code class="literal">
        information_schema.processlist
       </code>
      </a>
      table has been accessed since the last restart. Shows
          microseconds since the Unix Epoch.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_dragnet.Status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_dragnet.Status">
       <code class="literal">
        dragnet.Status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263236096">
     </a>
     <a class="indexterm" name="idm46045263235008">
     </a>
     <p>
      The result of the most recent assignment to the
      <a class="link" href="server-system-variables.html#sysvar_dragnet.log_error_filter_rules">
       <code class="literal">
        dragnet.log_error_filter_rules
       </code>
      </a>
      system variable, empty if no such assignment has occurred.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Error_log_buffered_bytes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Error_log_buffered_bytes">
       <code class="literal">
        Error_log_buffered_bytes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263229232">
     </a>
     <a class="indexterm" name="idm46045263228128">
     </a>
     <p>
      The number of bytes currently used in the Performance Schema
      <a class="link" href="performance-schema-error-log-table.html" title="29.12.22.2 The error_log Table">
       <code class="literal">
        error_log
       </code>
      </a>
      table. It is possible
          for the value to decrease, for example, if a new event cannot
          fit until discarding an old event, but the new event is
          smaller than the old one.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Error_log_buffered_events">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Error_log_buffered_events">
       <code class="literal">
        Error_log_buffered_events
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263222096">
     </a>
     <a class="indexterm" name="idm46045263220992">
     </a>
     <p>
      The number of events currently present in the Performance
          Schema
      <a class="link" href="performance-schema-error-log-table.html" title="29.12.22.2 The error_log Table">
       <code class="literal">
        error_log
       </code>
      </a>
      table. As with
      <a class="link" href="server-status-variables.html#statvar_Error_log_buffered_bytes">
       <code class="literal">
        Error_log_buffered_bytes
       </code>
      </a>
      , it
          is possible for the value to decrease.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Error_log_expired_events">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Error_log_expired_events">
       <code class="literal">
        Error_log_expired_events
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263213920">
     </a>
     <a class="indexterm" name="idm46045263212816">
     </a>
     <p>
      The number of events discarded from the Performance Schema
      <a class="link" href="performance-schema-error-log-table.html" title="29.12.22.2 The error_log Table">
       <code class="literal">
        error_log
       </code>
      </a>
      table to make room for
          new events.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Error_log_latest_write">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Error_log_latest_write">
       <code class="literal">
        Error_log_latest_write
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263207088">
     </a>
     <a class="indexterm" name="idm46045263206048">
     </a>
     <p>
      The time of the last write to the Performance Schema
      <a class="link" href="performance-schema-error-log-table.html" title="29.12.22.2 The error_log Table">
       <code class="literal">
        error_log
       </code>
      </a>
      table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Flush_commands">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Flush_commands">
       <code class="literal">
        Flush_commands
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263200480">
     </a>
     <a class="indexterm" name="idm46045263199392">
     </a>
     <p>
      The number of times the server flushes tables, whether because
          a user executed a
      <a class="link" href="flush.html#flush-tables">
       <code class="literal">
        FLUSH TABLES
       </code>
      </a>
      statement or due to internal server operation. It is also
          incremented by receipt of a
      <code class="literal">
       COM_REFRESH
      </code>
      packet. This is in contrast to
      <a class="link" href="server-status-variables.html#statvar_Com_xxx">
       <code class="literal">
        Com_flush
       </code>
      </a>
      ,
          which indicates how many
      <code class="literal">
       FLUSH
      </code>
      statements
          have been executed, whether
      <a class="link" href="flush.html#flush-tables">
       <code class="literal">
        FLUSH
          TABLES
       </code>
      </a>
      ,
      <a class="link" href="flush.html#flush-logs">
       <code class="literal">
        FLUSH LOGS
       </code>
      </a>
      ,
          and so forth.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Global_connection_memory">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Global_connection_memory">
       <code class="literal">
        Global_connection_memory
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263188464">
     </a>
     <a class="indexterm" name="idm46045263187360">
     </a>
     <p>
      The memory used by all user connections to the server. Memory
          used by system threads or by the MySQL root account is
          included in the total, but such threads or users are not
          subject to disconnection due to memory usage. This memory is
          not calculated unless
      <a class="link" href="server-system-variables.html#sysvar_global_connection_memory_tracking">
       <code class="literal">
        global_connection_memory_tracking
       </code>
      </a>
      is enabled (disabled by default). The Performance Schema must
          also be enabled.
     </p>
     <p>
      You can control (indirectly) the frequency with which this
          variable is updated by setting
      <a class="link" href="server-system-variables.html#sysvar_connection_memory_chunk_size">
       <code class="literal">
        connection_memory_chunk_size
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_commit">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_commit">
       <code class="literal">
        Handler_commit
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263179520">
     </a>
     <a class="indexterm" name="idm46045263178432">
     </a>
     <p>
      The number of internal
      <a class="link" href="commit.html" title="15.3.1 START TRANSACTION, COMMIT, and ROLLBACK Statements">
       <code class="literal">
        COMMIT
       </code>
      </a>
      statements.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_delete">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_delete">
       <code class="literal">
        Handler_delete
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263172864">
     </a>
     <a class="indexterm" name="idm46045263171776">
     </a>
     <p>
      The number of times that rows have been deleted from tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_external_lock">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_external_lock">
       <code class="literal">
        Handler_external_lock
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263167360">
     </a>
     <a class="indexterm" name="idm46045263166320">
     </a>
     <a class="indexterm" name="idm46045263164832">
     </a>
     <p>
      The server increments this variable for each call to its
      <code class="literal">
       external_lock()
      </code>
      function, which generally
          occurs at the beginning and end of access to a table instance.
          There might be differences among storage engines. This
          variable can be used, for example, to discover for a statement
          that accesses a partitioned table how many partitions were
          pruned before locking occurred: Check how much the counter
          increased for the statement, subtract 2 (2 calls for the table
          itself), then divide by 2 to get the number of partitions
          locked.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_mrr_init">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_mrr_init">
       <code class="literal">
        Handler_mrr_init
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263159520">
     </a>
     <a class="indexterm" name="idm46045263158480">
     </a>
     <p>
      The number of times the server uses a storage engine's own
          Multi-Range Read implementation for table access.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_prepare">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_prepare">
       <code class="literal">
        Handler_prepare
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263154048">
     </a>
     <a class="indexterm" name="idm46045263152960">
     </a>
     <a class="indexterm" name="idm46045263151472">
     </a>
     <p>
      A counter for the prepare phase of two-phase commit
          operations.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_read_first">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_read_first">
       <code class="literal">
        Handler_read_first
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263147456">
     </a>
     <a class="indexterm" name="idm46045263146416">
     </a>
     <p>
      The number of times the first entry in an index was read. If
          this value is high, it suggests that the server is doing a lot
          of full index scans (for example,
      <code class="literal">
       SELECT col1 FROM
          foo
      </code>
      , assuming that
      <code class="literal">
       col1
      </code>
      is
          indexed).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_read_key">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_read_key">
       <code class="literal">
        Handler_read_key
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263140416">
     </a>
     <a class="indexterm" name="idm46045263139376">
     </a>
     <p>
      The number of requests to read a row based on a key. If this
          value is high, it is a good indication that your tables are
          properly indexed for your queries.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_read_last">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_read_last">
       <code class="literal">
        Handler_read_last
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263134848">
     </a>
     <a class="indexterm" name="idm46045263133808">
     </a>
     <p>
      The number of requests to read the last key in an index. With
      <code class="literal">
       ORDER BY
      </code>
      , the server issues a first-key
          request followed by several next-key requests, whereas with
      <code class="literal">
       ORDER BY DESC
      </code>
      , the server issues a last-key
          request followed by several previous-key requests.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_read_next">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_read_next">
       <code class="literal">
        Handler_read_next
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263127776">
     </a>
     <a class="indexterm" name="idm46045263126736">
     </a>
     <p>
      The number of requests to read the next row in key order. This
          value is incremented if you are querying an index column with
          a range constraint or if you are doing an index scan.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_read_prev">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_read_prev">
       <code class="literal">
        Handler_read_prev
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263122112">
     </a>
     <a class="indexterm" name="idm46045263121072">
     </a>
     <p>
      The number of requests to read the previous row in key order.
          This read method is mainly used to optimize
      <code class="literal">
       ORDER BY
          ... DESC
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_read_rnd">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_read_rnd">
       <code class="literal">
        Handler_read_rnd
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263115808">
     </a>
     <a class="indexterm" name="idm46045263114768">
     </a>
     <p>
      The number of requests to read a row based on a fixed
          position. This value is high if you are doing a lot of queries
          that require sorting of the result. You probably have a lot of
          queries that require MySQL to scan entire tables or you have
          joins that do not use keys properly.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_read_rnd_next">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_read_rnd_next">
       <code class="literal">
        Handler_read_rnd_next
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263110032">
     </a>
     <a class="indexterm" name="idm46045263108992">
     </a>
     <p>
      The number of requests to read the next row in the data file.
          This value is high if you are doing a lot of table scans.
          Generally this suggests that your tables are not properly
          indexed or that your queries are not written to take advantage
          of the indexes you have.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_rollback">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_rollback">
       <code class="literal">
        Handler_rollback
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263104272">
     </a>
     <a class="indexterm" name="idm46045263103232">
     </a>
     <p>
      The number of requests for a storage engine to perform a
          rollback operation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_savepoint">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_savepoint">
       <code class="literal">
        Handler_savepoint
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263098720">
     </a>
     <a class="indexterm" name="idm46045263097680">
     </a>
     <p>
      The number of requests for a storage engine to place a
          savepoint.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_savepoint_rollback">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_savepoint_rollback">
       <code class="literal">
        Handler_savepoint_rollback
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263093280">
     </a>
     <a class="indexterm" name="idm46045263092176">
     </a>
     <p>
      The number of requests for a storage engine to roll back to a
          savepoint.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_update">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_update">
       <code class="literal">
        Handler_update
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263087776">
     </a>
     <a class="indexterm" name="idm46045263086688">
     </a>
     <p>
      The number of requests to update a row in a table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Handler_write">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Handler_write">
       <code class="literal">
        Handler_write
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263082400">
     </a>
     <a class="indexterm" name="idm46045263081312">
     </a>
     <p>
      The number of requests to insert a row in a table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_dump_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_dump_status">
       <code class="literal">
        Innodb_buffer_pool_dump_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263076880">
     </a>
     <a class="indexterm" name="idm46045263075776">
     </a>
     <p>
      The progress of an operation to record the
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      held in the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      , triggered
          by the setting of
      <code class="literal">
       innodb_buffer_pool_dump_at_shutdown
      </code>
      or
      <code class="literal">
       innodb_buffer_pool_dump_now
      </code>
      .
     </p>
     <p>
      For related information and examples, see
      <a class="xref" href="innodb-preload-buffer-pool.html" title="17.8.3.6 Saving and Restoring the Buffer Pool State">
       Section 17.8.3.6, “Saving and Restoring the Buffer Pool State”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_load_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_load_status">
       <code class="literal">
        Innodb_buffer_pool_load_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263065840">
     </a>
     <a class="indexterm" name="idm46045263064736">
     </a>
     <p>
      The progress of an operation to
      <a class="link" href="glossary.html#glos_warm_up" title="warm up">
       warm up
      </a>
      the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      by reading
          in a set of
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      corresponding to an earlier point in time, triggered by the
          setting of
      <a class="link" href="innodb-parameters.html#sysvar_innodb_buffer_pool_load_at_startup">
       <code class="literal">
        innodb_buffer_pool_load_at_startup
       </code>
      </a>
      or
      <a class="link" href="innodb-parameters.html#sysvar_innodb_buffer_pool_load_now">
       <code class="literal">
        innodb_buffer_pool_load_now
       </code>
      </a>
      .
          If the operation introduces too much overhead, you can cancel
          it by setting
      <a class="link" href="innodb-parameters.html#sysvar_innodb_buffer_pool_load_abort">
       <code class="literal">
        innodb_buffer_pool_load_abort
       </code>
      </a>
      .
     </p>
     <p>
      For related information and examples, see
      <a class="xref" href="innodb-preload-buffer-pool.html" title="17.8.3.6 Saving and Restoring the Buffer Pool State">
       Section 17.8.3.6, “Saving and Restoring the Buffer Pool State”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_bytes_data">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_bytes_data">
       <code class="literal">
        Innodb_buffer_pool_bytes_data
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263051760">
     </a>
     <a class="indexterm" name="idm46045263050656">
     </a>
     <p>
      The total number of bytes in the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      containing
          data. The number includes both
      <a class="link" href="glossary.html#glos_dirty_page" title="dirty page">
       dirty
      </a>
      and clean pages.
          For more accurate memory usage calculations than with
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_data">
       <code class="literal">
        Innodb_buffer_pool_pages_data
       </code>
      </a>
      ,
          when
      <a class="link" href="glossary.html#glos_compression" title="compression">
       compressed
      </a>
      tables
          cause the buffer pool to hold pages of different sizes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_pages_data">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_data">
       <code class="literal">
        Innodb_buffer_pool_pages_data
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263041312">
     </a>
     <a class="indexterm" name="idm46045263040208">
     </a>
     <p>
      The number of
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      in the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      containing
          data. The number includes both
      <a class="link" href="glossary.html#glos_dirty_page" title="dirty page">
       dirty
      </a>
      and clean pages.
          When using
      <a class="link" href="glossary.html#glos_compressed_table" title="compressed table">
       compressed
          tables
      </a>
      , the reported
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_data">
       <code class="literal">
        Innodb_buffer_pool_pages_data
       </code>
      </a>
      value may be larger than
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_total">
       <code class="literal">
        Innodb_buffer_pool_pages_total
       </code>
      </a>
      (Bug #59550).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_bytes_dirty">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_bytes_dirty">
       <code class="literal">
        Innodb_buffer_pool_bytes_dirty
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263028896">
     </a>
     <a class="indexterm" name="idm46045263027792">
     </a>
     <p>
      The total current number of bytes held in
      <a class="link" href="glossary.html#glos_dirty_page" title="dirty page">
       dirty pages
      </a>
      in the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      . For more
          accurate memory usage calculations than with
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_dirty">
       <code class="literal">
        Innodb_buffer_pool_pages_dirty
       </code>
      </a>
      ,
          when
      <a class="link" href="glossary.html#glos_compression" title="compression">
       compressed
      </a>
      tables
          cause the buffer pool to hold pages of different sizes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_pages_dirty">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_dirty">
       <code class="literal">
        Innodb_buffer_pool_pages_dirty
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263018752">
     </a>
     <a class="indexterm" name="idm46045263017648">
     </a>
     <p>
      The current number of
      <a class="link" href="glossary.html#glos_dirty_page" title="dirty page">
       dirty
          pages
      </a>
      in the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_pages_flushed">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_flushed">
       <code class="literal">
        Innodb_buffer_pool_pages_flushed
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263010752">
     </a>
     <a class="indexterm" name="idm46045263009712">
     </a>
     <p>
      The number of requests to
      <a class="link" href="glossary.html#glos_flush" title="flush">
       flush
      </a>
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      from the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_pages_free">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_free">
       <code class="literal">
        Innodb_buffer_pool_pages_free
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045263001952">
     </a>
     <a class="indexterm" name="idm46045263000848">
     </a>
     <p>
      The number of free
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      in
          the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_pages_latched">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_latched">
       <code class="literal">
        Innodb_buffer_pool_pages_latched
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262993952">
     </a>
     <a class="indexterm" name="idm46045262992912">
     </a>
     <p>
      The number of latched
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      in the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      . These are
          pages currently being read or written, or that cannot be
      <a class="link" href="glossary.html#glos_flush" title="flush">
       flushed
      </a>
      or removed for some
          other reason. Calculation of this variable is expensive, so it
          is available only when the
      <code class="literal">
       UNIV_DEBUG
      </code>
      system is defined at server build time.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_pages_misc">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_misc">
       <code class="literal">
        Innodb_buffer_pool_pages_misc
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262984352">
     </a>
     <a class="indexterm" name="idm46045262983248">
     </a>
     <p>
      The number of
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      in the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      that are
          busy because they have been allocated for administrative
          overhead, such as
      <a class="link" href="glossary.html#glos_row_lock" title="row lock">
       row
          locks
      </a>
      or the
      <a class="link" href="glossary.html#glos_adaptive_hash_index" title="adaptive hash index">
       adaptive hash
          index
      </a>
      . This value can also be calculated as
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_total">
       <code class="literal">
        Innodb_buffer_pool_pages_total
       </code>
      </a>
      −
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_free">
       <code class="literal">
        Innodb_buffer_pool_pages_free
       </code>
      </a>
      −
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_data">
       <code class="literal">
        Innodb_buffer_pool_pages_data
       </code>
      </a>
      .
          When using
      <a class="link" href="glossary.html#glos_compressed_table" title="compressed table">
       compressed
          tables
      </a>
      ,
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_misc">
       <code class="literal">
        Innodb_buffer_pool_pages_misc
       </code>
      </a>
      may report an out-of-bounds value (Bug #59550).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_pages_total">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_total">
       <code class="literal">
        Innodb_buffer_pool_pages_total
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262968256">
     </a>
     <a class="indexterm" name="idm46045262967152">
     </a>
     <p>
      The total size of the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      , in
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      . When using
      <a class="link" href="glossary.html#glos_compressed_table" title="compressed table">
       compressed
          tables
      </a>
      , the reported
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_data">
       <code class="literal">
        Innodb_buffer_pool_pages_data
       </code>
      </a>
      value may be larger than
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_pages_total">
       <code class="literal">
        Innodb_buffer_pool_pages_total
       </code>
      </a>
      (Bug #59550)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_read_ahead">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_read_ahead">
       <code class="literal">
        Innodb_buffer_pool_read_ahead
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262956912">
     </a>
     <a class="indexterm" name="idm46045262955808">
     </a>
     <p>
      The number of
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      read into
          the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      by the
      <a class="link" href="glossary.html#glos_read_ahead" title="read-ahead">
       read-ahead
      </a>
      background
          thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_read_ahead_evicted">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_read_ahead_evicted">
       <code class="literal">
        Innodb_buffer_pool_read_ahead_evicted
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262947936">
     </a>
     <a class="indexterm" name="idm46045262946896">
     </a>
     <p>
      The number of
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      read into
          the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      by the
      <a class="link" href="glossary.html#glos_read_ahead" title="read-ahead">
       read-ahead
      </a>
      background
          thread that were subsequently
      <a class="link" href="glossary.html#glos_eviction" title="eviction">
       evicted
      </a>
      without having
          been accessed by queries.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_read_ahead_rnd">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_read_ahead_rnd">
       <code class="literal">
        Innodb_buffer_pool_read_ahead_rnd
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262938096">
     </a>
     <a class="indexterm" name="idm46045262937056">
     </a>
     <p>
      The number of
      <span class="quote">
       “
       <span class="quote">
        random
       </span>
       ”
      </span>
      read-aheads initiated by
      <code class="literal">
       InnoDB
      </code>
      . This happens when a query scans a
          large portion of a table but in random order.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_read_requests">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_read_requests">
       <code class="literal">
        Innodb_buffer_pool_read_requests
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262931312">
     </a>
     <a class="indexterm" name="idm46045262930272">
     </a>
     <p>
      The number of logical read requests.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_reads">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_reads">
       <code class="literal">
        Innodb_buffer_pool_reads
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262925888">
     </a>
     <a class="indexterm" name="idm46045262924784">
     </a>
     <p>
      The number of logical reads that
      <code class="literal">
       InnoDB
      </code>
      could not satisfy from the
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      , and had
          to read directly from disk.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_resize_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_resize_status">
       <code class="literal">
        Innodb_buffer_pool_resize_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262918592">
     </a>
     <a class="indexterm" name="idm46045262917552">
     </a>
     <p>
      The status of an operation to resize the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      dynamically, triggered by setting the
      <a class="link" href="innodb-parameters.html#sysvar_innodb_buffer_pool_size">
       <code class="literal">
        innodb_buffer_pool_size
       </code>
      </a>
      parameter dynamically. The
      <a class="link" href="innodb-parameters.html#sysvar_innodb_buffer_pool_size">
       <code class="literal">
        innodb_buffer_pool_size
       </code>
      </a>
      parameter is dynamic, which allows you to resize the buffer
          pool without restarting the server. See
      <a class="xref" href="innodb-buffer-pool-resize.html#innodb-buffer-pool-online-resize" title="Configuring InnoDB Buffer Pool Size Online">
       Configuring InnoDB Buffer Pool Size Online
      </a>
      for related
          information.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_resize_status_code">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_resize_status_code">
       <code class="literal">
        Innodb_buffer_pool_resize_status_code
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262907824">
     </a>
     <a class="indexterm" name="idm46045262906784">
     </a>
     <p>
      Reports status codes for tracking online buffer pool resizing
          operations. Each status code represents a stage in a resizing
          operation. Status codes include:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         0: No Resize operation in progress
        </p>
       </li>
       <li class="listitem">
        <p>
         1: Starting Resize
        </p>
       </li>
       <li class="listitem">
        <p>
         2: Disabling AHI (Adaptive Hash Index)
        </p>
       </li>
       <li class="listitem">
        <p>
         3: Withdrawing Blocks
        </p>
       </li>
       <li class="listitem">
        <p>
         4: Acquiring Global Lock
        </p>
       </li>
       <li class="listitem">
        <p>
         5: Resizing Pool
        </p>
       </li>
       <li class="listitem">
        <p>
         6: Resizing Hash
        </p>
       </li>
       <li class="listitem">
        <p>
         7: Resizing Failed
        </p>
       </li>
      </ul>
     </div>
     <p>
      You can use this status variable in conjunction with
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_resize_status_progress">
       <code class="literal">
        Innodb_buffer_pool_resize_status_progress
       </code>
      </a>
      to track the progress of each stage of a resizing operation.
          The
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_resize_status_progress">
       <code class="literal">
        Innodb_buffer_pool_resize_status_progress
       </code>
      </a>
      variable reports a percentage value indicating the progress of
          the current stage.
     </p>
     <p>
      For more information, see
      <a class="xref" href="innodb-buffer-pool-resize.html#innodb-buffer-pool-online-resize-monitoring" title="Monitoring Online Buffer Pool Resizing Progress">
       Monitoring Online Buffer Pool Resizing Progress
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_resize_status_progress">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_resize_status_progress">
       <code class="literal">
        Innodb_buffer_pool_resize_status_progress
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262890448">
     </a>
     <a class="indexterm" name="idm46045262889344">
     </a>
     <p>
      Reports a percentage value indicating the progress of the
          current stage of an online buffer pool resizing operation.
          This variable is used in conjunction with
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_resize_status_code">
       <code class="literal">
        Innodb_buffer_pool_resize_status_code
       </code>
      </a>
      ,
          which reports a status code indicating the current stage of an
          online buffer pool resizing operation.
     </p>
     <p>
      The percentage value is updated after each buffer pool
          instance is processed. As the status code (reported by
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_resize_status_code">
       <code class="literal">
        Innodb_buffer_pool_resize_status_code
       </code>
      </a>
      )
          changes from one status to another, the percentage value is
          reset to 0.
     </p>
     <p>
      For related information, see
      <a class="xref" href="innodb-buffer-pool-resize.html#innodb-buffer-pool-online-resize-monitoring" title="Monitoring Online Buffer Pool Resizing Progress">
       Monitoring Online Buffer Pool Resizing Progress
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_wait_free">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_wait_free">
       <code class="literal">
        Innodb_buffer_pool_wait_free
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262880256">
     </a>
     <a class="indexterm" name="idm46045262879152">
     </a>
     <p>
      Normally, writes to the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      happen in
          the background. When
      <code class="literal">
       InnoDB
      </code>
      needs to read
          or create a
      <a class="link" href="glossary.html#glos_page" title="page">
       page
      </a>
      and no clean
          pages are available,
      <code class="literal">
       InnoDB
      </code>
      flushes some
      <a class="link" href="glossary.html#glos_dirty_page" title="dirty page">
       dirty pages
      </a>
      first and
          waits for that operation to finish. This counter counts
          instances of these waits. If
      <a class="link" href="innodb-parameters.html#sysvar_innodb_buffer_pool_size">
       <code class="literal">
        innodb_buffer_pool_size
       </code>
      </a>
      has
          been set properly, this value should be small.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_buffer_pool_write_requests">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_buffer_pool_write_requests">
       <code class="literal">
        Innodb_buffer_pool_write_requests
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262868464">
     </a>
     <a class="indexterm" name="idm46045262867424">
     </a>
     <p>
      The number of writes done to the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_buffer_pool" title="buffer pool">
       buffer pool
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_data_fsyncs">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_data_fsyncs">
       <code class="literal">
        Innodb_data_fsyncs
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262861504">
     </a>
     <a class="indexterm" name="idm46045262860464">
     </a>
     <p>
      The number of
      <code class="literal">
       fsync()
      </code>
      operations so far.
          The frequency of
      <code class="literal">
       fsync()
      </code>
      calls is
          influenced by the setting of the
      <a class="link" href="innodb-parameters.html#sysvar_innodb_flush_method">
       <code class="literal">
        innodb_flush_method
       </code>
      </a>
      configuration option.
     </p>
     <p>
      Counts the number of
      <code class="literal">
       fdatasync()
      </code>
      operations
          if
      <a class="link" href="innodb-parameters.html#sysvar_innodb_use_fdatasync">
       <code class="literal">
        innodb_use_fdatasync
       </code>
      </a>
      is
          enabled.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_data_pending_fsyncs">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_data_pending_fsyncs">
       <code class="literal">
        Innodb_data_pending_fsyncs
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262850800">
     </a>
     <a class="indexterm" name="idm46045262849696">
     </a>
     <p>
      The current number of pending
      <code class="literal">
       fsync()
      </code>
      operations. The frequency of
      <code class="literal">
       fsync()
      </code>
      calls
          is influenced by the setting of the
      <a class="link" href="innodb-parameters.html#sysvar_innodb_flush_method">
       <code class="literal">
        innodb_flush_method
       </code>
      </a>
      configuration option.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_data_pending_reads">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_data_pending_reads">
       <code class="literal">
        Innodb_data_pending_reads
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262842448">
     </a>
     <a class="indexterm" name="idm46045262841344">
     </a>
     <p>
      The current number of pending reads.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_data_pending_writes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_data_pending_writes">
       <code class="literal">
        Innodb_data_pending_writes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262836896">
     </a>
     <a class="indexterm" name="idm46045262835792">
     </a>
     <p>
      The current number of pending writes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_data_read">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_data_read">
       <code class="literal">
        Innodb_data_read
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262831312">
     </a>
     <a class="indexterm" name="idm46045262830272">
     </a>
     <p>
      The amount of data read since the server was started (in
          bytes).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_data_reads">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_data_reads">
       <code class="literal">
        Innodb_data_reads
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262825776">
     </a>
     <a class="indexterm" name="idm46045262824736">
     </a>
     <p>
      The total number of data reads (OS file reads).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_data_writes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_data_writes">
       <code class="literal">
        Innodb_data_writes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262820336">
     </a>
     <a class="indexterm" name="idm46045262819296">
     </a>
     <p>
      The total number of data writes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_data_written">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_data_written">
       <code class="literal">
        Innodb_data_written
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262814912">
     </a>
     <a class="indexterm" name="idm46045262813872">
     </a>
     <p>
      The amount of data written so far, in bytes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_dblwr_pages_written">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_dblwr_pages_written">
       <code class="literal">
        Innodb_dblwr_pages_written
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262809440">
     </a>
     <a class="indexterm" name="idm46045262808336">
     </a>
     <a class="indexterm" name="idm46045262806832">
     </a>
     <p>
      The number of
      <a class="link" href="glossary.html#glos_page" title="page">
       pages
      </a>
      that have
          been written to the
      <a class="link" href="glossary.html#glos_doublewrite_buffer" title="doublewrite buffer">
       doublewrite
          buffer
      </a>
      . See
      <a class="xref" href="innodb-disk-io.html" title="17.11.1 InnoDB Disk I/O">
       Section 17.11.1, “InnoDB Disk I/O”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_dblwr_writes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_dblwr_writes">
       <code class="literal">
        Innodb_dblwr_writes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262800080">
     </a>
     <a class="indexterm" name="idm46045262799040">
     </a>
     <p>
      The number of doublewrite operations that have been performed.
          See
      <a class="xref" href="innodb-disk-io.html" title="17.11.1 InnoDB Disk I/O">
       Section 17.11.1, “InnoDB Disk I/O”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_have_atomic_builtins">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_have_atomic_builtins">
       <code class="literal">
        Innodb_have_atomic_builtins
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262793904">
     </a>
     <a class="indexterm" name="idm46045262792800">
     </a>
     <p>
      Indicates whether the server was built with
      <a class="link" href="glossary.html#glos_atomic_instruction" title="atomic instruction">
       atomic
          instructions
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_log_waits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_log_waits">
       <code class="literal">
        Innodb_log_waits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262787296">
     </a>
     <a class="indexterm" name="idm46045262786256">
     </a>
     <p>
      The number of times that the
      <a class="link" href="glossary.html#glos_log_buffer" title="log buffer">
       log buffer
      </a>
      was too
          small and a
      <a class="link" href="glossary.html#glos_wait" title="wait">
       wait
      </a>
      was required
          for it to be
      <a class="link" href="glossary.html#glos_flush" title="flush">
       flushed
      </a>
      before
          continuing.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_log_write_requests">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_log_write_requests">
       <code class="literal">
        Innodb_log_write_requests
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262778944">
     </a>
     <a class="indexterm" name="idm46045262777840">
     </a>
     <p>
      The number of write requests for the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_redo_log" title="redo log">
       redo log
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_log_writes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_log_writes">
       <code class="literal">
        Innodb_log_writes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262771680">
     </a>
     <a class="indexterm" name="idm46045262770640">
     </a>
     <p>
      The number of physical writes to the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_redo_log" title="redo log">
       redo log
      </a>
      file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_num_open_files">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_num_open_files">
       <code class="literal">
        Innodb_num_open_files
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262764672">
     </a>
     <a class="indexterm" name="idm46045262763632">
     </a>
     <p>
      The number of files
      <code class="literal">
       InnoDB
      </code>
      currently holds
          open.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_os_log_fsyncs">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_os_log_fsyncs">
       <code class="literal">
        Innodb_os_log_fsyncs
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262758448">
     </a>
     <a class="indexterm" name="idm46045262757408">
     </a>
     <p>
      The number of
      <code class="literal">
       fsync()
      </code>
      writes done to the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_redo_log" title="redo log">
       redo
          log
      </a>
      files.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_os_log_pending_fsyncs">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_os_log_pending_fsyncs">
       <code class="literal">
        Innodb_os_log_pending_fsyncs
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262750816">
     </a>
     <a class="indexterm" name="idm46045262749712">
     </a>
     <p>
      The number of pending
      <code class="literal">
       fsync()
      </code>
      operations
          for the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_redo_log" title="redo log">
       redo log
      </a>
      files.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_os_log_pending_writes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_os_log_pending_writes">
       <code class="literal">
        Innodb_os_log_pending_writes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262743040">
     </a>
     <a class="indexterm" name="idm46045262741936">
     </a>
     <p>
      The number of pending writes to the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_redo_log" title="redo log">
       redo log
      </a>
      files.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_os_log_written">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_os_log_written">
       <code class="literal">
        Innodb_os_log_written
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262735952">
     </a>
     <a class="indexterm" name="idm46045262734912">
     </a>
     <p>
      The number of bytes written to the
      <code class="literal">
       InnoDB
      </code>
      <a class="link" href="glossary.html#glos_redo_log" title="redo log">
       redo log
      </a>
      files.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_page_size">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_page_size">
       <code class="literal">
        Innodb_page_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262728944">
     </a>
     <a class="indexterm" name="idm46045262727904">
     </a>
     <p>
      <code class="literal">
       InnoDB
      </code>
      page size (default 16KB). Many
          values are counted in pages; the page size enables them to be
          easily converted to bytes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_pages_created">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_pages_created">
       <code class="literal">
        Innodb_pages_created
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262722672">
     </a>
     <a class="indexterm" name="idm46045262721632">
     </a>
     <p>
      The number of pages created by operations on
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_pages_read">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_pages_read">
       <code class="literal">
        Innodb_pages_read
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262716448">
     </a>
     <a class="indexterm" name="idm46045262715408">
     </a>
     <p>
      The number of pages read from the
      <code class="literal">
       InnoDB
      </code>
      buffer pool by operations on
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_pages_written">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_pages_written">
       <code class="literal">
        Innodb_pages_written
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262709488">
     </a>
     <a class="indexterm" name="idm46045262708448">
     </a>
     <p>
      The number of pages written by operations on
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_enabled">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_enabled">
       <code class="literal">
        Innodb_redo_log_enabled
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262703264">
     </a>
     <a class="indexterm" name="idm46045262702224">
     </a>
     <p>
      Whether redo logging is enabled or disabled. See
      <a class="xref" href="innodb-redo-log.html#innodb-disable-redo-logging" title="Disabling Redo Logging">
       Disabling Redo Logging
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_capacity_resized">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_capacity_resized">
       <code class="literal">
        Innodb_redo_log_capacity_resized
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262696848">
     </a>
     <a class="indexterm" name="idm46045262695808">
     </a>
     <p>
      The total redo log capacity for all redo log files, in bytes,
          after the last completed capacity resize operation. The value
          includes ordinary and spare redo log files.
     </p>
     <p>
      If there is no pending resize down operation,
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_capacity_resized">
       <code class="literal">
        Innodb_redo_log_capacity_resized
       </code>
      </a>
      should be equal to the
      <a class="link" href="innodb-parameters.html#sysvar_innodb_redo_log_capacity">
       <code class="literal">
        innodb_redo_log_capacity
       </code>
      </a>
      setting if it's used, or it's
          (
      <span class="emphasis">
       <em>
        (innodb_log_files_in_group *
          innodb_log_file_size)
       </em>
      </span>
      ) if those are used instead.
          See the
      <a class="link" href="innodb-parameters.html#sysvar_innodb_redo_log_capacity">
       <code class="literal">
        innodb_redo_log_capacity
       </code>
      </a>
      documentation for further clarification. Resize up operations
          are instantaneous.
     </p>
     <p>
      For related information, see
      <a class="xref" href="innodb-redo-log.html" title="17.6.5 Redo Log">
       Section 17.6.5, “Redo Log”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_checkpoint_lsn">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_checkpoint_lsn">
       <code class="literal">
        Innodb_redo_log_checkpoint_lsn
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262684880">
     </a>
     <a class="indexterm" name="idm46045262683776">
     </a>
     <p>
      The redo log checkpoint LSN. For related information, see
      <a class="xref" href="innodb-redo-log.html" title="17.6.5 Redo Log">
       Section 17.6.5, “Redo Log”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_current_lsn">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_current_lsn">
       <code class="literal">
        Innodb_redo_log_current_lsn
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262678704">
     </a>
     <a class="indexterm" name="idm46045262677600">
     </a>
     <p>
      The current LSN represents the last written position in the
          redo log buffer.
      <code class="literal">
       InnoDB
      </code>
      writes data to the
          redo log buffer inside the MySQL process before requesting
          that the operating system write the data to the current redo
          log file. For related information, see
      <a class="xref" href="innodb-redo-log.html" title="17.6.5 Redo Log">
       Section 17.6.5, “Redo Log”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_flushed_to_disk_lsn">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_flushed_to_disk_lsn">
       <code class="literal">
        Innodb_redo_log_flushed_to_disk_lsn
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262671456">
     </a>
     <a class="indexterm" name="idm46045262670416">
     </a>
     <p>
      The flushed-to-disk LSN.
      <code class="literal">
       InnoDB
      </code>
      first
          writes data to the redo log and then requests that the
          operating system flush the data to disk. The flushed-to-disk
          LSN represents the last position in the redo log that
      <code class="literal">
       InnoDB
      </code>
      knows has been flushed to disk. For
          related information, see
      <a class="xref" href="innodb-redo-log.html" title="17.6.5 Redo Log">
       Section 17.6.5, “Redo Log”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_logical_size">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_logical_size">
       <code class="literal">
        Innodb_redo_log_logical_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262663616">
     </a>
     <a class="indexterm" name="idm46045262662512">
     </a>
     <p>
      A data size value, in bytes, representing the LSN range
          containing in-use redo log data, spanning from the oldest
          block required by redo log consumers to the latest written
          block. For related information, see
      <a class="xref" href="innodb-redo-log.html" title="17.6.5 Redo Log">
       Section 17.6.5, “Redo Log”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_physical_size">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_physical_size">
       <code class="literal">
        Innodb_redo_log_physical_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262657200">
     </a>
     <a class="indexterm" name="idm46045262656096">
     </a>
     <p>
      The amount of disk space in bytes currently consumed by all
          redo log files on disk, excluding spare redo log files. For
          related information, see
      <a class="xref" href="innodb-redo-log.html" title="17.6.5 Redo Log">
       Section 17.6.5, “Redo Log”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_read_only">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_read_only">
       <code class="literal">
        Innodb_redo_log_read_only
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262650864">
     </a>
     <a class="indexterm" name="idm46045262649760">
     </a>
     <p>
      Whether the redo log is read-only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_resize_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_resize_status">
       <code class="literal">
        Innodb_redo_log_resize_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262645328">
     </a>
     <a class="indexterm" name="idm46045262644224">
     </a>
     <p>
      The redo log resize status indicating the current state of the
          redo log capacity resize mechanism. Possible values include:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          OK
         </code>
         : There are no issues and no pending
              redo log capacity resize operations.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          Resizing down
         </code>
         : A resize down operation
              is in progress.
        </p>
       </li>
      </ul>
     </div>
     <p>
      A resize up operation is instantaneous and therefore has no
          pending status.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_redo_log_uuid">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_redo_log_uuid">
       <code class="literal">
        Innodb_redo_log_uuid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262635744">
     </a>
     <a class="indexterm" name="idm46045262634704">
     </a>
     <p>
      The redo log UUID.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_row_lock_current_waits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_row_lock_current_waits">
       <code class="literal">
        Innodb_row_lock_current_waits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262630304">
     </a>
     <a class="indexterm" name="idm46045262629200">
     </a>
     <p>
      The number of
      <a class="link" href="glossary.html#glos_row_lock" title="row lock">
       row locks
      </a>
      currently waited for by operations on
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_row_lock_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_row_lock_time">
       <code class="literal">
        Innodb_row_lock_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262623152">
     </a>
     <a class="indexterm" name="idm46045262622112">
     </a>
     <p>
      The total time spent in acquiring
      <a class="link" href="glossary.html#glos_row_lock" title="row lock">
       row locks
      </a>
      for
      <code class="literal">
       InnoDB
      </code>
      tables, in milliseconds.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_row_lock_time_avg">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_row_lock_time_avg">
       <code class="literal">
        Innodb_row_lock_time_avg
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262616128">
     </a>
     <a class="indexterm" name="idm46045262615024">
     </a>
     <p>
      The average time to acquire a
      <a class="link" href="glossary.html#glos_row_lock" title="row lock">
       row lock
      </a>
      for
      <code class="literal">
       InnoDB
      </code>
      tables, in milliseconds.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_row_lock_time_max">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_row_lock_time_max">
       <code class="literal">
        Innodb_row_lock_time_max
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262609024">
     </a>
     <a class="indexterm" name="idm46045262607920">
     </a>
     <p>
      The maximum time to acquire a
      <a class="link" href="glossary.html#glos_row_lock" title="row lock">
       row lock
      </a>
      for
      <code class="literal">
       InnoDB
      </code>
      tables, in milliseconds.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_row_lock_waits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_row_lock_waits">
       <code class="literal">
        Innodb_row_lock_waits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262601952">
     </a>
     <a class="indexterm" name="idm46045262600912">
     </a>
     <p>
      The number of times operations on
      <code class="literal">
       InnoDB
      </code>
      tables had to wait for a
      <a class="link" href="glossary.html#glos_row_lock" title="row lock">
       row
          lock
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_rows_deleted">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_rows_deleted">
       <code class="literal">
        Innodb_rows_deleted
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262594896">
     </a>
     <a class="indexterm" name="idm46045262593856">
     </a>
     <p>
      The number of rows deleted from
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_rows_inserted">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_rows_inserted">
       <code class="literal">
        Innodb_rows_inserted
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262588672">
     </a>
     <a class="indexterm" name="idm46045262587632">
     </a>
     <p>
      The number of rows inserted into
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_rows_read">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_rows_read">
       <code class="literal">
        Innodb_rows_read
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262582448">
     </a>
     <a class="indexterm" name="idm46045262581408">
     </a>
     <p>
      The number of rows read from
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_rows_updated">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_rows_updated">
       <code class="literal">
        Innodb_rows_updated
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262576240">
     </a>
     <a class="indexterm" name="idm46045262575200">
     </a>
     <p>
      The estimated number of rows updated in
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
     <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
      <div class="admon-title">
       Note
      </div>
      <p>
       This value is not meant to be 100% accurate. For an accurate
            (but more expensive) result, use
       <a class="link" href="information-functions.html#function_row-count">
        <code class="literal">
         ROW_COUNT()
        </code>
       </a>
       .
      </p>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_system_rows_deleted">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_system_rows_deleted">
       <code class="literal">
        Innodb_system_rows_deleted
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262567792">
     </a>
     <a class="indexterm" name="idm46045262566688">
     </a>
     <p>
      The number of rows deleted from
      <code class="literal">
       InnoDB
      </code>
      tables belonging to system-created schemas.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_system_rows_inserted">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_system_rows_inserted">
       <code class="literal">
        Innodb_system_rows_inserted
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262561552">
     </a>
     <a class="indexterm" name="idm46045262560448">
     </a>
     <p>
      The number of rows inserted into
      <code class="literal">
       InnoDB
      </code>
      tables belonging to system-created schemas.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_system_rows_updated">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_system_rows_updated">
       <code class="literal">
        Innodb_system_rows_updated
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262555248">
     </a>
     <a class="indexterm" name="idm46045262554144">
     </a>
     <p>
      The number of rows updated in
      <code class="literal">
       InnoDB
      </code>
      tables
          belonging to system-created schemas.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_system_rows_read">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_system_rows_read">
       <code class="literal">
        Innodb_system_rows_read
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262548976">
     </a>
     <a class="indexterm" name="idm46045262547936">
     </a>
     <p>
      The number of rows read from
      <code class="literal">
       InnoDB
      </code>
      tables
          belonging to system-created schemas.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_truncated_status_writes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_truncated_status_writes">
       <code class="literal">
        Innodb_truncated_status_writes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262542752">
     </a>
     <a class="indexterm" name="idm46045262541648">
     </a>
     <p>
      The number of times output from the
      <code class="literal">
       SHOW ENGINE
          INNODB STATUS
      </code>
      statement has been truncated.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_undo_tablespaces_active">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_undo_tablespaces_active">
       <code class="literal">
        Innodb_undo_tablespaces_active
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262536464">
     </a>
     <a class="indexterm" name="idm46045262535360">
     </a>
     <p>
      The number of active undo tablespaces. Includes both implicit
          (
      <code class="literal">
       InnoDB
      </code>
      -created) and explicit
          (user-created) undo tablespaces. For information about undo
          tablespaces, see
      <a class="xref" href="innodb-undo-tablespaces.html" title="17.6.3.4 Undo Tablespaces">
       Section 17.6.3.4, “Undo Tablespaces”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_undo_tablespaces_explicit">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_undo_tablespaces_explicit">
       <code class="literal">
        Innodb_undo_tablespaces_explicit
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262529152">
     </a>
     <a class="indexterm" name="idm46045262528112">
     </a>
     <p>
      The number of user-created undo tablespaces. For information
          about undo tablespaces, see
      <a class="xref" href="innodb-undo-tablespaces.html" title="17.6.3.4 Undo Tablespaces">
       Section 17.6.3.4, “Undo Tablespaces”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_undo_tablespaces_implicit">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_undo_tablespaces_implicit">
       <code class="literal">
        Innodb_undo_tablespaces_implicit
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262522800">
     </a>
     <a class="indexterm" name="idm46045262521760">
     </a>
     <p>
      The number of undo tablespaces created by
      <code class="literal">
       InnoDB
      </code>
      . Two default undo tablespaces are
          created by
      <code class="literal">
       InnoDB
      </code>
      when the MySQL instance
          is initialized. For information about undo tablespaces, see
      <a class="xref" href="innodb-undo-tablespaces.html" title="17.6.3.4 Undo Tablespaces">
       Section 17.6.3.4, “Undo Tablespaces”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Innodb_undo_tablespaces_total">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Innodb_undo_tablespaces_total">
       <code class="literal">
        Innodb_undo_tablespaces_total
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262515120">
     </a>
     <a class="indexterm" name="idm46045262514016">
     </a>
     <p>
      The total number of undo tablespaces. Includes both implicit
          (
      <code class="literal">
       InnoDB
      </code>
      -created) and explicit
          (user-created) undo tablespaces, active and inactive. For
          information about undo tablespaces, see
      <a class="xref" href="innodb-undo-tablespaces.html" title="17.6.3.4 Undo Tablespaces">
       Section 17.6.3.4, “Undo Tablespaces”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Key_blocks_not_flushed">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Key_blocks_not_flushed">
       <code class="literal">
        Key_blocks_not_flushed
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262508064">
     </a>
     <a class="indexterm" name="idm46045262507024">
     </a>
     <p>
      The number of key blocks in the
      <code class="literal">
       MyISAM
      </code>
      key
          cache that have changed but have not yet been flushed to disk.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Key_blocks_unused">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Key_blocks_unused">
       <code class="literal">
        Key_blocks_unused
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262501792">
     </a>
     <a class="indexterm" name="idm46045262500752">
     </a>
     <p>
      The number of unused blocks in the
      <code class="literal">
       MyISAM
      </code>
      key cache. You can use this value to determine how much of the
          key cache is in use; see the discussion of
      <a class="link" href="server-system-variables.html#sysvar_key_buffer_size">
       <code class="literal">
        key_buffer_size
       </code>
      </a>
      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>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Key_blocks_used">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Key_blocks_used">
       <code class="literal">
        Key_blocks_used
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262493664">
     </a>
     <a class="indexterm" name="idm46045262492576">
     </a>
     <p>
      The number of used blocks in the
      <code class="literal">
       MyISAM
      </code>
      key
          cache. This value is a high-water mark that indicates the
          maximum number of blocks that have ever been in use at one
          time.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Key_read_requests">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Key_read_requests">
       <code class="literal">
        Key_read_requests
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262487264">
     </a>
     <a class="indexterm" name="idm46045262486224">
     </a>
     <p>
      The number of requests to read a key block from the
      <code class="literal">
       MyISAM
      </code>
      key cache.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Key_reads">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Key_reads">
       <code class="literal">
        Key_reads
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262481200">
     </a>
     <a class="indexterm" name="idm46045262480112">
     </a>
     <p>
      The number of physical reads of a key block from disk into the
      <code class="literal">
       MyISAM
      </code>
      key cache. If
      <a class="link" href="server-status-variables.html#statvar_Key_reads">
       <code class="literal">
        Key_reads
       </code>
      </a>
      is large, then
          your
      <a class="link" href="server-system-variables.html#sysvar_key_buffer_size">
       <code class="literal">
        key_buffer_size
       </code>
      </a>
      value is
          probably too small. The cache miss rate can be calculated as
      <a class="link" href="server-status-variables.html#statvar_Key_reads">
       <code class="literal">
        Key_reads
       </code>
      </a>
      /
      <a class="link" href="server-status-variables.html#statvar_Key_read_requests">
       <code class="literal">
        Key_read_requests
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Key_write_requests">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Key_write_requests">
       <code class="literal">
        Key_write_requests
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262469936">
     </a>
     <a class="indexterm" name="idm46045262468896">
     </a>
     <p>
      The number of requests to write a key block to the
      <code class="literal">
       MyISAM
      </code>
      key cache.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Key_writes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Key_writes">
       <code class="literal">
        Key_writes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262463808">
     </a>
     <a class="indexterm" name="idm46045262462720">
     </a>
     <p>
      The number of physical writes of a key block from the
      <code class="literal">
       MyISAM
      </code>
      key cache to disk.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Last_query_cost">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Last_query_cost">
       <code class="literal">
        Last_query_cost
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262457680">
     </a>
     <a class="indexterm" name="idm46045262456592">
     </a>
     <p>
      The total cost of the last compiled query as computed by the
          query optimizer. This is useful for comparing the cost of
          different query plans for the same query. The default value of
          0 means that no query has been compiled yet. The default value
          is 0.
      <a class="link" href="server-status-variables.html#statvar_Last_query_cost">
       <code class="literal">
        Last_query_cost
       </code>
      </a>
      has
          session scope.
     </p>
     <p>
      This variable shows the cost of queries that have multiple
          query blocks, summing the cost estimates of each query block,
          estimating how many times non-cacheable subqueries are
          executed, and multiplying the cost of those query blocks by
          the number of subquery executions.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Last_query_partial_plans">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Last_query_partial_plans">
       <code class="literal">
        Last_query_partial_plans
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262450000">
     </a>
     <a class="indexterm" name="idm46045262448896">
     </a>
     <p>
      The number of iterations the query optimizer made in execution
          plan construction for the previous query.
     </p>
     <p>
      <code class="literal">
       Last_query_partial_plans
      </code>
      has session scope.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Locked_connects">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Locked_connects">
       <code class="literal">
        Locked_connects
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262443328">
     </a>
     <a class="indexterm" name="idm46045262442240">
     </a>
     <a class="indexterm" name="idm46045262440752">
     </a>
     <p>
      The number of attempts to connect to locked user accounts. For
          information about account locking and unlocking, see
      <a class="xref" href="account-locking.html" title="8.2.20 Account Locking">
       Section 8.2.20, “Account Locking”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Max_execution_time_exceeded">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Max_execution_time_exceeded">
       <code class="literal">
        Max_execution_time_exceeded
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262435376">
     </a>
     <a class="indexterm" name="idm46045262434272">
     </a>
     <p>
      The number of
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statements
          for which the execution timeout was exceeded.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Max_execution_time_set">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Max_execution_time_set">
       <code class="literal">
        Max_execution_time_set
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262428528">
     </a>
     <a class="indexterm" name="idm46045262427488">
     </a>
     <p>
      The number of
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statements
          for which a nonzero execution timeout was set. This includes
          statements that include a nonzero
      <a class="link" href="optimizer-hints.html#optimizer-hints-execution-time" title="Statement Execution Time Optimizer Hints">
       <code class="literal">
        MAX_EXECUTION_TIME
       </code>
      </a>
      optimizer
          hint, and statements that include no such hint but execute
          while the timeout indicated by the
      <a class="link" href="server-system-variables.html#sysvar_max_execution_time">
       <code class="literal">
        max_execution_time
       </code>
      </a>
      system
          variable is nonzero.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Max_execution_time_set_failed">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Max_execution_time_set_failed">
       <code class="literal">
        Max_execution_time_set_failed
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262419056">
     </a>
     <a class="indexterm" name="idm46045262417952">
     </a>
     <p>
      The number of
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
      statements
          for which the attempt to set an execution timeout failed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Max_used_connections">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Max_used_connections">
       <code class="literal">
        Max_used_connections
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262412192">
     </a>
     <a class="indexterm" name="idm46045262411152">
     </a>
     <p>
      The maximum number of connections that have been in use
          simultaneously since the server started.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Max_used_connections_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Max_used_connections_time">
       <code class="literal">
        Max_used_connections_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262406720">
     </a>
     <a class="indexterm" name="idm46045262405616">
     </a>
     <p>
      The time at which
      <a class="link" href="server-status-variables.html#statvar_Max_used_connections">
       <code class="literal">
        Max_used_connections
       </code>
      </a>
      reached
          its current value.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Not_flushed_delayed_rows">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Not_flushed_delayed_rows">
       <code class="literal">
        Not_flushed_delayed_rows
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262399904">
     </a>
     <a class="indexterm" name="idm46045262398800">
     </a>
     <p>
      This status variable is deprecated (because
      <code class="literal">
       DELAYED
      </code>
      inserts are not supported); expect
          it to be removed in a future release.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_mecab_charset">
      </a>
      <a class="link" href="server-status-variables.html#statvar_mecab_charset">
       <code class="literal">
        mecab_charset
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262393632">
     </a>
     <a class="indexterm" name="idm46045262392544">
     </a>
     <p>
      The character set currently used by the MeCab full-text parser
          plugin. For related information, see
      <a class="xref" href="fulltext-search-mecab.html" title="14.9.9 MeCab Full-Text Parser Plugin">
       Section 14.9.9, “MeCab Full-Text Parser Plugin”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ongoing_anonymous_transaction_count">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ongoing_anonymous_transaction_count">
       <code class="literal">
        Ongoing_anonymous_transaction_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262387312">
     </a>
     <a class="indexterm" name="idm46045262386272">
     </a>
     <p>
      Shows the number of ongoing transactions which have been
          marked as anonymous. This can be used to ensure that no
          further transactions are waiting to be processed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ongoing_anonymous_gtid_violating_transaction_count">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ongoing_anonymous_gtid_violating_transaction_count">
       <code class="literal">
        Ongoing_anonymous_gtid_violating_transaction_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262381520">
     </a>
     <a class="indexterm" name="idm46045262380480">
     </a>
     <p>
      This status variable is only available in debug builds. Shows
          the number of ongoing transactions which use
      <a class="link" href="replication-options-gtids.html#sysvar_gtid_next">
       <code class="literal">
        gtid_next=ANONYMOUS
       </code>
      </a>
      and that
          violate GTID consistency.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ongoing_automatic_gtid_violating_transaction_count">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ongoing_automatic_gtid_violating_transaction_count">
       <code class="literal">
        Ongoing_automatic_gtid_violating_transaction_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262374512">
     </a>
     <a class="indexterm" name="idm46045262373472">
     </a>
     <p>
      This status variable is only available in debug builds. Shows
          the number of ongoing transactions which use
      <a class="link" href="replication-options-gtids.html#sysvar_gtid_next">
       <code class="literal">
        gtid_next=AUTOMATIC
       </code>
      </a>
      and that
          violate GTID consistency.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Open_files">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Open_files">
       <code class="literal">
        Open_files
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262367744">
     </a>
     <a class="indexterm" name="idm46045262366656">
     </a>
     <p>
      The number of files that are open. This count includes regular
          files opened by the server. It does not include other types of
          files such as sockets or pipes. Also, the count does not
          include files that storage engines open using their own
          internal functions rather than asking the server level to do
          so.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Open_streams">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Open_streams">
       <code class="literal">
        Open_streams
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262362000">
     </a>
     <a class="indexterm" name="idm46045262360912">
     </a>
     <p>
      The number of streams that are open (used mainly for logging).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Open_table_definitions">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Open_table_definitions">
       <code class="literal">
        Open_table_definitions
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262356432">
     </a>
     <a class="indexterm" name="idm46045262355392">
     </a>
     <p>
      The number of cached table definitions.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Open_tables">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Open_tables">
       <code class="literal">
        Open_tables
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262351040">
     </a>
     <a class="indexterm" name="idm46045262349952">
     </a>
     <p>
      The number of tables that are open.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Opened_files">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Opened_files">
       <code class="literal">
        Opened_files
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262345616">
     </a>
     <a class="indexterm" name="idm46045262344528">
     </a>
     <p>
      The number of files that have been opened with
      <code class="function">
       my_open()
      </code>
      (a
      <code class="literal">
       mysys
      </code>
      library function). Parts of the server that open files without
          using this function do not increment the count.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Opened_table_definitions">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Opened_table_definitions">
       <code class="literal">
        Opened_table_definitions
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262338528">
     </a>
     <a class="indexterm" name="idm46045262337424">
     </a>
     <p>
      The number of table definitions that have been cached.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Opened_tables">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Opened_tables">
       <code class="literal">
        Opened_tables
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262333040">
     </a>
     <a class="indexterm" name="idm46045262331952">
     </a>
     <p>
      The number of tables that have been opened. If
      <a class="link" href="server-status-variables.html#statvar_Opened_tables">
       <code class="literal">
        Opened_tables
       </code>
      </a>
      is big, your
      <a class="link" href="server-system-variables.html#sysvar_table_open_cache">
       <code class="literal">
        table_open_cache
       </code>
      </a>
      value is
          probably too small.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       Performance_schema_
       <em class="replaceable">
        <code>
         xxx
        </code>
       </em>
      </code>
     </p>
     <p>
      Performance Schema status variables are listed in
      <a class="xref" href="performance-schema-status-variables.html" title="29.16 Performance Schema Status Variables">
       Section 29.16, “Performance Schema Status Variables”
      </a>
      . These
          variables provide information about instrumentation that could
          not be loaded or created due to memory constraints.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Prepared_stmt_count">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Prepared_stmt_count">
       <code class="literal">
        Prepared_stmt_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262321968">
     </a>
     <a class="indexterm" name="idm46045262320928">
     </a>
     <p>
      The current number of prepared statements. (The maximum number
          of statements is given by 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="statvar_Queries">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Queries">
       <code class="literal">
        Queries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262315232">
     </a>
     <a class="indexterm" name="idm46045262314160">
     </a>
     <p>
      The number of statements executed by the server. This variable
          includes statements executed within stored programs, unlike
          the
      <a class="link" href="server-status-variables.html#statvar_Questions">
       <code class="literal">
        Questions
       </code>
      </a>
      variable. It
          does not count
      <code class="literal">
       COM_PING
      </code>
      or
      <code class="literal">
       COM_STATISTICS
      </code>
      commands.
     </p>
     <p>
      The discussion at the beginning of this section indicates how
          to relate this statement-counting status variable to other
          such variables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Questions">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Questions">
       <code class="literal">
        Questions
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262306448">
     </a>
     <a class="indexterm" name="idm46045262305360">
     </a>
     <p>
      The number of statements executed by the server. This includes
          only statements sent to the server by clients and not
          statements executed within stored programs, unlike the
      <a class="link" href="server-status-variables.html#statvar_Queries">
       <code class="literal">
        Queries
       </code>
      </a>
      variable. This
          variable does not count
      <code class="literal">
       COM_PING
      </code>
      ,
      <code class="literal">
       COM_STATISTICS
      </code>
      ,
      <code class="literal">
       COM_STMT_PREPARE
      </code>
      ,
      <code class="literal">
       COM_STMT_CLOSE
      </code>
      , or
      <code class="literal">
       COM_STMT_RESET
      </code>
      commands.
     </p>
     <p>
      The discussion at the beginning of this section indicates how
          to relate this statement-counting status variable to other
          such variables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Replica_open_temp_tables">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Replica_open_temp_tables">
       <code class="literal">
        Replica_open_temp_tables
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262295344">
     </a>
     <a class="indexterm" name="idm46045262294240">
     </a>
     <p>
      <a class="link" href="server-status-variables.html#statvar_Replica_open_temp_tables">
       <code class="literal">
        Replica_open_temp_tables
       </code>
      </a>
      shows the number of temporary tables that the replication SQL
          thread currently has open. If the value is greater than zero,
          it is not safe to shut down the replica; see
      <a class="xref" href="replication-features-temptables.html" title="19.5.1.31 Replication and Temporary Tables">
       Section 19.5.1.31, “Replication and Temporary Tables”
      </a>
      . This
          variable reports the total count of open temporary tables for
      <span class="emphasis">
       <em>
        all
       </em>
      </span>
      replication channels.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Resource_group_supported">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Resource_group_supported">
       <code class="literal">
        Resource_group_supported
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262287008">
     </a>
     <a class="indexterm" name="idm46045262285904">
     </a>
     <p>
      Indicates whether the resource group feature is supported.
     </p>
     <p>
      On some platforms or MySQL server configurations, resource
          groups are unavailable or have limitations. In particular,
          Linux systems might require a manual step for some
          installation methods. For details, see
      <a class="xref" href="resource-groups.html#resource-group-restrictions" title="Resource Group Restrictions">
       Resource Group Restrictions
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_clients">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_clients">
       <code class="literal">
        Rpl_semi_sync_master_clients
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262279968">
     </a>
     <a class="indexterm" name="idm46045262278864">
     </a>
     <p>
      The number of semisynchronous replicas.
     </p>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_clients">
       <code class="literal">
        Rpl_semi_sync_source_clients
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_net_avg_wait_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_net_avg_wait_time">
       <code class="literal">
        Rpl_semi_sync_master_net_avg_wait_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262272560">
     </a>
     <a class="indexterm" name="idm46045262271520">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_avg_wait_time">
       <code class="literal">
        Rpl_semi_sync_source_net_avg_wait_time
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_net_wait_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_net_wait_time">
       <code class="literal">
        Rpl_semi_sync_master_net_wait_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262265712">
     </a>
     <a class="indexterm" name="idm46045262264672">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_wait_time">
       <code class="literal">
        Rpl_semi_sync_source_net_wait_time
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_net_waits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_net_waits">
       <code class="literal">
        Rpl_semi_sync_master_net_waits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262258928">
     </a>
     <a class="indexterm" name="idm46045262257824">
     </a>
     <p>
      The total number of times the source waited for replica
          replies.
     </p>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_waits">
       <code class="literal">
        Rpl_semi_sync_source_net_waits
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_no_times">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_no_times">
       <code class="literal">
        Rpl_semi_sync_master_no_times
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262251616">
     </a>
     <a class="indexterm" name="idm46045262250512">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_no_times">
       <code class="literal">
        Rpl_semi_sync_source_no_times
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_no_tx">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_no_tx">
       <code class="literal">
        Rpl_semi_sync_master_no_tx
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262244800">
     </a>
     <a class="indexterm" name="idm46045262243696">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_no_tx">
       <code class="literal">
        Rpl_semi_sync_source_no_tx
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_status">
       <code class="literal">
        Rpl_semi_sync_master_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262238048">
     </a>
     <a class="indexterm" name="idm46045262236944">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_status">
       <code class="literal">
        Rpl_semi_sync_source_status
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_timefunc_failures">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_timefunc_failures">
       <code class="literal">
        Rpl_semi_sync_master_timefunc_failures
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262231168">
     </a>
     <a class="indexterm" name="idm46045262230128">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_timefunc_failures">
       <code class="literal">
        Rpl_semi_sync_source_timefunc_failures
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_tx_avg_wait_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_tx_avg_wait_time">
       <code class="literal">
        Rpl_semi_sync_master_tx_avg_wait_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262224256">
     </a>
     <a class="indexterm" name="idm46045262223216">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_avg_wait_time">
       <code class="literal">
        Rpl_semi_sync_source_tx_avg_wait_time
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_tx_wait_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_tx_wait_time">
       <code class="literal">
        Rpl_semi_sync_master_tx_wait_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262217408">
     </a>
     <a class="indexterm" name="idm46045262216368">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_wait_time">
       <code class="literal">
        Rpl_semi_sync_source_tx_wait_time
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_tx_waits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_tx_waits">
       <code class="literal">
        Rpl_semi_sync_master_tx_waits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262210688">
     </a>
     <a class="indexterm" name="idm46045262209584">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_waits">
       <code class="literal">
        Rpl_semi_sync_source_tx_waits
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_wait_pos_backtraverse">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_wait_pos_backtraverse">
       <code class="literal">
        Rpl_semi_sync_master_wait_pos_backtraverse
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262203792">
     </a>
     <a class="indexterm" name="idm46045262202672">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_wait_pos_backtraverse">
       <code class="literal">
        Rpl_semi_sync_source_wait_pos_backtraverse
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_wait_sessions">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_wait_sessions">
       <code class="literal">
        Rpl_semi_sync_master_wait_sessions
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262196768">
     </a>
     <a class="indexterm" name="idm46045262195728">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_wait_sessions">
       <code class="literal">
        Rpl_semi_sync_source_wait_sessions
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_master_yes_tx">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_master_yes_tx">
       <code class="literal">
        Rpl_semi_sync_master_yes_tx
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262190048">
     </a>
     <a class="indexterm" name="idm46045262188944">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_yes_tx">
       <code class="literal">
        Rpl_semi_sync_source_yes_tx
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_clients">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_clients">
       <code class="literal">
        Rpl_semi_sync_source_clients
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262183296">
     </a>
     <a class="indexterm" name="idm46045262182192">
     </a>
     <p>
      The number of semisynchronous replicas.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_net_avg_wait_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_avg_wait_time">
       <code class="literal">
        Rpl_semi_sync_source_net_avg_wait_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262175696">
     </a>
     <a class="indexterm" name="idm46045262174656">
     </a>
     <p>
      The average time in microseconds the source waited for a
          replica reply. This variable is always
      <code class="literal">
       0
      </code>
      ,
          and is deprecated; expect it to be removed in a future
          version.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_net_wait_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_wait_time">
       <code class="literal">
        Rpl_semi_sync_source_net_wait_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262167408">
     </a>
     <a class="indexterm" name="idm46045262166368">
     </a>
     <p>
      The total time in microseconds the source waited for replica
          replies. This variable is always
      <code class="literal">
       0
      </code>
      , and is
          deprecated; expect it to be removed in a future version.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_net_waits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_net_waits">
       <code class="literal">
        Rpl_semi_sync_source_net_waits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262159200">
     </a>
     <a class="indexterm" name="idm46045262158096">
     </a>
     <p>
      The total number of times the source waited for replica
          replies.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_no_times">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_no_times">
       <code class="literal">
        Rpl_semi_sync_source_no_times
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262151696">
     </a>
     <a class="indexterm" name="idm46045262150592">
     </a>
     <p>
      The number of times the source turned off semisynchronous
          replication.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_no_tx">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_no_tx">
       <code class="literal">
        Rpl_semi_sync_source_no_tx
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262144192">
     </a>
     <a class="indexterm" name="idm46045262143088">
     </a>
     <p>
      The number of commits that were not acknowledged successfully
          by a replica.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_status">
       <code class="literal">
        Rpl_semi_sync_source_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262136736">
     </a>
     <a class="indexterm" name="idm46045262135632">
     </a>
     <p>
      Whether semisynchronous replication currently is operational
          on the source. The value is
      <code class="literal">
       ON
      </code>
      if the
          plugin has been enabled and a commit acknowledgment has
          occurred. It is
      <code class="literal">
       OFF
      </code>
      if the plugin is not
          enabled or the source has fallen back to asynchronous
          replication due to commit acknowledgment timeout.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_timefunc_failures">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_timefunc_failures">
       <code class="literal">
        Rpl_semi_sync_source_timefunc_failures
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262127488">
     </a>
     <a class="indexterm" name="idm46045262126448">
     </a>
     <p>
      The number of times the source failed when calling time
          functions such as
      <code class="literal">
       gettimeofday()
      </code>
      .
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_tx_avg_wait_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_avg_wait_time">
       <code class="literal">
        Rpl_semi_sync_source_tx_avg_wait_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262119200">
     </a>
     <a class="indexterm" name="idm46045262118160">
     </a>
     <p>
      The average time in microseconds the source waited for each
          transaction.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_tx_wait_time">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_wait_time">
       <code class="literal">
        Rpl_semi_sync_source_tx_wait_time
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262111632">
     </a>
     <a class="indexterm" name="idm46045262110592">
     </a>
     <p>
      The total time in microseconds the source waited for
          transactions.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_tx_waits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_tx_waits">
       <code class="literal">
        Rpl_semi_sync_source_tx_waits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262104192">
     </a>
     <a class="indexterm" name="idm46045262103088">
     </a>
     <p>
      The total number of times the source waited for transactions.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_wait_pos_backtraverse">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_wait_pos_backtraverse">
       <code class="literal">
        Rpl_semi_sync_source_wait_pos_backtraverse
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262096624">
     </a>
     <a class="indexterm" name="idm46045262095504">
     </a>
     <p>
      The total number of times the source waited for an event with
          binary coordinates lower than events waited for previously.
          This can occur when the order in which transactions start
          waiting for a reply is different from the order in which their
          binary log events are written.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_wait_sessions">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_wait_sessions">
       <code class="literal">
        Rpl_semi_sync_source_wait_sessions
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262088720">
     </a>
     <a class="indexterm" name="idm46045262087680">
     </a>
     <p>
      The number of sessions currently waiting for replica replies.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_source_yes_tx">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_source_yes_tx">
       <code class="literal">
        Rpl_semi_sync_source_yes_tx
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262081360">
     </a>
     <a class="indexterm" name="idm46045262080256">
     </a>
     <p>
      The number of commits that were acknowledged successfully by a
          replica.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_replica_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_replica_status">
       <code class="literal">
        Rpl_semi_sync_replica_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262073856">
     </a>
     <a class="indexterm" name="idm46045262072752">
     </a>
     <p>
      Shows whether semisynchronous replication is currently
          operational on the replica. This is
      <code class="literal">
       ON
      </code>
      if
          the plugin has been enabled and the replication I/O (receiver)
          thread is running,
      <code class="literal">
       OFF
      </code>
      otherwise.
     </p>
     <p>
      Available when the
      <code class="literal">
       rpl_semi_sync_source
      </code>
      plugin (
      <code class="filename">
       semisync_source.so
      </code>
      library) is
          installed on the source.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rpl_semi_sync_slave_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_slave_status">
       <code class="literal">
        Rpl_semi_sync_slave_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262064864">
     </a>
     <a class="indexterm" name="idm46045262063760">
     </a>
     <p>
      Deprecated synonym for
      <a class="link" href="server-status-variables.html#statvar_Rpl_semi_sync_replica_status">
       <code class="literal">
        Rpl_semi_sync_replica_status
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Rsa_public_key">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Rsa_public_key">
       <code class="literal">
        Rsa_public_key
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262058128">
     </a>
     <a class="indexterm" name="idm46045262057040">
     </a>
     <p>
      The value of this variable is the public key used by the
      <code class="literal">
       sha256_password
      </code>
      (deprecated) authentication
          plugin for RSA key pair-based password exchange. The value is
          nonempty only if the server successfully initializes the
          private and public keys in the files named by the
      <a class="link" href="server-system-variables.html#sysvar_sha256_password_private_key_path">
       <code class="literal">
        sha256_password_private_key_path
       </code>
      </a>
      and
      <a class="link" href="server-system-variables.html#sysvar_sha256_password_public_key_path">
       <code class="literal">
        sha256_password_public_key_path
       </code>
      </a>
      system variables. The value of
      <a class="link" href="server-status-variables.html#statvar_Rsa_public_key">
       <code class="literal">
        Rsa_public_key
       </code>
      </a>
      comes from
          the latter file.
     </p>
     <p>
      For information about
      <code class="literal">
       sha256_password
      </code>
      , see
      <a class="xref" href="sha256-pluggable-authentication.html" title="8.4.1.3 SHA-256 Pluggable Authentication">
       Section 8.4.1.3, “SHA-256 Pluggable Authentication”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Secondary_engine_execution_count">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Secondary_engine_execution_count">
       <code class="literal">
        Secondary_engine_execution_count
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262045792">
     </a>
     <a class="indexterm" name="idm46045262044752">
     </a>
     <p>
      The number of queries offloaded to a secondary engine.
     </p>
     <p>
      For use with HeatWave. See
      <a class="ulink" href="/doc/heatwave/en/" target="_top">
       HeatWave User Guide
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Select_full_join">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Select_full_join">
       <code class="literal">
        Select_full_join
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262039088">
     </a>
     <a class="indexterm" name="idm46045262038048">
     </a>
     <p>
      The number of joins that perform table scans because they do
          not use indexes. If this value is not 0, you should carefully
          check the indexes of your tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Select_full_range_join">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Select_full_range_join">
       <code class="literal">
        Select_full_range_join
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262033456">
     </a>
     <a class="indexterm" name="idm46045262032416">
     </a>
     <p>
      The number of joins that used a range search on a reference
          table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Select_range">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Select_range">
       <code class="literal">
        Select_range
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262028032">
     </a>
     <a class="indexterm" name="idm46045262026944">
     </a>
     <p>
      The number of joins that used ranges on the first table. This
          is normally not a critical issue even if the value is quite
          large.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Select_range_check">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Select_range_check">
       <code class="literal">
        Select_range_check
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262022368">
     </a>
     <a class="indexterm" name="idm46045262021328">
     </a>
     <p>
      The number of joins without keys that check for key usage
          after each row. If this is not 0, you should carefully check
          the indexes of your tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Select_scan">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Select_scan">
       <code class="literal">
        Select_scan
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262016912">
     </a>
     <a class="indexterm" name="idm46045262015824">
     </a>
     <p>
      The number of joins that did a full scan of the first table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Slave_open_temp_tables">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Slave_open_temp_tables">
       <code class="literal">
        Slave_open_temp_tables
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262011408">
     </a>
     <a class="indexterm" name="idm46045262010368">
     </a>
     <p>
      Deprecated alias for
      <a class="link" href="server-status-variables.html#statvar_Replica_open_temp_tables">
       <code class="literal">
        Replica_open_temp_tables
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Slave_rows_last_search_algorithm_used">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Slave_rows_last_search_algorithm_used">
       <code class="literal">
        Slave_rows_last_search_algorithm_used
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045262004544">
     </a>
     <a class="indexterm" name="idm46045262003504">
     </a>
     <p>
      Deprecated alias for
      <a class="ulink" href="/doc/refman/8.0/en/server-status-variables.html#statvar_Replica_rows_last_search_algorithm_used" target="_top">
       <code class="literal">
        Replica_rows_last_search_algorithm_used
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Slow_launch_threads">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Slow_launch_threads">
       <code class="literal">
        Slow_launch_threads
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261997872">
     </a>
     <a class="indexterm" name="idm46045261996832">
     </a>
     <p>
      The number of threads that have taken more than
      <a class="link" href="server-system-variables.html#sysvar_slow_launch_time">
       <code class="literal">
        slow_launch_time
       </code>
      </a>
      seconds to
          create.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Slow_queries">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Slow_queries">
       <code class="literal">
        Slow_queries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261991232">
     </a>
     <a class="indexterm" name="idm46045261990144">
     </a>
     <p>
      The number of queries that have taken more than
      <a class="link" href="server-system-variables.html#sysvar_long_query_time">
       <code class="literal">
        long_query_time
       </code>
      </a>
      seconds. This
          counter increments regardless of whether the slow query log is
          enabled. For information about that log, see
      <a class="xref" href="slow-query-log.html" title="7.4.5 The Slow Query Log">
       Section 7.4.5, “The Slow Query Log”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Sort_merge_passes">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Sort_merge_passes">
       <code class="literal">
        Sort_merge_passes
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261983632">
     </a>
     <a class="indexterm" name="idm46045261982592">
     </a>
     <p>
      The number of merge passes that the sort algorithm has had to
          do. If this value is large, you should consider increasing the
          value of the
      <a class="link" href="server-system-variables.html#sysvar_sort_buffer_size">
       <code class="literal">
        sort_buffer_size
       </code>
      </a>
      system variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Sort_range">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Sort_range">
       <code class="literal">
        Sort_range
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261976880">
     </a>
     <a class="indexterm" name="idm46045261975792">
     </a>
     <p>
      The number of sorts that were done using ranges.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Sort_rows">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Sort_rows">
       <code class="literal">
        Sort_rows
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261971504">
     </a>
     <a class="indexterm" name="idm46045261970416">
     </a>
     <p>
      The number of sorted rows.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Sort_scan">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Sort_scan">
       <code class="literal">
        Sort_scan
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261966080">
     </a>
     <a class="indexterm" name="idm46045261964992">
     </a>
     <p>
      The number of sorts that were done by scanning the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_accept_renegotiates">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_accept_renegotiates">
       <code class="literal">
        Ssl_accept_renegotiates
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261960512">
     </a>
     <a class="indexterm" name="idm46045261959472">
     </a>
     <p>
      The number of negotiates needed to establish the connection.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_accepts">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_accepts">
       <code class="literal">
        Ssl_accepts
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261955104">
     </a>
     <a class="indexterm" name="idm46045261954016">
     </a>
     <p>
      The number of accepted SSL connections.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_callback_cache_hits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_callback_cache_hits">
       <code class="literal">
        Ssl_callback_cache_hits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261949552">
     </a>
     <a class="indexterm" name="idm46045261948512">
     </a>
     <p>
      The number of callback cache hits.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_cipher">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_cipher">
       <code class="literal">
        Ssl_cipher
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261944176">
     </a>
     <a class="indexterm" name="idm46045261943088">
     </a>
     <p>
      The current encryption cipher (empty for unencrypted
          connections).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_cipher_list">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_cipher_list">
       <code class="literal">
        Ssl_cipher_list
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261938704">
     </a>
     <a class="indexterm" name="idm46045261937616">
     </a>
     <p>
      The list of possible SSL ciphers (empty for non-SSL
          connections). If MySQL supports TLSv1.3, the value includes
          the possible TLSv1.3 ciphersuites. See
      <a class="xref" href="encrypted-connection-protocols-ciphers.html" title="8.3.2 Encrypted Connection TLS Protocols and Ciphers">
       Section 8.3.2, “Encrypted Connection TLS Protocols and Ciphers”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_client_connects">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_client_connects">
       <code class="literal">
        Ssl_client_connects
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261932384">
     </a>
     <a class="indexterm" name="idm46045261931344">
     </a>
     <p>
      The number of SSL connection attempts to an SSL-enabled
          replication source server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_connect_renegotiates">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_connect_renegotiates">
       <code class="literal">
        Ssl_connect_renegotiates
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261926928">
     </a>
     <a class="indexterm" name="idm46045261925824">
     </a>
     <p>
      The number of negotiates needed to establish the connection to
          an SSL-enabled replication source server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_ctx_verify_depth">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_ctx_verify_depth">
       <code class="literal">
        Ssl_ctx_verify_depth
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261921280">
     </a>
     <a class="indexterm" name="idm46045261920240">
     </a>
     <p>
      The SSL context verification depth (how many certificates in
          the chain are tested).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_ctx_verify_mode">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_ctx_verify_mode">
       <code class="literal">
        Ssl_ctx_verify_mode
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261915792">
     </a>
     <a class="indexterm" name="idm46045261914752">
     </a>
     <p>
      The SSL context verification mode.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_default_timeout">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_default_timeout">
       <code class="literal">
        Ssl_default_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261910368">
     </a>
     <a class="indexterm" name="idm46045261909328">
     </a>
     <p>
      The default SSL timeout.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_finished_accepts">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_finished_accepts">
       <code class="literal">
        Ssl_finished_accepts
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261904944">
     </a>
     <a class="indexterm" name="idm46045261903904">
     </a>
     <p>
      The number of successful SSL connections to the server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_finished_connects">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_finished_connects">
       <code class="literal">
        Ssl_finished_connects
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261899424">
     </a>
     <a class="indexterm" name="idm46045261898384">
     </a>
     <p>
      The number of successful replica connections to an SSL-enabled
          replication source server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_server_not_after">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_server_not_after">
       <code class="literal">
        Ssl_server_not_after
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261893936">
     </a>
     <a class="indexterm" name="idm46045261892896">
     </a>
     <p>
      The last date for which the SSL certificate is valid. To check
          SSL certificate expiration information, use this statement:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa32150553"><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">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'Ssl_server_not%'</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>
<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>
<span class="token output"><span class="token punctuation">|</span> Ssl_server_not_after  <span class="token punctuation">|</span> Apr 28 14:16:39 2025 GMT <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> Ssl_server_not_before <span class="token punctuation">|</span> May  1 14:16:39 2015 GMT <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></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_server_not_before">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_server_not_before">
       <code class="literal">
        Ssl_server_not_before
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261886368">
     </a>
     <a class="indexterm" name="idm46045261885328">
     </a>
     <p>
      The first date for which the SSL certificate is valid.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_session_cache_hits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_session_cache_hits">
       <code class="literal">
        Ssl_session_cache_hits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261880848">
     </a>
     <a class="indexterm" name="idm46045261879808">
     </a>
     <p>
      The number of SSL session cache hits.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_session_cache_misses">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_session_cache_misses">
       <code class="literal">
        Ssl_session_cache_misses
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261875376">
     </a>
     <a class="indexterm" name="idm46045261874272">
     </a>
     <p>
      The number of SSL session cache misses.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_session_cache_mode">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_session_cache_mode">
       <code class="literal">
        Ssl_session_cache_mode
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261869792">
     </a>
     <a class="indexterm" name="idm46045261868752">
     </a>
     <p>
      The SSL session cache mode. When the value of the
      <a class="link" href="server-system-variables.html#sysvar_ssl_session_cache_mode">
       <code class="literal">
        ssl_session_cache_mode
       </code>
      </a>
      server
          variable is
      <code class="literal">
       ON
      </code>
      , the value of the
      <a class="link" href="server-status-variables.html#statvar_Ssl_session_cache_mode">
       <code class="literal">
        Ssl_session_cache_mode
       </code>
      </a>
      status variable is
      <code class="literal">
       SERVER
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_session_cache_overflows">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_session_cache_overflows">
       <code class="literal">
        Ssl_session_cache_overflows
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261860336">
     </a>
     <a class="indexterm" name="idm46045261859232">
     </a>
     <p>
      The number of SSL session cache overflows.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_session_cache_size">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_session_cache_size">
       <code class="literal">
        Ssl_session_cache_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261854816">
     </a>
     <a class="indexterm" name="idm46045261853776">
     </a>
     <p>
      The SSL session cache size.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_session_cache_timeout">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_session_cache_timeout">
       <code class="literal">
        Ssl_session_cache_timeout
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261849360">
     </a>
     <a class="indexterm" name="idm46045261848256">
     </a>
     <p>
      The timeout value in seconds of SSL sessions in the cache.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_session_cache_timeouts">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_session_cache_timeouts">
       <code class="literal">
        Ssl_session_cache_timeouts
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261843792">
     </a>
     <a class="indexterm" name="idm46045261842688">
     </a>
     <p>
      The number of SSL session cache timeouts.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_sessions_reused">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_sessions_reused">
       <code class="literal">
        Ssl_sessions_reused
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261838208">
     </a>
     <a class="indexterm" name="idm46045261837168">
     </a>
     <p>
      This is equal to 0 if TLS was not used in the current MySQL
          session, or if a TLS session has not been reused; otherwise it
          is equal to 1.
     </p>
     <p>
      <code class="literal">
       Ssl_sessions_reused
      </code>
      has session scope.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_used_session_cache_entries">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_used_session_cache_entries">
       <code class="literal">
        Ssl_used_session_cache_entries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261831504">
     </a>
     <a class="indexterm" name="idm46045261830400">
     </a>
     <p>
      How many SSL session cache entries were used.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_verify_depth">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_verify_depth">
       <code class="literal">
        Ssl_verify_depth
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261825984">
     </a>
     <a class="indexterm" name="idm46045261824944">
     </a>
     <p>
      The verification depth for replication SSL connections.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_verify_mode">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_verify_mode">
       <code class="literal">
        Ssl_verify_mode
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261820640">
     </a>
     <a class="indexterm" name="idm46045261819552">
     </a>
     <p>
      The verification mode used by the server for a connection that
          uses SSL. The value is a bitmask; bits are defined in the
      <code class="filename">
       openssl/ssl.h
      </code>
      header file:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-c"><div class="docs-select-all right" id="sa62349100"><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-c"><span class="token macro property"># <span class="token directive keyword">define</span> SSL_VERIFY_NONE                 0x00</span>
<span class="token macro property"># <span class="token directive keyword">define</span> SSL_VERIFY_PEER                 0x01</span>
<span class="token macro property"># <span class="token directive keyword">define</span> SSL_VERIFY_FAIL_IF_NO_PEER_CERT 0x02</span>
<span class="token macro property"># <span class="token directive keyword">define</span> SSL_VERIFY_CLIENT_ONCE          0x04</span></code></pre>
     </div>
     <p>
      <code class="literal">
       SSL_VERIFY_PEER
      </code>
      indicates that the server
          asks for a client certificate. If the client supplies one, the
          server performs verification and proceeds only if verification
          is successful.
      <code class="literal">
       SSL_VERIFY_CLIENT_ONCE
      </code>
      indicates that a request for the client certificate is
          performed only in the initial handshake.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Ssl_version">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Ssl_version">
       <code class="literal">
        Ssl_version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261811168">
     </a>
     <a class="indexterm" name="idm46045261810080">
     </a>
     <p>
      The SSL protocol version of the connection (for example,
          TLSv1.2). If the connection is not encrypted, the value is
          empty.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Table_locks_immediate">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Table_locks_immediate">
       <code class="literal">
        Table_locks_immediate
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261805584">
     </a>
     <a class="indexterm" name="idm46045261804544">
     </a>
     <p>
      The number of times that a request for a table lock could be
          granted immediately.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Table_locks_waited">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Table_locks_waited">
       <code class="literal">
        Table_locks_waited
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261800032">
     </a>
     <a class="indexterm" name="idm46045261798992">
     </a>
     <p>
      The number of times that a request for a table lock could not
          be granted immediately and a wait was needed. If this is high
          and you have performance problems, you should first optimize
          your queries, and then either split your table or tables or
          use replication.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Table_open_cache_hits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Table_open_cache_hits">
       <code class="literal">
        Table_open_cache_hits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261794272">
     </a>
     <a class="indexterm" name="idm46045261793232">
     </a>
     <p>
      The number of hits for open tables cache lookups.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Table_open_cache_misses">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Table_open_cache_misses">
       <code class="literal">
        Table_open_cache_misses
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261788768">
     </a>
     <a class="indexterm" name="idm46045261787728">
     </a>
     <p>
      The number of misses for open tables cache lookups.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Table_open_cache_overflows">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Table_open_cache_overflows">
       <code class="literal">
        Table_open_cache_overflows
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261783296">
     </a>
     <a class="indexterm" name="idm46045261782192">
     </a>
     <p>
      The number of overflows for the open tables cache. This is the
          number of times, after a table is opened or closed, a cache
          instance has an unused entry and the size of the instance is
          larger than
      <a class="link" href="server-system-variables.html#sysvar_table_open_cache">
       <code class="literal">
        table_open_cache
       </code>
      </a>
      /
      <a class="link" href="server-system-variables.html#sysvar_table_open_cache_instances">
       <code class="literal">
        table_open_cache_instances
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Tc_log_max_pages_used">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Tc_log_max_pages_used">
       <code class="literal">
        Tc_log_max_pages_used
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261775024">
     </a>
     <a class="indexterm" name="idm46045261773984">
     </a>
     <p>
      For the memory-mapped implementation of the log that is used
          by
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
      when it acts as the transaction
          coordinator for recovery of internal XA transactions, this
          variable indicates the largest number of pages used for the
          log since the server started. If the product of
      <a class="link" href="server-status-variables.html#statvar_Tc_log_max_pages_used">
       <code class="literal">
        Tc_log_max_pages_used
       </code>
      </a>
      and
      <a class="link" href="server-status-variables.html#statvar_Tc_log_page_size">
       <code class="literal">
        Tc_log_page_size
       </code>
      </a>
      is always
          significantly less than the log size, the size is larger than
          necessary and can be reduced. (The size is set by the
      <a class="link" href="server-options.html#option_mysqld_log-tc-size">
       <code class="option">
        --log-tc-size
       </code>
      </a>
      option. This
          variable is unused: It is unneeded for binary log-based
          recovery, and the memory-mapped recovery log method is not
          used unless the number of storage engines that are capable of
          two-phase commit and that support XA transactions is greater
          than one. (
      <code class="literal">
       InnoDB
      </code>
      is the only applicable
          engine.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Tc_log_page_size">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Tc_log_page_size">
       <code class="literal">
        Tc_log_page_size
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261763328">
     </a>
     <a class="indexterm" name="idm46045261762288">
     </a>
     <p>
      The page size used for the memory-mapped implementation of the
          XA recovery log. The default value is determined using
      <code class="literal">
       getpagesize()
      </code>
      . This variable is unused for
          the same reasons as described for
      <a class="link" href="server-status-variables.html#statvar_Tc_log_max_pages_used">
       <code class="literal">
        Tc_log_max_pages_used
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Tc_log_page_waits">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Tc_log_page_waits">
       <code class="literal">
        Tc_log_page_waits
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261755696">
     </a>
     <a class="indexterm" name="idm46045261754656">
     </a>
     <p>
      For the memory-mapped implementation of the recovery log, this
          variable increments each time the server was not able to
          commit a transaction and had to wait for a free page in the
          log. If this value is large, you might want to increase the
          log size (with the
      <a class="link" href="server-options.html#option_mysqld_log-tc-size">
       <code class="option">
        --log-tc-size
       </code>
      </a>
      option). For
          binary log-based recovery, this variable increments each time
          the binary log cannot be closed because there are two-phase
          commits in progress. (The close operation waits until all such
          transactions are finished.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Telemetry_metrics_supported">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Telemetry_metrics_supported">
       <code class="literal">
        Telemetry_metrics_supported
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261748720">
     </a>
     <a class="indexterm" name="idm46045261747616">
     </a>
     <p>
      Whether server telemetry metrics is supported.
     </p>
     <p>
      For more information, see the
      <span class="emphasis">
       <em>
        Server telemetry
          metrics service
       </em>
      </span>
      section in the MySQL Source Code
          documentation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_telemetry.live_sessions">
      </a>
      <a class="link" href="server-status-variables.html#statvar_telemetry.live_sessions">
       <code class="literal">
        telemetry.live_sessions
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261742160">
     </a>
     <a class="indexterm" name="idm46045261741120">
     </a>
     <p>
      Displays the current number of sessions instrumented with
          telemetry. This can be useful when unloading the Telemetry
          component, to monitor how many sessions are blocking the
          unload operation.
     </p>
     <p>
      For more information, see the
      <span class="emphasis">
       <em>
        Server telemetry
          traces service
       </em>
      </span>
      section in the MySQL Source Code
          documentation and
      <a class="xref" href="telemetry.html" title="Chapter 35 Telemetry">
       Chapter 35,
       <i>
        Telemetry
       </i>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Telemetry_traces_supported">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Telemetry_traces_supported">
       <code class="literal">
        Telemetry_traces_supported
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261734928">
     </a>
     <a class="indexterm" name="idm46045261733824">
     </a>
     <p>
      Whether server telemetry traces is supported.
     </p>
     <p>
      For more information, see the
      <span class="emphasis">
       <em>
        Server telemetry
          traces service
       </em>
      </span>
      section in the MySQL Source Code
          documentation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Threads_cached">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Threads_cached">
       <code class="literal">
        Threads_cached
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261728480">
     </a>
     <a class="indexterm" name="idm46045261727392">
     </a>
     <p>
      The number of threads in the thread cache.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Threads_connected">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Threads_connected">
       <code class="literal">
        Threads_connected
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261722992">
     </a>
     <a class="indexterm" name="idm46045261721952">
     </a>
     <p>
      The number of currently open connections.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Threads_created">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Threads_created">
       <code class="literal">
        Threads_created
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261717600">
     </a>
     <a class="indexterm" name="idm46045261716512">
     </a>
     <p>
      The number of threads created to handle connections. If
      <a class="link" href="server-status-variables.html#statvar_Threads_created">
       <code class="literal">
        Threads_created
       </code>
      </a>
      is big, you
          may want to increase the
      <a class="link" href="server-system-variables.html#sysvar_thread_cache_size">
       <code class="literal">
        thread_cache_size
       </code>
      </a>
      value. The
          cache miss rate can be calculated as
      <a class="link" href="server-status-variables.html#statvar_Threads_created">
       <code class="literal">
        Threads_created
       </code>
      </a>
      /
      <a class="link" href="server-status-variables.html#statvar_Connections">
       <code class="literal">
        Connections
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Threads_running">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Threads_running">
       <code class="literal">
        Threads_running
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261707184">
     </a>
     <a class="indexterm" name="idm46045261706096">
     </a>
     <p>
      The number of threads that are not sleeping.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Tls_library_version">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Tls_library_version">
       <code class="literal">
        Tls_library_version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261701632">
     </a>
     <a class="indexterm" name="idm46045261700592">
     </a>
     <p>
      The runtime version of the OpenSSL library that is in use for
          this MySQL instance.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Tls_sni_server_name">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Tls_sni_server_name">
       <code class="literal">
        Tls_sni_server_name
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261696080">
     </a>
     <a class="indexterm" name="idm46045261695040">
     </a>
     <p>
      The Server Name Indication (SNI) that is in use for this
          session, if specified by the client; otherwise, empty. SNI is
          an extension to the TLS protocol (OpenSSL must be compiled
          using TLS extensions for this status variable to function).
          The MySQL implementation of SNI represents the client-side
          only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Uptime">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Uptime">
       <code class="literal">
        Uptime
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261690384">
     </a>
     <a class="indexterm" name="idm46045261689312">
     </a>
     <p>
      The number of seconds that the server has been up.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="statvar_Uptime_since_flush_status">
      </a>
      <a class="link" href="server-status-variables.html#statvar_Uptime_since_flush_status">
       <code class="literal">
        Uptime_since_flush_status
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045261684880">
     </a>
     <a class="indexterm" name="idm46045261683776">
     </a>
     <p>
      The number of seconds since the most recent
      <code class="literal">
       FLUSH
          STATUS
      </code>
      statement.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
