<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="innodb-information-schema-system-tables">
      </a>
      17.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables
     </h3>
    </div>
   </div>
  </div>
  <p>
   You can extract metadata about schema objects managed by
   <code class="literal">
    InnoDB
   </code>
   using
   <code class="literal">
    InnoDB
   </code>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   tables. This information
      comes from the data dictionary. Traditionally, you would get this
      type of information using the techniques from
   <a class="xref" href="innodb-monitors.html" title="17.17 InnoDB Monitors">
    Section 17.17, “InnoDB Monitors”
   </a>
   , setting up
   <code class="literal">
    InnoDB
   </code>
   monitors and parsing the output from the
   <a class="link" href="show-engine.html" title="15.7.7.16 SHOW ENGINE Statement">
    <code class="literal">
     SHOW ENGINE INNODB
      STATUS
    </code>
   </a>
   statement. The
   <code class="literal">
    InnoDB
   </code>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   table interface allows you
      to query this data using SQL.
  </p>
  <p>
   <code class="literal">
    InnoDB
   </code>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   schema object tables include the tables listed here:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_DATAFILES
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_TABLESTATS
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_FOREIGN
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_COLUMNS
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_INDEXES
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_FIELDS
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_TABLESPACES
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_TABLESPACES_BRIEF
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_FOREIGN_COLS
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       INNODB_TABLES
      </code>
     </p>
    </li>
   </ul>
  </div>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-none"><div class="docs-select-all right" id="sa92279881"><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-none"></code></pre>
  </div>
  <p>
   The table names are indicative of the type of data provided:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-tables-table.html" title="28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table">
       <code class="literal">
        INNODB_TABLES
       </code>
      </a>
      provides metadata
          about
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-columns-table.html" title="28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table">
       <code class="literal">
        INNODB_COLUMNS
       </code>
      </a>
      provides metadata
          about
      <code class="literal">
       InnoDB
      </code>
      table columns.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-indexes-table.html" title="28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table">
       <code class="literal">
        INNODB_INDEXES
       </code>
      </a>
      provides metadata
          about
      <code class="literal">
       InnoDB
      </code>
      indexes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-fields-table.html" title="28.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table">
       <code class="literal">
        INNODB_FIELDS
       </code>
      </a>
      provides metadata
          about the key columns (fields) of
      <code class="literal">
       InnoDB
      </code>
      indexes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-tablestats-table.html" title="28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View">
       <code class="literal">
        INNODB_TABLESTATS
       </code>
      </a>
      provides a view
          of low-level status information about
      <code class="literal">
       InnoDB
      </code>
      tables that is derived from
          in-memory data structures.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-datafiles-table.html" title="28.4.10 The INFORMATION_SCHEMA INNODB_DATAFILES Table">
       <code class="literal">
        INNODB_DATAFILES
       </code>
      </a>
      provides data
          file path information for
      <code class="literal">
       InnoDB
      </code>
      file-per-table and general tablespaces.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-tablespaces-table.html" title="28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">
       <code class="literal">
        INNODB_TABLESPACES
       </code>
      </a>
      provides
          metadata about
      <code class="literal">
       InnoDB
      </code>
      file-per-table,
          general, and undo tablespaces.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-tablespaces-brief-table.html" title="28.4.25 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">
       <code class="literal">
        INNODB_TABLESPACES_BRIEF
       </code>
      </a>
      provides
          a subset of metadata about
      <code class="literal">
       InnoDB
      </code>
      tablespaces.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-foreign-table.html" title="28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table">
       <code class="literal">
        INNODB_FOREIGN
       </code>
      </a>
      provides metadata
          about foreign keys defined on
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-innodb-foreign-cols-table.html" title="28.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table">
       <code class="literal">
        INNODB_FOREIGN_COLS
       </code>
      </a>
      provides
          metadata about the columns of foreign keys that are defined on
      <code class="literal">
       InnoDB
      </code>
      tables.
     </p>
    </li>
   </ul>
  </div>
  <p>
   <code class="literal">
    InnoDB
   </code>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   schema object tables can be joined together through fields such as
   <code class="literal">
    TABLE_ID
   </code>
   ,
   <code class="literal">
    INDEX_ID
   </code>
   , and
   <code class="literal">
    SPACE
   </code>
   , allowing you to easily retrieve all
      available data for an object you want to study or monitor.
  </p>
  <p>
   Refer to the
   <code class="literal">
    InnoDB
   </code>
   <a class="link" href="innodb-information-schema-tables.html" title="28.4 INFORMATION_SCHEMA InnoDB Tables">
    INFORMATION_SCHEMA
   </a>
   documentation for information about the columns of each table.
  </p>
  <div class="example">
   <a name="innodb-information-schema-system-tables-example">
   </a>
   <p class="title">
    <b>
     Example 17.2 InnoDB INFORMATION_SCHEMA Schema Object Tables
    </b>
   </p>
   <div class="example-contents">
    <p>
     This example uses a simple table (
     <code class="literal">
      t1
     </code>
     ) with a
        single index (
     <code class="literal">
      i1
     </code>
     ) to demonstrate the type of
        metadata found in the
     <code class="literal">
      InnoDB
     </code>
     <code class="literal">
      INFORMATION_SCHEMA
     </code>
     schema object tables.
    </p>
    <div class="orderedlist">
     <ol class="orderedlist" type="1">
      <li class="listitem">
       <p>
        Create a test database and table
        <code class="literal">
         t1
        </code>
        :
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa70175881"><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">CREATE</span> <span class="token keyword">DATABASE</span> test<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">USE</span> test<span class="token punctuation">;</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>
       col1 <span class="token datatype">INT</span><span class="token punctuation">,</span>
       col2 <span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">10</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
       col3 <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">10</span><span class="token punctuation">)</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 prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">INDEX</span> i1 <span class="token keyword">ON</span> t1<span class="token punctuation">(</span>col1<span class="token punctuation">)</span><span class="token punctuation">;</span></code></pre>
       </div>
      </li>
      <li class="listitem">
       <p>
        After creating the table
        <code class="literal">
         t1
        </code>
        , query
        <a class="link" href="information-schema-innodb-tables-table.html" title="28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table">
         <code class="literal">
          INNODB_TABLES
         </code>
        </a>
        to locate the
            metadata for
        <code class="literal">
         test/t1
        </code>
        :
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa9048394"><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_TABLES <span class="token keyword">WHERE</span> <span class="token keyword">NAME</span><span class="token operator">=</span><span class="token string">'test/t1'</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>
     TABLE_ID<span class="token punctuation">:</span> 71
         NAME<span class="token punctuation">:</span> test/t1
         FLAG<span class="token punctuation">:</span> 1
       N_COLS<span class="token punctuation">:</span> 6
        SPACE<span class="token punctuation">:</span> 57
   ROW_FORMAT<span class="token punctuation">:</span> Compact
ZIP_PAGE_SIZE<span class="token punctuation">:</span> 0
 INSTANT_COLS<span class="token punctuation">:</span> 0</span></code></pre>
       </div>
       <p>
        Table
        <code class="literal">
         t1
        </code>
        has a
        <code class="literal">
         TABLE_ID
        </code>
        of 71. The
        <code class="literal">
         FLAG
        </code>
        field provides bit level information
            about table format and storage characteristics. There are
            six columns, three of which are hidden columns created by
        <code class="literal">
         InnoDB
        </code>
        (
        <code class="literal">
         DB_ROW_ID
        </code>
        ,
        <code class="literal">
         DB_TRX_ID
        </code>
        , and
        <code class="literal">
         DB_ROLL_PTR
        </code>
        ). The ID of the table's
        <code class="literal">
         SPACE
        </code>
        is 57 (a value of 0 would indicate
            that the table resides in the system tablespace). The
        <code class="literal">
         ROW_FORMAT
        </code>
        is Compact.
        <code class="literal">
         ZIP_PAGE_SIZE
        </code>
        only applies to tables with
            a
        <code class="literal">
         Compressed
        </code>
        row format.
        <code class="literal">
         INSTANT_COLS
        </code>
        shows number of columns in
            the table prior to adding the first instant column using
        <code class="literal">
         ALTER TABLE ... ADD
            COLUMN
        </code>
        with
        <code class="literal">
         ALGORITHM=INSTANT
        </code>
        .
       </p>
      </li>
      <li class="listitem">
       <p>
        Using the
        <code class="literal">
         TABLE_ID
        </code>
        information from
        <a class="link" href="information-schema-innodb-tables-table.html" title="28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table">
         <code class="literal">
          INNODB_TABLES
         </code>
        </a>
        , query the
        <a class="link" href="information-schema-innodb-columns-table.html" title="28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table">
         <code class="literal">
          INNODB_COLUMNS
         </code>
        </a>
        table for
            information about the table's columns.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa90810923"><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_COLUMNS <span class="token keyword">where</span> TABLE_ID <span class="token operator">=</span> <span class="token number">71</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>
     TABLE_ID<span class="token punctuation">:</span> 71
         NAME<span class="token punctuation">:</span> col1
          POS<span class="token punctuation">:</span> 0
        MTYPE<span class="token punctuation">:</span> 6
       PRTYPE<span class="token punctuation">:</span> 1027
          LEN<span class="token punctuation">:</span> 4
  HAS_DEFAULT<span class="token punctuation">:</span> 0
DEFAULT_VALUE<span class="token punctuation">:</span> NULL
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 2. 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>
     TABLE_ID<span class="token punctuation">:</span> 71
         NAME<span class="token punctuation">:</span> col2
          POS<span class="token punctuation">:</span> 1
        MTYPE<span class="token punctuation">:</span> 2
       PRTYPE<span class="token punctuation">:</span> 524542
          LEN<span class="token punctuation">:</span> 10
  HAS_DEFAULT<span class="token punctuation">:</span> 0
DEFAULT_VALUE<span class="token punctuation">:</span> NULL
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 3. 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>
     TABLE_ID<span class="token punctuation">:</span> 71
         NAME<span class="token punctuation">:</span> col3
          POS<span class="token punctuation">:</span> 2
        MTYPE<span class="token punctuation">:</span> 1
       PRTYPE<span class="token punctuation">:</span> 524303
          LEN<span class="token punctuation">:</span> 10
  HAS_DEFAULT<span class="token punctuation">:</span> 0
DEFAULT_VALUE<span class="token punctuation">:</span> NULL</span></code></pre>
       </div>
       <p>
        In addition to the
        <code class="literal">
         TABLE_ID
        </code>
        and column
        <code class="literal">
         NAME
        </code>
        ,
        <a class="link" href="information-schema-innodb-columns-table.html" title="28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table">
         <code class="literal">
          INNODB_COLUMNS
         </code>
        </a>
        provides the
            ordinal position (
        <code class="literal">
         POS
        </code>
        ) of each column
            (starting from 0 and incrementing sequentially), the column
        <code class="literal">
         MTYPE
        </code>
        or
        <span class="quote">
         “
         <span class="quote">
          main type
         </span>
         ”
        </span>
        (6 =
            INT, 2 = CHAR, 1 = VARCHAR), the
        <code class="literal">
         PRTYPE
        </code>
        or
        <span class="quote">
         “
         <span class="quote">
          precise type
         </span>
         ”
        </span>
        (a binary value with bits
            that represent the MySQL data type, character set code, and
            nullability), and the column length
            (
        <code class="literal">
         LEN
        </code>
        ). The
        <code class="literal">
         HAS_DEFAULT
        </code>
        and
        <code class="literal">
         DEFAULT_VALUE
        </code>
        columns only apply to
            columns added instantly using
        <code class="literal">
         ALTER TABLE ... ADD
            COLUMN
        </code>
        with
        <code class="literal">
         ALGORITHM=INSTANT
        </code>
        .
       </p>
      </li>
      <li class="listitem">
       <p>
        Using the
        <code class="literal">
         TABLE_ID
        </code>
        information from
        <a class="link" href="information-schema-innodb-tables-table.html" title="28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table">
         <code class="literal">
          INNODB_TABLES
         </code>
        </a>
        once again, query
        <a class="link" href="information-schema-innodb-indexes-table.html" title="28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table">
         <code class="literal">
          INNODB_INDEXES
         </code>
        </a>
        for information
            about the indexes associated with table
        <code class="literal">
         t1
        </code>
        .
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa8886539"><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_INDEXES <span class="token keyword">WHERE</span> TABLE_ID <span class="token operator">=</span> <span class="token number">71</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>
       INDEX_ID<span class="token punctuation">:</span> 111
           NAME<span class="token punctuation">:</span> GEN_CLUST_INDEX
       TABLE_ID<span class="token punctuation">:</span> 71
           TYPE<span class="token punctuation">:</span> 1
       N_FIELDS<span class="token punctuation">:</span> 0
        PAGE_NO<span class="token punctuation">:</span> 3
          SPACE<span class="token punctuation">:</span> 57
MERGE_THRESHOLD<span class="token punctuation">:</span> 50
<span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 2. 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>
       INDEX_ID<span class="token punctuation">:</span> 112
           NAME<span class="token punctuation">:</span> i1
       TABLE_ID<span class="token punctuation">:</span> 71
           TYPE<span class="token punctuation">:</span> 0
       N_FIELDS<span class="token punctuation">:</span> 1
        PAGE_NO<span class="token punctuation">:</span> 4
          SPACE<span class="token punctuation">:</span> 57
MERGE_THRESHOLD<span class="token punctuation">:</span> 50</span></code></pre>
       </div>
       <p>
        <a class="link" href="information-schema-innodb-indexes-table.html" title="28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table">
         <code class="literal">
          INNODB_INDEXES
         </code>
        </a>
        returns data for
            two indexes. The first index is
        <code class="literal">
         GEN_CLUST_INDEX
        </code>
        , which is a clustered
            index created by
        <code class="literal">
         InnoDB
        </code>
        if the table does
            not have a user-defined clustered index. The second index
            (
        <code class="literal">
         i1
        </code>
        ) is the user-defined secondary index.
       </p>
       <p>
        The
        <code class="literal">
         INDEX_ID
        </code>
        is an identifier for the
            index that is unique across all databases in an instance.
            The
        <code class="literal">
         TABLE_ID
        </code>
        identifies the table that
            the index is associated with. The index
        <code class="literal">
         TYPE
        </code>
        value indicates the type of index (1
            = Clustered Index, 0 = Secondary index). The
        <code class="literal">
         N_FILEDS
        </code>
        value is the number of fields
            that comprise the index.
        <code class="literal">
         PAGE_NO
        </code>
        is the
            root page number of the index B-tree, and
        <code class="literal">
         SPACE
        </code>
        is the ID of the tablespace where
            the index resides. A nonzero value indicates that the index
            does not reside in the system tablespace.
        <code class="literal">
         MERGE_THRESHOLD
        </code>
        defines a percentage
            threshold value for the amount of data in an index page. If
            the amount of data in an index page falls below the this
            value (the default is 50%) when a row is deleted or when a
            row is shortened by an update operation,
        <code class="literal">
         InnoDB
        </code>
        attempts to merge the index page
            with a neighboring index page.
       </p>
      </li>
      <li class="listitem">
       <p>
        Using the
        <code class="literal">
         INDEX_ID
        </code>
        information from
        <a class="link" href="information-schema-innodb-indexes-table.html" title="28.4.20 The INFORMATION_SCHEMA INNODB_INDEXES Table">
         <code class="literal">
          INNODB_INDEXES
         </code>
        </a>
        , query
        <a class="link" href="information-schema-innodb-fields-table.html" title="28.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table">
         <code class="literal">
          INNODB_FIELDS
         </code>
        </a>
        for information
            about the fields of index
        <code class="literal">
         i1
        </code>
        .
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa91521515"><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_FIELDS <span class="token keyword">where</span> INDEX_ID <span class="token operator">=</span> <span class="token number">112</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>
INDEX_ID<span class="token punctuation">:</span> 112
    NAME<span class="token punctuation">:</span> col1
     POS<span class="token punctuation">:</span> 0</span></code></pre>
       </div>
       <p>
        <a class="link" href="information-schema-innodb-fields-table.html" title="28.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table">
         <code class="literal">
          INNODB_FIELDS
         </code>
        </a>
        provides the
        <code class="literal">
         NAME
        </code>
        of the indexed field and its ordinal
            position within the index. If the index (i1) had been
            defined on multiple fields,
        <a class="link" href="information-schema-innodb-fields-table.html" title="28.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table">
         <code class="literal">
          INNODB_FIELDS
         </code>
        </a>
        would provide
            metadata for each of the indexed fields.
       </p>
      </li>
      <li class="listitem">
       <p>
        Using the
        <code class="literal">
         SPACE
        </code>
        information from
        <a class="link" href="information-schema-innodb-tables-table.html" title="28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table">
         <code class="literal">
          INNODB_TABLES
         </code>
        </a>
        , query
        <a class="link" href="information-schema-innodb-tablespaces-table.html" title="28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">
         <code class="literal">
          INNODB_TABLESPACES
         </code>
        </a>
        table for
            information about the table's tablespace.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa93238760"><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_TABLESPACES <span class="token keyword">WHERE</span> SPACE <span class="token operator">=</span> <span class="token number">57</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>
          SPACE<span class="token punctuation">:</span> 57
          NAME<span class="token punctuation">:</span> test/t1
          FLAG<span class="token punctuation">:</span> 16417
    ROW_FORMAT<span class="token punctuation">:</span> Dynamic
     PAGE_SIZE<span class="token punctuation">:</span> 16384
 ZIP_PAGE_SIZE<span class="token punctuation">:</span> 0
    SPACE_TYPE<span class="token punctuation">:</span> Single
 FS_BLOCK_SIZE<span class="token punctuation">:</span> 4096
     FILE_SIZE<span class="token punctuation">:</span> 114688
ALLOCATED_SIZE<span class="token punctuation">:</span> 98304
AUTOEXTEND_SIZE<span class="token punctuation">:</span> 0
SERVER_VERSION<span class="token punctuation">:</span> 8.4.0
 SPACE_VERSION<span class="token punctuation">:</span> 1
    ENCRYPTION<span class="token punctuation">:</span> N
         STATE<span class="token punctuation">:</span> normal</span></code></pre>
       </div>
       <p>
        In addition to the
        <code class="literal">
         SPACE
        </code>
        ID of the
            tablespace and the
        <code class="literal">
         NAME
        </code>
        of the associated
            table,
        <a class="link" href="information-schema-innodb-tablespaces-table.html" title="28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">
         <code class="literal">
          INNODB_TABLESPACES
         </code>
        </a>
        provides tablespace
        <code class="literal">
         FLAG
        </code>
        data, which is
            bit level information about tablespace format and storage
            characteristics. Also provided are tablespace
        <code class="literal">
         ROW_FORMAT
        </code>
        ,
        <code class="literal">
         PAGE_SIZE
        </code>
        ,
            and several other tablespace metadata items.
       </p>
      </li>
      <li class="listitem">
       <p>
        Using the
        <code class="literal">
         SPACE
        </code>
        information from
        <a class="link" href="information-schema-innodb-tables-table.html" title="28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table">
         <code class="literal">
          INNODB_TABLES
         </code>
        </a>
        once again, query
        <a class="link" href="information-schema-innodb-datafiles-table.html" title="28.4.10 The INFORMATION_SCHEMA INNODB_DATAFILES Table">
         <code class="literal">
          INNODB_DATAFILES
         </code>
        </a>
        for the
            location of the tablespace data file.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa87016474"><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_DATAFILES <span class="token keyword">WHERE</span> SPACE <span class="token operator">=</span> <span class="token number">57</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>
SPACE<span class="token punctuation">:</span> 57
 PATH<span class="token punctuation">:</span> ./test/t1.ibd</span></code></pre>
       </div>
       <p>
        The datafile is located in the
        <code class="literal">
         test
        </code>
        directory under MySQL's
        <code class="literal">
         data
        </code>
        directory.
            If a
        <a class="link" href="glossary.html#glos_file_per_table" title="file-per-table">
         file-per-table
        </a>
        tablespace were created in a location outside the MySQL data
            directory using the
        <code class="literal">
         DATA DIRECTORY
        </code>
        clause
            of the
        <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
         <code class="literal">
          CREATE TABLE
         </code>
        </a>
        statement, the tablespace
        <code class="literal">
         PATH
        </code>
        would be a
            fully qualified directory path.
       </p>
      </li>
      <li class="listitem">
       <p>
        As a final step, insert a row into table
        <code class="literal">
         t1
        </code>
        (
        <code class="literal">
         TABLE_ID = 71
        </code>
        ) and
            view the data in the
        <a class="link" href="information-schema-innodb-tablestats-table.html" title="28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View">
         <code class="literal">
          INNODB_TABLESTATS
         </code>
        </a>
        table. The
            data in this table is used by the MySQL optimizer to
            calculate which index to use when querying an
        <code class="literal">
         InnoDB
        </code>
        table. This information is derived
            from in-memory data structures.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa76122606"><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">5</span><span class="token punctuation">,</span> <span class="token string">'abc'</span><span class="token punctuation">,</span> <span class="token string">'def'</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output">Query OK, 1 row affected (0.06 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_TABLESTATS <span class="token keyword">where</span> TABLE_ID <span class="token operator">=</span> <span class="token number">71</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>
         TABLE_ID<span class="token punctuation">:</span> 71
             NAME<span class="token punctuation">:</span> test/t1
STATS_INITIALIZED<span class="token punctuation">:</span> Initialized
         NUM_ROWS<span class="token punctuation">:</span> 1
 CLUST_INDEX_SIZE<span class="token punctuation">:</span> 1
 OTHER_INDEX_SIZE<span class="token punctuation">:</span> 0
 MODIFIED_COUNTER<span class="token punctuation">:</span> 1
          AUTOINC<span class="token punctuation">:</span> 0
        REF_COUNT<span class="token punctuation">:</span> 1</span></code></pre>
       </div>
       <p>
        The
        <code class="literal">
         STATS_INITIALIZED
        </code>
        field indicates
            whether or not statistics have been collected for the table.
        <code class="literal">
         NUM_ROWS
        </code>
        is the current estimated number
            of rows in the table. The
        <code class="literal">
         CLUST_INDEX_SIZE
        </code>
        and
        <code class="literal">
         OTHER_INDEX_SIZE
        </code>
        fields report the number
            of pages on disk that store clustered and secondary indexes
            for the table, respectively. The
        <code class="literal">
         MODIFIED_COUNTER
        </code>
        value shows the number
            of rows modified by DML operations and cascade operations
            from foreign keys. The
        <code class="literal">
         AUTOINC
        </code>
        value is
            the next number to be issued for any autoincrement-based
            operation. There are no autoincrement columns defined on
            table
        <code class="literal">
         t1
        </code>
        , so the value is 0. The
        <code class="literal">
         REF_COUNT
        </code>
        value is a counter. When the
            counter reaches 0, it signifies that the table metadata can
            be evicted from the table cache.
       </p>
      </li>
     </ol>
    </div>
   </div>
  </div>
  <br class="example-break"/>
  <div class="example">
   <a name="innodb-information-schema-fk-system-tables-example">
   </a>
   <p class="title">
    <b>
     Example 17.3 Foreign Key INFORMATION_SCHEMA Schema Object Tables
    </b>
   </p>
   <div class="example-contents">
    <p>
     The
     <a class="link" href="information-schema-innodb-foreign-table.html" title="28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table">
      <code class="literal">
       INNODB_FOREIGN
      </code>
     </a>
     and
     <a class="link" href="information-schema-innodb-foreign-cols-table.html" title="28.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table">
      <code class="literal">
       INNODB_FOREIGN_COLS
      </code>
     </a>
     tables provide
        data about foreign key relationships. This example uses a parent
        table and child table with a foreign key relationship to
        demonstrate the data found in the
     <a class="link" href="information-schema-innodb-foreign-table.html" title="28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table">
      <code class="literal">
       INNODB_FOREIGN
      </code>
     </a>
     and
     <a class="link" href="information-schema-innodb-foreign-cols-table.html" title="28.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table">
      <code class="literal">
       INNODB_FOREIGN_COLS
      </code>
     </a>
     tables.
    </p>
    <div class="orderedlist">
     <ol class="orderedlist" type="1">
      <li class="listitem">
       <p>
        Create the test database with parent and child tables:
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa30544941"><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">CREATE</span> <span class="token keyword">DATABASE</span> test<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">USE</span> test<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> parent <span class="token punctuation">(</span>id <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
       <span class="token keyword">PRIMARY</span> <span class="token keyword">KEY</span> <span class="token punctuation">(</span>id<span class="token punctuation">)</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 prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> child <span class="token punctuation">(</span>id <span class="token datatype">INT</span><span class="token punctuation">,</span> parent_id <span class="token datatype">INT</span><span class="token punctuation">,</span>
<span class="token prompt">    -&gt;</span>     <span class="token keyword">INDEX</span> par_ind <span class="token punctuation">(</span>parent_id<span class="token punctuation">)</span><span class="token punctuation">,</span>
<span class="token prompt">    -&gt;</span>     <span class="token keyword">CONSTRAINT</span> fk1
<span class="token prompt">    -&gt;</span>     <span class="token keyword">FOREIGN</span> <span class="token keyword">KEY</span> <span class="token punctuation">(</span>parent_id<span class="token punctuation">)</span> <span class="token keyword">REFERENCES</span> parent<span class="token punctuation">(</span>id<span class="token punctuation">)</span>
<span class="token prompt">    -&gt;</span>     <span class="token keyword">ON</span> <span class="token keyword">DELETE</span> <span class="token keyword">CASCADE</span><span class="token punctuation">)</span> <span class="token keyword">ENGINE</span><span class="token operator">=</span>INNODB<span class="token punctuation">;</span></code></pre>
       </div>
      </li>
      <li class="listitem">
       <p>
        After the parent and child tables are created, query
        <a class="link" href="information-schema-innodb-foreign-table.html" title="28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table">
         <code class="literal">
          INNODB_FOREIGN
         </code>
        </a>
        and locate the
            foreign key data for the
        <code class="literal">
         test/child
        </code>
        and
        <code class="literal">
         test/parent
        </code>
        foreign key relationship:
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa11050637"><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_FOREIGN \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>
      ID<span class="token punctuation">:</span> test/fk1
FOR_NAME<span class="token punctuation">:</span> test/child
REF_NAME<span class="token punctuation">:</span> test/parent
  N_COLS<span class="token punctuation">:</span> 1
    TYPE<span class="token punctuation">:</span> 1</span></code></pre>
       </div>
       <p>
        Metadata includes the foreign key
        <code class="literal">
         ID
        </code>
        (
        <code class="literal">
         fk1
        </code>
        ), which is named for the
        <code class="literal">
         CONSTRAINT
        </code>
        that was defined on the child
            table. The
        <code class="literal">
         FOR_NAME
        </code>
        is the name of the
            child table where the foreign key is defined.
        <code class="literal">
         REF_NAME
        </code>
        is the name of the parent table
            (the
        <span class="quote">
         “
         <span class="quote">
          referenced
         </span>
         ”
        </span>
        table).
        <code class="literal">
         N_COLS
        </code>
        is the number of columns in the
            foreign key index.
        <code class="literal">
         TYPE
        </code>
        is a numerical
            value representing bit flags that provide additional
            information about the foreign key column. In this case, the
        <code class="literal">
         TYPE
        </code>
        value is 1, which indicates that the
        <code class="literal">
         ON DELETE CASCADE
        </code>
        option was specified
            for the foreign key. See the
        <a class="link" href="information-schema-innodb-foreign-table.html" title="28.4.12 The INFORMATION_SCHEMA INNODB_FOREIGN Table">
         <code class="literal">
          INNODB_FOREIGN
         </code>
        </a>
        table definition
            for more information about
        <code class="literal">
         TYPE
        </code>
        values.
       </p>
      </li>
      <li class="listitem">
       <p>
        Using the foreign key
        <code class="literal">
         ID
        </code>
        , query
        <a class="link" href="information-schema-innodb-foreign-cols-table.html" title="28.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table">
         <code class="literal">
          INNODB_FOREIGN_COLS
         </code>
        </a>
        to view
            data about the columns of the foreign key.
       </p>
       <div class="copytoclipboard-wrapper">
        <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa77390249"><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_FOREIGN_COLS <span class="token keyword">WHERE</span> ID <span class="token operator">=</span> <span class="token string">'test/fk1'</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>
          ID<span class="token punctuation">:</span> test/fk1
FOR_COL_NAME<span class="token punctuation">:</span> parent_id
REF_COL_NAME<span class="token punctuation">:</span> id
         POS<span class="token punctuation">:</span> 0</span></code></pre>
       </div>
       <p>
        <code class="literal">
         FOR_COL_NAME
        </code>
        is the name of the foreign
            key column in the child table, and
        <code class="literal">
         REF_COL_NAME
        </code>
        is the name of the
            referenced column in the parent table. The
        <code class="literal">
         POS
        </code>
        value is the ordinal position of the
            key field within the foreign key index, starting at zero.
       </p>
      </li>
     </ol>
    </div>
   </div>
  </div>
  <br class="example-break"/>
  <div class="example">
   <a name="innodb-information-schema-system-tables-join-example">
   </a>
   <p class="title">
    <b>
     Example 17.4 Joining InnoDB INFORMATION_SCHEMA Schema Object Tables
    </b>
   </p>
   <div class="example-contents">
    <p>
     This example demonstrates joining three
     <code class="literal">
      InnoDB
     </code>
     <code class="literal">
      INFORMATION_SCHEMA
     </code>
     schema object tables
        (
     <a class="link" href="information-schema-innodb-tables-table.html" title="28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table">
      <code class="literal">
       INNODB_TABLES
      </code>
     </a>
     ,
     <a class="link" href="information-schema-innodb-tablespaces-table.html" title="28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">
      <code class="literal">
       INNODB_TABLESPACES
      </code>
     </a>
     , and
     <a class="link" href="information-schema-innodb-tablestats-table.html" title="28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View">
      <code class="literal">
       INNODB_TABLESTATS
      </code>
     </a>
     ) to gather file
        format, row format, page size, and index size information about
        tables in the employees sample database.
    </p>
    <p>
     The following table aliases are used to shorten the query
        string:
    </p>
    <div class="itemizedlist">
     <ul class="itemizedlist" style="list-style-type: disc; ">
      <li class="listitem">
       <p>
        <a class="link" href="information-schema-innodb-tables-table.html" title="28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table">
         <code class="literal">
          INFORMATION_SCHEMA.INNODB_TABLES
         </code>
        </a>
        :
            a
       </p>
      </li>
      <li class="listitem">
       <p>
        <a class="link" href="information-schema-innodb-tablespaces-table.html" title="28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">
         <code class="literal">
          INFORMATION_SCHEMA.INNODB_TABLESPACES
         </code>
        </a>
        :
            b
       </p>
      </li>
      <li class="listitem">
       <p>
        <a class="link" href="information-schema-innodb-tablestats-table.html" title="28.4.26 The INFORMATION_SCHEMA INNODB_TABLESTATS View">
         <code class="literal">
          INFORMATION_SCHEMA.INNODB_TABLESTATS
         </code>
        </a>
        :
            c
       </p>
      </li>
     </ul>
    </div>
    <p>
     An
     <a class="link" href="flow-control-functions.html#function_if">
      <code class="literal">
       IF()
      </code>
     </a>
     control flow function is
        used to account for compressed tables. If a table is compressed,
        the index size is calculated using
     <code class="literal">
      ZIP_PAGE_SIZE
     </code>
     rather than
     <code class="literal">
      PAGE_SIZE
     </code>
     .
     <code class="literal">
      CLUST_INDEX_SIZE
     </code>
     and
     <code class="literal">
      OTHER_INDEX_SIZE
     </code>
     , which are reported in
        bytes, are divided by
     <code class="literal">
      1024*1024
     </code>
     to provide
        index sizes in megabytes (MBs). MB values are rounded to zero
        decimal spaces using the
     <a class="link" href="mathematical-functions.html#function_round">
      <code class="literal">
       ROUND()
      </code>
     </a>
     function.
    </p>
    <div class="copytoclipboard-wrapper">
     <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa29549940"><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> a<span class="token punctuation">.</span><span class="token keyword">NAME</span><span class="token punctuation">,</span> a<span class="token punctuation">.</span><span class="token keyword">ROW_FORMAT</span><span class="token punctuation">,</span>
        <span class="token variable">@page_size</span> <span class="token operator">:=</span>
         <span class="token function">IF</span><span class="token punctuation">(</span>a<span class="token punctuation">.</span><span class="token keyword">ROW_FORMAT</span><span class="token operator">=</span><span class="token string">'Compressed'</span><span class="token punctuation">,</span>
          b<span class="token punctuation">.</span>ZIP_PAGE_SIZE<span class="token punctuation">,</span> b<span class="token punctuation">.</span>PAGE_SIZE<span class="token punctuation">)</span>
          <span class="token keyword">AS</span> page_size<span class="token punctuation">,</span>
         <span class="token function">ROUND</span><span class="token punctuation">(</span><span class="token punctuation">(</span><span class="token variable">@page_size</span> <span class="token operator">*</span> c<span class="token punctuation">.</span>CLUST_INDEX_SIZE<span class="token punctuation">)</span>
          <span class="token operator">/</span><span class="token punctuation">(</span><span class="token number">1024</span><span class="token operator">*</span><span class="token number">1024</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token keyword">AS</span> pk_mb<span class="token punctuation">,</span>
         <span class="token function">ROUND</span><span class="token punctuation">(</span><span class="token punctuation">(</span><span class="token variable">@page_size</span> <span class="token operator">*</span> c<span class="token punctuation">.</span>OTHER_INDEX_SIZE<span class="token punctuation">)</span>
          <span class="token operator">/</span><span class="token punctuation">(</span><span class="token number">1024</span><span class="token operator">*</span><span class="token number">1024</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token keyword">AS</span> secidx_mb
       <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_TABLES a
       <span class="token keyword">INNER</span> <span class="token keyword">JOIN</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_TABLESPACES b <span class="token keyword">on</span> a<span class="token punctuation">.</span><span class="token keyword">NAME</span> <span class="token operator">=</span> b<span class="token punctuation">.</span><span class="token keyword">NAME</span>
       <span class="token keyword">INNER</span> <span class="token keyword">JOIN</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_TABLESTATS c <span class="token keyword">on</span> b<span class="token punctuation">.</span><span class="token keyword">NAME</span> <span class="token operator">=</span> c<span class="token punctuation">.</span><span class="token keyword">NAME</span>
       <span class="token keyword">WHERE</span> a<span class="token punctuation">.</span><span class="token keyword">NAME</span> <span class="token operator">LIKE</span> <span class="token string">'employees/%'</span>
       <span class="token keyword">ORDER</span> <span class="token keyword">BY</span> a<span class="token punctuation">.</span><span class="token keyword">NAME</span> <span class="token keyword">DESC</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>
<span class="token output"><span class="token punctuation">|</span> NAME                   <span class="token punctuation">|</span> ROW_FORMAT <span class="token punctuation">|</span> page_size <span class="token punctuation">|</span> pk_mb <span class="token punctuation">|</span> secidx_mb <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>
<span class="token output"><span class="token punctuation">|</span> employees/titles       <span class="token punctuation">|</span> Dynamic    <span class="token punctuation">|</span>     16384 <span class="token punctuation">|</span>    20 <span class="token punctuation">|</span>        11 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> employees/salaries     <span class="token punctuation">|</span> Dynamic    <span class="token punctuation">|</span>     16384 <span class="token punctuation">|</span>    93 <span class="token punctuation">|</span>        34 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> employees/employees    <span class="token punctuation">|</span> Dynamic    <span class="token punctuation">|</span>     16384 <span class="token punctuation">|</span>    15 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> employees/dept_manager <span class="token punctuation">|</span> Dynamic    <span class="token punctuation">|</span>     16384 <span class="token punctuation">|</span>     0 <span class="token punctuation">|</span>         0 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> employees/dept_emp     <span class="token punctuation">|</span> Dynamic    <span class="token punctuation">|</span>     16384 <span class="token punctuation">|</span>    12 <span class="token punctuation">|</span>        10 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> employees/departments  <span class="token punctuation">|</span> Dynamic    <span class="token punctuation">|</span>     16384 <span class="token punctuation">|</span>     0 <span class="token punctuation">|</span>         0 <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></code></pre>
    </div>
   </div>
  </div>
  <br class="example-break"/>
 </div>
 <br/>
</div>
