<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-innodb-ft-deleted-table">
      </a>
      28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045076852832">
  </a>
  <p>
   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 stores
      rows that are deleted from the
   <code class="literal">
    FULLTEXT
   </code>
   index
      for an
   <code class="literal">
    InnoDB
   </code>
   table. To avoid expensive index
      reorganization during DML operations for an
   <code class="literal">
    InnoDB
   </code>
   <code class="literal">
    FULLTEXT
   </code>
   index, the
      information about newly deleted words is stored separately,
      filtered out of search results when you do a text search, and
      removed from the main search index only when you issue 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 the
   <code class="literal">
    InnoDB
   </code>
   table. 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>
  <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>
   ).
  </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-deleted-table.html" title="28.4.17 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">
    <code class="literal">
     INNODB_FT_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 newly deleted row. 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="idm46045076830240">
   </a>
   Example
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa1218571"><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_FT_DELETED<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>
<span class="token output"><span class="token punctuation">|</span> DOC_ID <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>
<span class="token output"><span class="token punctuation">|</span>      6 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>      7 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>      8 <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></code></pre>
  </div>
  <h4>
   <a name="idm46045076827808">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <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>
      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>
      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>
