<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="innodb-information-schema-compression-tables">
      </a>
      17.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="innodb-information-schema-innodb_cmp.html">
       17.15.1.1 INNODB_CMP and INNODB_CMP_RESET
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-innodb_cmpmem.html">
       17.15.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-examples-compression-sect.html">
       17.15.1.3 Using the Compression Information Schema Tables
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045151411840">
  </a>
  <p>
   There are two pairs of
   <code class="literal">
    InnoDB
   </code>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   tables about compression
      that can provide insight into how well compression is working
      overall:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <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>
      provide
          information about the number of compression operations and the
          amount of time spent performing compression.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-cmpmem-table.html" title="28.4.7 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables">
       <code class="literal">
        INNODB_CMPMEM
       </code>
      </a>
      and
      <a class="link" href="information-schema-innodb-cmpmem-table.html" title="28.4.7 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables">
       <code class="literal">
        INNODB_CMPMEM_RESET
       </code>
      </a>
      provide
          information about the way memory is allocated for compression.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
