<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="innodb-information-schema-metrics-table">
      </a>
      17.15.6 InnoDB INFORMATION_SCHEMA Metrics Table
     </h3>
    </div>
   </div>
  </div>
  <p>
   The
   <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
    <code class="literal">
     INNODB_METRICS
    </code>
   </a>
   table provides
      information about
   <code class="literal">
    InnoDB
   </code>
   performance and
      resource-related counters.
  </p>
  <p>
   <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
    <code class="literal">
     INNODB_METRICS
    </code>
   </a>
   table columns are
      shown below. For column descriptions, see
   <a class="xref" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
    Section 28.4.21, “The INFORMATION_SCHEMA INNODB_METRICS Table”
   </a>
   .
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa80148274"><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">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span><span class="token operator">=</span><span class="token string">"dml_inserts"</span> \G
<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> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           NAME<span class="token punctuation">:</span> dml_inserts
      SUBSYSTEM<span class="token punctuation">:</span> dml
          COUNT<span class="token punctuation">:</span> 46273
      MAX_COUNT<span class="token punctuation">:</span> 46273
      MIN_COUNT<span class="token punctuation">:</span> NULL
      AVG_COUNT<span class="token punctuation">:</span> 492.2659574468085
    COUNT_RESET<span class="token punctuation">:</span> 46273
MAX_COUNT_RESET<span class="token punctuation">:</span> 46273
MIN_COUNT_RESET<span class="token punctuation">:</span> NULL
AVG_COUNT_RESET<span class="token punctuation">:</span> NULL
   TIME_ENABLED<span class="token punctuation">:</span> 2014-11-28 16<span class="token punctuation">:</span>07<span class="token punctuation">:</span>53
  TIME_DISABLED<span class="token punctuation">:</span> NULL
   TIME_ELAPSED<span class="token punctuation">:</span> 94
     TIME_RESET<span class="token punctuation">:</span> NULL
         STATUS<span class="token punctuation">:</span> enabled
           TYPE<span class="token punctuation">:</span> status_counter
        COMMENT<span class="token punctuation">:</span> Number of rows inserted</span></code></pre>
  </div>
  <h4>
   <a name="idm46045149950272">
   </a>
   Enabling, Disabling, and Resetting Counters
  </h4>
  <p>
   You can enable, disable, and reset counters using the following
      variables:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_enable">
       <code class="literal">
        innodb_monitor_enable
       </code>
      </a>
      :
          Enables counters.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa17101821"><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 keyword">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_enable <span class="token operator">=</span> <span class="token punctuation">[</span>counter<span class="token operator">-</span><span class="token keyword">name</span><span class="token operator">|</span>module_name<span class="token operator">|</span>pattern<span class="token operator">|</span><span class="token keyword">all</span><span class="token punctuation">]</span><span class="token punctuation">;</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_disable">
       <code class="literal">
        innodb_monitor_disable
       </code>
      </a>
      :
          Disables counters.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa87494770"><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 keyword">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_disable <span class="token operator">=</span> <span class="token punctuation">[</span>counter<span class="token operator">-</span><span class="token keyword">name</span><span class="token operator">|</span>module_name<span class="token operator">|</span>pattern<span class="token operator">|</span><span class="token keyword">all</span><span class="token punctuation">]</span><span class="token punctuation">;</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_reset">
       <code class="literal">
        innodb_monitor_reset
       </code>
      </a>
      : Resets
          counter values to zero.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa80747560"><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 keyword">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_reset <span class="token operator">=</span> <span class="token punctuation">[</span>counter<span class="token operator">-</span><span class="token keyword">name</span><span class="token operator">|</span>module_name<span class="token operator">|</span>pattern<span class="token operator">|</span><span class="token keyword">all</span><span class="token punctuation">]</span><span class="token punctuation">;</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_reset_all">
       <code class="literal">
        innodb_monitor_reset_all
       </code>
      </a>
      :
          Resets all counter values. A counter must be disabled before
          using
      <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_reset_all">
       <code class="literal">
        innodb_monitor_reset_all
       </code>
      </a>
      .
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa1003410"><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 keyword">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_reset_all <span class="token operator">=</span> <span class="token punctuation">[</span>counter<span class="token operator">-</span><span class="token keyword">name</span><span class="token operator">|</span>module_name<span class="token operator">|</span>pattern<span class="token operator">|</span><span class="token keyword">all</span><span class="token punctuation">]</span><span class="token punctuation">;</span></code></pre>
     </div>
    </li>
   </ul>
  </div>
  <p>
   Counters and counter modules can also be enabled at startup using
      the MySQL server configuration file. For example, to enable the
   <code class="literal">
    log
   </code>
   module,
   <code class="literal">
    metadata_table_handles_opened
   </code>
   and
   <code class="literal">
    metadata_table_handles_closed
   </code>
   counters, enter
      the following line in the
   <code class="literal">
    [mysqld]
   </code>
   section of
      the MySQL server configuration file.
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-ini"><div class="docs-select-all right" id="sa64800018"><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-ini"><span class="token selector">[mysqld]</span>
<span class="token constant">innodb_monitor_enable</span> <span class="token attr-value"><span class="token punctuation">=</span> log,metadata_table_handles_opened,metadata_table_handles_closed</span></code></pre>
  </div>
  <p>
   When enabling multiple counters or modules in a configuration
      file, specify the
   <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_enable">
    <code class="literal">
     innodb_monitor_enable
    </code>
   </a>
   variable
      followed by counter and module names separated by a comma, as
      shown above. Only the
   <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_enable">
    <code class="literal">
     innodb_monitor_enable
    </code>
   </a>
   variable
      can be used in a configuration file. The
   <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_disable">
    <code class="literal">
     innodb_monitor_disable
    </code>
   </a>
   and
   <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_reset">
    <code class="literal">
     innodb_monitor_reset
    </code>
   </a>
   variables
      are supported on the command line only.
  </p>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    Because each counter adds a degree of runtime overhead, use
        counters conservatively on production servers to diagnose
        specific issues or monitor specific functionality. A test or
        development server is recommended for more extensive use of
        counters.
   </p>
  </div>
  <h4>
   <a name="idm46045149923760">
   </a>
   Counters
  </h4>
  <p>
   The list of available counters is subject to change. Query the
      Information Schema
   <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
    <code class="literal">
     INNODB_METRICS
    </code>
   </a>
   table for counters available in your MySQL server version.
  </p>
  <p>
   The counters enabled by default correspond to those shown in
   <a class="link" href="show-engine.html" title="15.7.7.16 SHOW ENGINE Statement">
    <code class="literal">
     SHOW ENGINE INNODB
      STATUS
    </code>
   </a>
   output. Counters shown in
   <a class="link" href="show-engine.html" title="15.7.7.16 SHOW ENGINE Statement">
    <code class="literal">
     SHOW ENGINE INNODB
      STATUS
    </code>
   </a>
   output are always enabled at a system level but
      can be disabled for the
   <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
    <code class="literal">
     INNODB_METRICS
    </code>
   </a>
   table. Counter status
      is not persistent. Unless configured otherwise, counters revert to
      their default enabled or disabled status when the server is
      restarted.
  </p>
  <p>
   If you run programs that would be affected by the addition or
      removal of counters, it is recommended that you review the
      releases notes and query the
   <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
    <code class="literal">
     INNODB_METRICS
    </code>
   </a>
   table to identify
      those changes as part of your upgrade process.
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa91955213"><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">SELECT</span> <span class="token keyword">name</span><span class="token punctuation">,</span> subsystem<span class="token punctuation">,</span> <span class="token keyword">status</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS <span class="token keyword">ORDER</span> <span class="token keyword">BY</span> <span class="token keyword">NAME</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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> name                                        <span class="token punctuation">|</span> subsystem           <span class="token punctuation">|</span> status   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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> adaptive_hash_pages_added                   <span class="token punctuation">|</span> adaptive_hash_index <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> adaptive_hash_pages_removed                 <span class="token punctuation">|</span> adaptive_hash_index <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> adaptive_hash_rows_added                    <span class="token punctuation">|</span> adaptive_hash_index <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> adaptive_hash_rows_deleted_no_hash_entry    <span class="token punctuation">|</span> adaptive_hash_index <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> adaptive_hash_rows_removed                  <span class="token punctuation">|</span> adaptive_hash_index <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> adaptive_hash_rows_updated                  <span class="token punctuation">|</span> adaptive_hash_index <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> adaptive_hash_searches                      <span class="token punctuation">|</span> adaptive_hash_index <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> adaptive_hash_searches_btree                <span class="token punctuation">|</span> adaptive_hash_index <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_data_reads                           <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_data_written                         <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_adaptive                       <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_adaptive_avg_pass              <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_adaptive_avg_time_est          <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_adaptive_avg_time_slot         <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_adaptive_avg_time_thread       <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_adaptive_pages                 <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_adaptive_total_pages           <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_avg_page_rate                  <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_avg_pass                       <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_avg_time                       <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_background                     <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_background_pages               <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_background_total_pages         <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_batches                        <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_batch_num_scan                 <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_batch_pages                    <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_batch_scanned                  <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_batch_scanned_per_call         <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_batch_total_pages              <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_lsn_avg_rate                   <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_neighbor                       <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_neighbor_pages                 <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_neighbor_total_pages           <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_n_to_flush_by_age              <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_n_to_flush_by_dirty_page       <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_n_to_flush_requested           <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_pct_for_dirty                  <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_pct_for_lsn                    <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_sync                           <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_sync_pages                     <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_sync_total_pages               <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_flush_sync_waits                     <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batches_evict                    <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batches_flush                    <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_evict_pages                <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_evict_total_pages          <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_flush_avg_pass             <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_flush_avg_time_est         <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_flush_avg_time_slot        <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_flush_avg_time_thread      <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_flush_pages                <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_flush_total_pages          <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_num_scan                   <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_scanned                    <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_batch_scanned_per_call           <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_get_free_loops                   <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_get_free_search                  <span class="token punctuation">|</span> Buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_get_free_waits                   <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_search_num_scan                  <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_search_scanned                   <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_search_scanned_per_call          <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_single_flush_failure_count       <span class="token punctuation">|</span> Buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_single_flush_num_scan            <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_single_flush_scanned             <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_single_flush_scanned_per_call    <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_unzip_search_num_scan            <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_unzip_search_scanned             <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_LRU_unzip_search_scanned_per_call    <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pages_created                        <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pages_read                           <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pages_written                        <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_blob                       <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_fsp_hdr                    <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_ibuf_bitmap                <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_ibuf_free_list             <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_index_ibuf_leaf            <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_index_ibuf_non_leaf        <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_index_inode                <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_index_leaf                 <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_index_non_leaf             <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_other                      <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_rseg_array                 <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_system_page                <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_trx_system                 <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_undo_log                   <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_xdes                       <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_zblob                      <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_read_zblob2                     <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_blob                    <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_fsp_hdr                 <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_ibuf_bitmap             <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_ibuf_free_list          <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_index_ibuf_leaf         <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_index_ibuf_non_leaf     <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_index_inode             <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_index_leaf              <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_index_non_leaf          <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_on_log_no_waits         <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_on_log_waits            <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_on_log_wait_loops       <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_other                   <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_rseg_array              <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_system_page             <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_trx_system              <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_undo_log                <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_xdes                    <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_zblob                   <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_page_written_zblob2                  <span class="token punctuation">|</span> buffer_page_io      <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_bytes_data                      <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_bytes_dirty                     <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_pages_data                      <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_pages_dirty                     <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_pages_free                      <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_pages_misc                      <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_pages_total                     <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_reads                           <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_read_ahead                      <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_read_ahead_evicted              <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_read_requests                   <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_size                            <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_wait_free                       <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> buffer_pool_write_requests                  <span class="token punctuation">|</span> buffer              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> compression_pad_decrements                  <span class="token punctuation">|</span> compression         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> compression_pad_increments                  <span class="token punctuation">|</span> compression         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> compress_pages_compressed                   <span class="token punctuation">|</span> compression         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> compress_pages_decompressed                 <span class="token punctuation">|</span> compression         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpu_n                                       <span class="token punctuation">|</span> cpu                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpu_stime_abs                               <span class="token punctuation">|</span> cpu                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpu_stime_pct                               <span class="token punctuation">|</span> cpu                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpu_utime_abs                               <span class="token punctuation">|</span> cpu                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cpu_utime_pct                               <span class="token punctuation">|</span> cpu                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dblwr_async_requests                        <span class="token punctuation">|</span> dblwr               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dblwr_flush_requests                        <span class="token punctuation">|</span> dblwr               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dblwr_flush_wait_events                     <span class="token punctuation">|</span> dblwr               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dblwr_sync_requests                         <span class="token punctuation">|</span> dblwr               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ddl_background_drop_tables                  <span class="token punctuation">|</span> ddl                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ddl_log_file_alter_table                    <span class="token punctuation">|</span> ddl                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ddl_online_create_index                     <span class="token punctuation">|</span> ddl                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ddl_pending_alter_table                     <span class="token punctuation">|</span> ddl                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ddl_sort_file_alter_table                   <span class="token punctuation">|</span> ddl                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_deletes                                 <span class="token punctuation">|</span> dml                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_inserts                                 <span class="token punctuation">|</span> dml                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_reads                                   <span class="token punctuation">|</span> dml                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_system_deletes                          <span class="token punctuation">|</span> dml                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_system_inserts                          <span class="token punctuation">|</span> dml                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_system_reads                            <span class="token punctuation">|</span> dml                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_system_updates                          <span class="token punctuation">|</span> dml                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_updates                                 <span class="token punctuation">|</span> dml                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> file_num_open_files                         <span class="token punctuation">|</span> file_system         <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ibuf_merges                                 <span class="token punctuation">|</span> change_buffer       <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ibuf_merges_delete                          <span class="token punctuation">|</span> change_buffer       <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ibuf_merges_delete_mark                     <span class="token punctuation">|</span> change_buffer       <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ibuf_merges_discard_delete                  <span class="token punctuation">|</span> change_buffer       <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ibuf_merges_discard_delete_mark             <span class="token punctuation">|</span> change_buffer       <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ibuf_merges_discard_insert                  <span class="token punctuation">|</span> change_buffer       <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ibuf_merges_insert                          <span class="token punctuation">|</span> change_buffer       <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ibuf_size                                   <span class="token punctuation">|</span> change_buffer       <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> icp_attempts                                <span class="token punctuation">|</span> icp                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> icp_match                                   <span class="token punctuation">|</span> icp                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> icp_no_match                                <span class="token punctuation">|</span> icp                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> icp_out_of_range                            <span class="token punctuation">|</span> icp                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> index_page_discards                         <span class="token punctuation">|</span> index               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> index_page_merge_attempts                   <span class="token punctuation">|</span> index               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> index_page_merge_successful                 <span class="token punctuation">|</span> index               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> index_page_reorg_attempts                   <span class="token punctuation">|</span> index               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> index_page_reorg_successful                 <span class="token punctuation">|</span> index               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> index_page_splits                           <span class="token punctuation">|</span> index               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_activity_count                       <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_background_drop_table_usec           <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_dblwr_pages_written                  <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_dblwr_writes                         <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_dict_lru_count                       <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_dict_lru_usec                        <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_ibuf_merge_usec                      <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_master_active_loops                  <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_master_idle_loops                    <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_master_purge_usec                    <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_master_thread_sleeps                 <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_mem_validate_usec                    <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_page_size                            <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_sx_os_waits                   <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_sx_spin_rounds                <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_sx_spin_waits                 <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_s_os_waits                    <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_s_spin_rounds                 <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_s_spin_waits                  <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_x_os_waits                    <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_x_spin_rounds                 <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> innodb_rwlock_x_spin_waits                  <span class="token punctuation">|</span> server              <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_deadlocks                              <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_deadlock_false_positives               <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_deadlock_rounds                        <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_rec_grant_attempts                     <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_rec_locks                              <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_rec_lock_created                       <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_rec_lock_removed                       <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_rec_lock_requests                      <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_rec_lock_waits                         <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_rec_release_attempts                   <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_row_lock_current_waits                 <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_row_lock_time                          <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_row_lock_time_avg                      <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_row_lock_time_max                      <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_row_lock_waits                         <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_schedule_refreshes                     <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_table_locks                            <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_table_lock_created                     <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_table_lock_removed                     <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_table_lock_waits                       <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_threads_waiting                        <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> lock_timeouts                               <span class="token punctuation">|</span> lock                <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_checkpoints                             <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_concurrency_margin                      <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flusher_no_waits                        <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flusher_waits                           <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flusher_wait_loops                      <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flush_avg_time                          <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flush_lsn_avg_rate                      <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flush_max_time                          <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flush_notifier_no_waits                 <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flush_notifier_waits                    <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flush_notifier_wait_loops               <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_flush_total_time                        <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_free_space                              <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_full_block_writes                       <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_lsn_archived                            <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_lsn_buf_dirty_pages_added               <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_lsn_buf_pool_oldest_approx              <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_lsn_buf_pool_oldest_lwm                 <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_lsn_checkpoint_age                      <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_lsn_current                             <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_lsn_last_checkpoint                     <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_lsn_last_flush                          <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_max_modified_age_async                  <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_max_modified_age_sync                   <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_next_file                               <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_buffer_space_no_waits                <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_buffer_space_waits                   <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_buffer_space_wait_loops              <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_file_space_no_waits                  <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_file_space_waits                     <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_file_space_wait_loops                <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_flush_no_waits                       <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_flush_waits                          <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_flush_wait_loops                     <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_recent_closed_wait_loops             <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_recent_written_wait_loops            <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_write_no_waits                       <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_write_waits                          <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_on_write_wait_loops                     <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_padded                                  <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_partial_block_writes                    <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_waits                                   <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_writer_no_waits                         <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_writer_on_archiver_waits                <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_writer_on_file_space_waits              <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_writer_waits                            <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_writer_wait_loops                       <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_writes                                  <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_write_notifier_no_waits                 <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_write_notifier_waits                    <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_write_notifier_wait_loops               <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_write_requests                          <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> log_write_to_file_requests_interval         <span class="token punctuation">|</span> log                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> metadata_table_handles_closed               <span class="token punctuation">|</span> metadata            <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> metadata_table_handles_opened               <span class="token punctuation">|</span> metadata            <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> metadata_table_reference_count              <span class="token punctuation">|</span> metadata            <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> module_cpu                                  <span class="token punctuation">|</span> cpu                 <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> module_dblwr                                <span class="token punctuation">|</span> dblwr               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> module_page_track                           <span class="token punctuation">|</span> page_track          <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_data_fsyncs                              <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_data_reads                               <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_data_writes                              <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_log_bytes_written                        <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_log_fsyncs                               <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_log_pending_fsyncs                       <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_log_pending_writes                       <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_pending_reads                            <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> os_pending_writes                           <span class="token punctuation">|</span> os                  <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> page_track_checkpoint_partial_flush_request <span class="token punctuation">|</span> page_track          <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> page_track_full_block_writes                <span class="token punctuation">|</span> page_track          <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> page_track_partial_block_writes             <span class="token punctuation">|</span> page_track          <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> page_track_resets                           <span class="token punctuation">|</span> page_track          <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_del_mark_records                      <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_dml_delay_usec                        <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_invoked                               <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_resume_count                          <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_stop_count                            <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_truncate_history_count                <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_truncate_history_usec                 <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_undo_log_pages                        <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> purge_upd_exist_or_extern_records           <span class="token punctuation">|</span> purge               <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sampled_pages_read                          <span class="token punctuation">|</span> sampling            <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sampled_pages_skipped                       <span class="token punctuation">|</span> sampling            <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_active_transactions                     <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_allocations                             <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_commits_insert_update                   <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_nl_ro_commits                           <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_on_log_no_waits                         <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_on_log_waits                            <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_on_log_wait_loops                       <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_rollbacks                               <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_rollbacks_savepoint                     <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_rollback_active                         <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_ro_commits                              <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_rseg_current_size                       <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_rseg_history_len                        <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> enabled  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_rw_commits                              <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_undo_slots_cached                       <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> trx_undo_slots_used                         <span class="token punctuation">|</span> transaction         <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> undo_truncate_count                         <span class="token punctuation">|</span> undo                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> undo_truncate_done_logging_count            <span class="token punctuation">|</span> undo                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> undo_truncate_start_logging_count           <span class="token punctuation">|</span> undo                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> undo_truncate_usec                          <span class="token punctuation">|</span> undo                <span class="token punctuation">|</span> disabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="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">314 rows in set (0.00 sec)</span></code></pre>
  </div>
  <h4>
   <a name="idm46045149884192">
   </a>
   Counter Modules
  </h4>
  <p>
   Each counter is associated with a particular module. Module names
      can be used to enable, disable, or reset all counters for a
      particular subsystem. For example, use
   <code class="literal">
    module_dml
   </code>
   to enable all counters associated
      with the
   <code class="literal">
    dml
   </code>
   subsystem.
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa30337191"><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">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_enable <span class="token operator">=</span> module_dml<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token keyword">name</span><span class="token punctuation">,</span> subsystem<span class="token punctuation">,</span> <span class="token keyword">status</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS
       <span class="token keyword">WHERE</span> subsystem <span class="token operator">=</span><span class="token string">'dml'</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>
<span class="token output"><span class="token punctuation">|</span> name        <span class="token punctuation">|</span> subsystem <span class="token punctuation">|</span> status  <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>
<span class="token output"><span class="token punctuation">|</span> dml_reads   <span class="token punctuation">|</span> dml       <span class="token punctuation">|</span> enabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_inserts <span class="token punctuation">|</span> dml       <span class="token punctuation">|</span> enabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_deletes <span class="token punctuation">|</span> dml       <span class="token punctuation">|</span> enabled <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dml_updates <span class="token punctuation">|</span> dml       <span class="token punctuation">|</span> enabled <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></code></pre>
  </div>
  <p>
   Module names can be used with
   <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_enable">
    <code class="literal">
     innodb_monitor_enable
    </code>
   </a>
   and related
      variables.
  </p>
  <p>
   Module names and corresponding
   <code class="literal">
    SUBSYSTEM
   </code>
   names
      are listed below.
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       module_adaptive_hash
      </code>
      (subsystem =
      <code class="literal">
       adaptive_hash_index
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_buffer
      </code>
      (subsystem =
      <code class="literal">
       buffer
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_buffer_page
      </code>
      (subsystem =
      <code class="literal">
       buffer_page_io
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_compress
      </code>
      (subsystem =
      <code class="literal">
       compression
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_ddl
      </code>
      (subsystem =
      <code class="literal">
       ddl
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_dml
      </code>
      (subsystem =
      <code class="literal">
       dml
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_file
      </code>
      (subsystem =
      <code class="literal">
       file_system
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_ibuf_system
      </code>
      (subsystem =
      <code class="literal">
       change_buffer
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_icp
      </code>
      (subsystem =
      <code class="literal">
       icp
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_index
      </code>
      (subsystem =
      <code class="literal">
       index
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_innodb
      </code>
      (subsystem =
      <code class="literal">
       innodb
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_lock
      </code>
      (subsystem =
      <code class="literal">
       lock
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_log
      </code>
      (subsystem =
      <code class="literal">
       log
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_metadata
      </code>
      (subsystem =
      <code class="literal">
       metadata
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_os
      </code>
      (subsystem =
      <code class="literal">
       os
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_purge
      </code>
      (subsystem =
      <code class="literal">
       purge
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_trx
      </code>
      (subsystem =
      <code class="literal">
       transaction
      </code>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       module_undo
      </code>
      (subsystem =
      <code class="literal">
       undo
      </code>
      )
     </p>
    </li>
   </ul>
  </div>
  <div class="example">
   <a name="innodb-information-schema-metrics-table-example">
   </a>
   <p class="title">
    <b>
     Example 17.11 Working with INNODB_METRICS Table Counters
    </b>
   </p>
   <div class="example-contents">
    <p>
     This example demonstrates enabling, disabling, and resetting a
        counter, and querying counter data in the
     <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
      <code class="literal">
       INNODB_METRICS
      </code>
     </a>
     table.
    </p>
    <div class="orderedlist">
     <ol class="orderedlist" type="1">
      <li class="listitem">
       <p>
        Create a simple
        <code class="literal">
         InnoDB
        </code>
        table:
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa94391970"><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">USE</span> test<span class="token punctuation">;</span>
<span class="token keyword">Database</span> <span class="token keyword">changed</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> t1 <span class="token punctuation">(</span>c1 <span class="token datatype">INT</span><span class="token punctuation">)</span> <span class="token keyword">ENGINE</span><span class="token operator">=</span>INNODB<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.02 sec)</span></code></pre>
       </div>
      </li>
      <li class="listitem">
       <p>
        Enable the
        <code class="literal">
         dml_inserts
        </code>
        counter.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa3611800"><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">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_enable <span class="token operator">=</span> dml_inserts<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.01 sec)</span></code></pre>
       </div>
       <p>
        A description of the
        <code class="literal">
         dml_inserts
        </code>
        counter
            can be found in the
        <code class="literal">
         COMMENT
        </code>
        column of the
        <code class="literal">
         INNODB_METRICS
        </code>
        table:
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa46185012"><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">SELECT</span> <span class="token keyword">NAME</span><span class="token punctuation">,</span> <span class="token keyword">COMMENT</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span><span class="token operator">=</span><span class="token string">"dml_inserts"</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>
<span class="token output"><span class="token punctuation">|</span> NAME        <span class="token punctuation">|</span> COMMENT                 <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>
<span class="token output"><span class="token punctuation">|</span> dml_inserts <span class="token punctuation">|</span> Number of rows inserted <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></code></pre>
       </div>
      </li>
      <li class="listitem">
       <p>
        Query the
        <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
         <code class="literal">
          INNODB_METRICS
         </code>
        </a>
        table
            for the
        <code class="literal">
         dml_inserts
        </code>
        counter data. Because
            no DML operations have been performed, the counter values
            are zero or NULL. The
        <code class="literal">
         TIME_ENABLED
        </code>
        and
        <code class="literal">
         TIME_ELAPSED
        </code>
        values indicate when the
            counter was last enabled and how many seconds have elapsed
            since that time.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa84259900"><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">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span><span class="token operator">=</span><span class="token string">"dml_inserts"</span> \G
<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> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           NAME<span class="token punctuation">:</span> dml_inserts
      SUBSYSTEM<span class="token punctuation">:</span> dml
          COUNT<span class="token punctuation">:</span> 0
      MAX_COUNT<span class="token punctuation">:</span> 0
      MIN_COUNT<span class="token punctuation">:</span> NULL
      AVG_COUNT<span class="token punctuation">:</span> 0
    COUNT_RESET<span class="token punctuation">:</span> 0
MAX_COUNT_RESET<span class="token punctuation">:</span> 0
MIN_COUNT_RESET<span class="token punctuation">:</span> NULL
AVG_COUNT_RESET<span class="token punctuation">:</span> NULL
   TIME_ENABLED<span class="token punctuation">:</span> 2014-12-04 14<span class="token punctuation">:</span>18<span class="token punctuation">:</span>28
  TIME_DISABLED<span class="token punctuation">:</span> NULL
   TIME_ELAPSED<span class="token punctuation">:</span> 28
     TIME_RESET<span class="token punctuation">:</span> NULL
         STATUS<span class="token punctuation">:</span> enabled
           TYPE<span class="token punctuation">:</span> status_counter
        COMMENT<span class="token punctuation">:</span> Number of rows inserted</span></code></pre>
       </div>
      </li>
      <li class="listitem">
       <p>
        Insert three rows of data into the table.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa20749815"><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">INSERT</span> <span class="token keyword">INTO</span> t1 <span class="token keyword">values</span><span class="token punctuation">(</span><span class="token number">1</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output">Query OK, 1 row affected (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">INSERT</span> <span class="token keyword">INTO</span> t1 <span class="token keyword">values</span><span class="token punctuation">(</span><span class="token number">2</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output">Query OK, 1 row affected (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">INSERT</span> <span class="token keyword">INTO</span> t1 <span class="token keyword">values</span><span class="token punctuation">(</span><span class="token number">3</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output">Query OK, 1 row affected (0.00 sec)</span></code></pre>
       </div>
      </li>
      <li class="listitem">
       <p>
        Query the
        <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
         <code class="literal">
          INNODB_METRICS
         </code>
        </a>
        table
            again for the
        <code class="literal">
         dml_inserts
        </code>
        counter data. A
            number of counter values have now incremented including
        <code class="literal">
         COUNT
        </code>
        ,
        <code class="literal">
         MAX_COUNT
        </code>
        ,
        <code class="literal">
         AVG_COUNT
        </code>
        , and
        <code class="literal">
         COUNT_RESET
        </code>
        . Refer to the
        <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
         <code class="literal">
          INNODB_METRICS
         </code>
        </a>
        table definition
            for descriptions of these values.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa43876000"><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">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span><span class="token operator">=</span><span class="token string">"dml_inserts"</span>\G
<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> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           NAME<span class="token punctuation">:</span> dml_inserts
      SUBSYSTEM<span class="token punctuation">:</span> dml
          COUNT<span class="token punctuation">:</span> 3
      MAX_COUNT<span class="token punctuation">:</span> 3
      MIN_COUNT<span class="token punctuation">:</span> NULL
      AVG_COUNT<span class="token punctuation">:</span> 0.046153846153846156
    COUNT_RESET<span class="token punctuation">:</span> 3
MAX_COUNT_RESET<span class="token punctuation">:</span> 3
MIN_COUNT_RESET<span class="token punctuation">:</span> NULL
AVG_COUNT_RESET<span class="token punctuation">:</span> NULL
   TIME_ENABLED<span class="token punctuation">:</span> 2014-12-04 14<span class="token punctuation">:</span>18<span class="token punctuation">:</span>28
  TIME_DISABLED<span class="token punctuation">:</span> NULL
   TIME_ELAPSED<span class="token punctuation">:</span> 65
     TIME_RESET<span class="token punctuation">:</span> NULL
         STATUS<span class="token punctuation">:</span> enabled
           TYPE<span class="token punctuation">:</span> status_counter
        COMMENT<span class="token punctuation">:</span> Number of rows inserted</span></code></pre>
       </div>
      </li>
      <li class="listitem">
       <p>
        Reset the
        <code class="literal">
         dml_inserts
        </code>
        counter and query
            the
        <a class="link" href="information-schema-innodb-metrics-table.html" title="28.4.21 The INFORMATION_SCHEMA INNODB_METRICS Table">
         <code class="literal">
          INNODB_METRICS
         </code>
        </a>
        table again
            for the
        <code class="literal">
         dml_inserts
        </code>
        counter data. The
        <code class="literal">
         %_RESET
        </code>
        values that were reported
            previously, such as
        <code class="literal">
         COUNT_RESET
        </code>
        and
        <code class="literal">
         MAX_RESET
        </code>
        , are set back to zero. Values
            such as
        <code class="literal">
         COUNT
        </code>
        ,
        <code class="literal">
         MAX_COUNT
        </code>
        , and
        <code class="literal">
         AVG_COUNT
        </code>
        , which cumulatively collect
            data from the time the counter is enabled, are unaffected by
            the reset.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa24772519"><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">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_reset <span class="token operator">=</span> dml_inserts<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span><span class="token operator">=</span><span class="token string">"dml_inserts"</span>\G
<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> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           NAME<span class="token punctuation">:</span> dml_inserts
      SUBSYSTEM<span class="token punctuation">:</span> dml
          COUNT<span class="token punctuation">:</span> 3
      MAX_COUNT<span class="token punctuation">:</span> 3
      MIN_COUNT<span class="token punctuation">:</span> NULL
      AVG_COUNT<span class="token punctuation">:</span> 0.03529411764705882
    COUNT_RESET<span class="token punctuation">:</span> 0
MAX_COUNT_RESET<span class="token punctuation">:</span> 0
MIN_COUNT_RESET<span class="token punctuation">:</span> NULL
AVG_COUNT_RESET<span class="token punctuation">:</span> 0
   TIME_ENABLED<span class="token punctuation">:</span> 2014-12-04 14<span class="token punctuation">:</span>18<span class="token punctuation">:</span>28
  TIME_DISABLED<span class="token punctuation">:</span> NULL
   TIME_ELAPSED<span class="token punctuation">:</span> 85
     TIME_RESET<span class="token punctuation">:</span> 2014-12-04 14<span class="token punctuation">:</span>19<span class="token punctuation">:</span>44
         STATUS<span class="token punctuation">:</span> enabled
           TYPE<span class="token punctuation">:</span> status_counter
        COMMENT<span class="token punctuation">:</span> Number of rows inserted</span></code></pre>
       </div>
      </li>
      <li class="listitem">
       <p>
        To reset all counter values, you must first disable the
            counter. Disabling the counter sets the
        <code class="literal">
         STATUS
        </code>
        value to
        <code class="literal">
         disabled
        </code>
        .
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa67105841"><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">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_disable <span class="token operator">=</span> dml_inserts<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span><span class="token operator">=</span><span class="token string">"dml_inserts"</span>\G
<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> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           NAME<span class="token punctuation">:</span> dml_inserts
      SUBSYSTEM<span class="token punctuation">:</span> dml
          COUNT<span class="token punctuation">:</span> 3
      MAX_COUNT<span class="token punctuation">:</span> 3
      MIN_COUNT<span class="token punctuation">:</span> NULL
      AVG_COUNT<span class="token punctuation">:</span> 0.030612244897959183
    COUNT_RESET<span class="token punctuation">:</span> 0
MAX_COUNT_RESET<span class="token punctuation">:</span> 0
MIN_COUNT_RESET<span class="token punctuation">:</span> NULL
AVG_COUNT_RESET<span class="token punctuation">:</span> 0
   TIME_ENABLED<span class="token punctuation">:</span> 2014-12-04 14<span class="token punctuation">:</span>18<span class="token punctuation">:</span>28
  TIME_DISABLED<span class="token punctuation">:</span> 2014-12-04 14<span class="token punctuation">:</span>20<span class="token punctuation">:</span>06
   TIME_ELAPSED<span class="token punctuation">:</span> 98
     TIME_RESET<span class="token punctuation">:</span> NULL
         STATUS<span class="token punctuation">:</span> disabled
           TYPE<span class="token punctuation">:</span> status_counter
        COMMENT<span class="token punctuation">:</span> Number of rows inserted</span></code></pre>
       </div>
       <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
        <div class="admon-title">
         Note
        </div>
        <p>
         Wildcard match is supported for counter and module names.
              For example, instead of specifying the full
         <code class="literal">
          dml_inserts
         </code>
         counter name, you can
              specify
         <code class="literal">
          dml_i%
         </code>
         . You can also enable,
              disable, or reset multiple counters or modules at once
              using a wildcard match. For example, specify
         <code class="literal">
          dml_%
         </code>
         to enable, disable, or reset all
              counters that begin with
         <code class="literal">
          dml_
         </code>
         .
        </p>
       </div>
      </li>
      <li class="listitem">
       <p>
        After the counter is disabled, you can reset all counter
            values using the
        <a class="link" href="innodb-parameters.html#sysvar_innodb_monitor_reset_all">
         <code class="literal">
          innodb_monitor_reset_all
         </code>
        </a>
        option. All values are set to zero or NULL.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa53861441"><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">SET</span> <span class="token keyword">GLOBAL</span> innodb_monitor_reset_all <span class="token operator">=</span> dml_inserts<span class="token punctuation">;</span>
<span class="token output">Query OK, 0 rows affected (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_METRICS <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span><span class="token operator">=</span><span class="token string">"dml_inserts"</span>\G
<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> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           NAME<span class="token punctuation">:</span> dml_inserts
      SUBSYSTEM<span class="token punctuation">:</span> dml
          COUNT<span class="token punctuation">:</span> 0
      MAX_COUNT<span class="token punctuation">:</span> NULL
      MIN_COUNT<span class="token punctuation">:</span> NULL
      AVG_COUNT<span class="token punctuation">:</span> NULL
    COUNT_RESET<span class="token punctuation">:</span> 0
MAX_COUNT_RESET<span class="token punctuation">:</span> NULL
MIN_COUNT_RESET<span class="token punctuation">:</span> NULL
AVG_COUNT_RESET<span class="token punctuation">:</span> NULL
   TIME_ENABLED<span class="token punctuation">:</span> NULL
  TIME_DISABLED<span class="token punctuation">:</span> NULL
   TIME_ELAPSED<span class="token punctuation">:</span> NULL
     TIME_RESET<span class="token punctuation">:</span> NULL
         STATUS<span class="token punctuation">:</span> disabled
           TYPE<span class="token punctuation">:</span> status_counter
        COMMENT<span class="token punctuation">:</span> Number of rows inserted</span></code></pre>
       </div>
      </li>
     </ol>
    </div>
   </div>
  </div>
  <br class="example-break"/>
 </div>
 <br/>
</div>
