<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="innodb-information-schema-innodb_cmp">
      </a>
      17.15.1.1 INNODB_CMP and INNODB_CMP_RESET
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045151401648">
  </a>
  <a class="indexterm" name="idm46045151400256">
  </a>
  <p>
   The
   <a class="link" href="information-schema-innodb-cmp-table.html" title="28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">
    <code class="literal">
     INNODB_CMP
    </code>
   </a>
   and
   <a class="link" href="information-schema-innodb-cmp-table.html" title="28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">
    <code class="literal">
     INNODB_CMP_RESET
    </code>
   </a>
   tables provide
        status information about operations related to compressed
        tables, which are described in
   <a class="xref" href="innodb-compression.html" title="17.9 InnoDB Table and Page Compression">
    Section 17.9, “InnoDB Table and Page Compression”
   </a>
   . The
   <code class="literal">
    PAGE_SIZE
   </code>
   column reports the compressed
   <a class="link" href="glossary.html#glos_page_size" title="page size">
    page size
   </a>
   .
  </p>
  <p>
   These two tables have identical contents, but reading from
   <a class="link" href="information-schema-innodb-cmp-table.html" title="28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">
    <code class="literal">
     INNODB_CMP_RESET
    </code>
   </a>
   resets the
        statistics on compression and uncompression operations. For
        example, if you archive the output of
   <a class="link" href="information-schema-innodb-cmp-table.html" title="28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">
    <code class="literal">
     INNODB_CMP_RESET
    </code>
   </a>
   every 60 minutes,
        you see the statistics for each hourly period. If you monitor
        the output of
   <a class="link" href="information-schema-innodb-cmp-table.html" title="28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">
    <code class="literal">
     INNODB_CMP
    </code>
   </a>
   (making
        sure never to read
   <a class="link" href="information-schema-innodb-cmp-table.html" title="28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">
    <code class="literal">
     INNODB_CMP_RESET
    </code>
   </a>
   ), you see the
        cumulative statistics since InnoDB was started.
  </p>
  <p>
   For the table definition, see
   <a class="xref" href="information-schema-innodb-cmp-table.html" title="28.4.6 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">
    Section 28.4.6, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
