<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-innodb-ft-being-deleted-table">
      </a>
      28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045076972128">
  </a>
  <p>
   The
   <a class="link" href="information-schema-innodb-ft-being-deleted-table.html" title="28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">
    <code class="literal">
     INNODB_FT_BEING_DELETED
    </code>
   </a>
   table
      provides a snapshot of the
   <a class="link" href="information-schema-innodb-ft-deleted-table.html" title="28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">
    <code class="literal">
     INNODB_FT_DELETED
    </code>
   </a>
   table; it is used
      only during an
   <a class="link" href="optimize-table.html" title="15.7.3.4 OPTIMIZE TABLE Statement">
    <code class="literal">
     OPTIMIZE TABLE
    </code>
   </a>
   maintenance operation. When
   <a class="link" href="optimize-table.html" title="15.7.3.4 OPTIMIZE TABLE Statement">
    <code class="literal">
     OPTIMIZE
      TABLE
    </code>
   </a>
   is run, the
   <a class="link" href="information-schema-innodb-ft-being-deleted-table.html" title="28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">
    <code class="literal">
     INNODB_FT_BEING_DELETED
    </code>
   </a>
   table is
      emptied, and
   <code class="literal">
    DOC_ID
   </code>
   values are removed from the
   <a class="link" href="information-schema-innodb-ft-deleted-table.html" title="28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">
    <code class="literal">
     INNODB_FT_DELETED
    </code>
   </a>
   table. Because the
      contents of
   <a class="link" href="information-schema-innodb-ft-being-deleted-table.html" title="28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">
    <code class="literal">
     INNODB_FT_BEING_DELETED
    </code>
   </a>
   typically have a short lifetime, this table has limited utility
      for monitoring or debugging. For information about running
   <a class="link" href="optimize-table.html" title="15.7.3.4 OPTIMIZE TABLE Statement">
    <code class="literal">
     OPTIMIZE TABLE
    </code>
   </a>
   on tables with
   <code class="literal">
    FULLTEXT
   </code>
   indexes, see
   <a class="xref" href="fulltext-fine-tuning.html" title="14.9.6 Fine-Tuning MySQL Full-Text Search">
    Section 14.9.6, “Fine-Tuning MySQL Full-Text Search”
   </a>
   .
  </p>
  <p>
   This table is empty initially. Before querying it, set the value
      of the
   <a class="link" href="innodb-parameters.html#sysvar_innodb_ft_aux_table">
    <code class="literal">
     innodb_ft_aux_table
    </code>
   </a>
   system
      variable to the name (including the database name) of the table
      that contains the
   <code class="literal">
    FULLTEXT
   </code>
   index (for example,
   <code class="literal">
    test/articles
   </code>
   ). The output appears similar to
      the example provided for the
   <a class="link" href="information-schema-innodb-ft-deleted-table.html" title="28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">
    <code class="literal">
     INNODB_FT_DELETED
    </code>
   </a>
   table.
  </p>
  <p>
   For related usage information and examples, see
   <a class="xref" href="innodb-information-schema-fulltext_index-tables.html" title="17.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">
    Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="information-schema-innodb-ft-being-deleted-table.html" title="28.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">
    <code class="literal">
     INNODB_FT_BEING_DELETED
    </code>
   </a>
   table has
      these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       DOC_ID
      </code>
     </p>
     <p>
      The document ID of the row that is in the process of being
          deleted. This value might reflect the value of an ID column
          that you defined for the underlying table, or it can be a
          sequence value generated by
      <code class="literal">
       InnoDB
      </code>
      when the
          table contains no suitable column. This value is used when you
          perform text searches, to skip rows in the
      <a class="link" href="information-schema-innodb-ft-index-table-table.html" title="28.4.19 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table">
       <code class="literal">
        INNODB_FT_INDEX_TABLE
       </code>
      </a>
      table
          before data for deleted rows is physically removed from the
      <code class="literal">
       FULLTEXT
      </code>
      index by an
      <a class="link" href="optimize-table.html" title="15.7.3.4 OPTIMIZE TABLE Statement">
       <code class="literal">
        OPTIMIZE TABLE
       </code>
      </a>
      statement. For
          more information, see
      <a class="xref" href="fulltext-fine-tuning.html#fulltext-optimize" title="Optimizing InnoDB Full-Text Indexes">
       Optimizing InnoDB Full-Text Indexes
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045076942752">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Use the
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      <a class="link" href="information-schema-columns-table.html" title="28.3.8 The INFORMATION_SCHEMA COLUMNS Table">
       <code class="literal">
        COLUMNS
       </code>
      </a>
      table or the
      <a class="link" href="show-columns.html" title="15.7.7.6 SHOW COLUMNS Statement">
       <code class="literal">
        SHOW COLUMNS
       </code>
      </a>
      statement to view
          additional information about the columns of this table,
          including data types and default values.
     </p>
    </li>
    <li class="listitem">
     <p>
      You must have the
      <a class="link" href="privileges-provided.html#priv_process">
       <code class="literal">
        PROCESS
       </code>
      </a>
      privilege to query this table.
     </p>
    </li>
    <li class="listitem">
     <p>
      For more information about
      <code class="literal">
       InnoDB
      </code>
      <code class="literal">
       FULLTEXT
      </code>
      search, see
      <a class="xref" href="innodb-fulltext-index.html" title="17.6.2.4 InnoDB Full-Text Indexes">
       Section 17.6.2.4, “InnoDB Full-Text Indexes”
      </a>
      , and
      <a class="xref" href="fulltext-search.html" title="14.9 Full-Text Search Functions">
       Section 14.9, “Full-Text Search Functions”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
