<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="innodb-information-schema">
      </a>
      17.15 InnoDB INFORMATION_SCHEMA Tables
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="innodb-information-schema-compression-tables.html">
       17.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-transactions.html">
       17.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-system-tables.html">
       17.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-fulltext_index-tables.html">
       17.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-buffer-pool-tables.html">
       17.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-metrics-table.html">
       17.15.6 InnoDB INFORMATION_SCHEMA Metrics Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-temp-table-info.html">
       17.15.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="innodb-information-schema-files-table.html">
       17.15.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045151425536">
  </a>
  <p>
   This section provides information and usage examples for
   <code class="literal">
    InnoDB
   </code>
   <a class="link" href="information-schema.html" title="Chapter 28 INFORMATION_SCHEMA Tables">
    <code class="literal">
     INFORMATION_SCHEMA
    </code>
   </a>
   tables.
  </p>
  <p>
   <code class="literal">
    InnoDB
   </code>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   tables provide metadata, status information, and statistics about
    various aspects of the
   <code class="literal">
    InnoDB
   </code>
   storage engine. You
    can view a list of
   <code class="literal">
    InnoDB
   </code>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   tables by issuing a
   <a class="link" href="show-tables.html" title="15.7.7.39 SHOW TABLES Statement">
    <code class="literal">
     SHOW TABLES
    </code>
   </a>
   statement on the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   database:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa80592752"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">TABLES</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA <span class="token operator">LIKE</span> <span class="token string">'INNODB%'</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   For table definitions, see
   <a class="xref" href="innodb-information-schema-tables.html" title="28.4 INFORMATION_SCHEMA InnoDB Tables">
    Section 28.4, “INFORMATION_SCHEMA InnoDB Tables”
   </a>
   . For general
    information regarding the
   <code class="literal">
    MySQL
   </code>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   database, see
   <a class="xref" href="information-schema.html" title="Chapter 28 INFORMATION_SCHEMA Tables">
    Chapter 28,
    <i>
     INFORMATION_SCHEMA Tables
    </i>
   </a>
   .
  </p>
 </div>
 <br/>
</div>
