<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-innodb-ft-config-table">
      </a>
      28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045076930576">
  </a>
  <p>
   The
   <a class="link" href="information-schema-innodb-ft-config-table.html" title="28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table">
    <code class="literal">
     INNODB_FT_CONFIG
    </code>
   </a>
   table provides
      metadata about the
   <code class="literal">
    FULLTEXT
   </code>
   index and
      associated processing for an
   <code class="literal">
    InnoDB
   </code>
   table.
  </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-config-table.html" title="28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table">
    <code class="literal">
     INNODB_FT_CONFIG
    </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">
       KEY
      </code>
     </p>
     <p>
      The name designating an item of metadata for an
      <code class="literal">
       InnoDB
      </code>
      table containing a
      <code class="literal">
       FULLTEXT
      </code>
      index.
     </p>
     <p>
      The values for this column might change, depending on the
          needs for performance tuning and debugging for
      <code class="literal">
       InnoDB
      </code>
      full-text processing. The key names
          and their meanings include:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          optimize_checkpoint_limit
         </code>
         : The number
              of seconds after which an
         <a class="link" href="optimize-table.html" title="15.7.3.4 OPTIMIZE TABLE Statement">
          <code class="literal">
           OPTIMIZE
              TABLE
          </code>
         </a>
         run stops.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          synced_doc_id
         </code>
         : The next
         <code class="literal">
          DOC_ID
         </code>
         to be issued.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          stopword_table_name
         </code>
         : The
         <em class="replaceable">
          <code>
           database/table
          </code>
         </em>
         name for a
              user-defined stopword table. The
         <code class="literal">
          VALUE
         </code>
         column is empty if there is no user-defined stopword
              table.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          use_stopword
         </code>
         : Indicates whether a
              stopword table is used, which is defined when the
         <code class="literal">
          FULLTEXT
         </code>
         index is created.
        </p>
       </li>
      </ul>
     </div>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       VALUE
      </code>
     </p>
     <p>
      The value associated with the corresponding
      <code class="literal">
       KEY
      </code>
      column, reflecting some limit or
          current value for an aspect of a
      <code class="literal">
       FULLTEXT
      </code>
      index for an
      <code class="literal">
       InnoDB
      </code>
      table.
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045076899952">
   </a>
   Example
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa71628088"><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_CONFIG<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>
<span class="token output"><span class="token punctuation">|</span> KEY                       <span class="token punctuation">|</span> VALUE             <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>
<span class="token output"><span class="token punctuation">|</span> optimize_checkpoint_limit <span class="token punctuation">|</span> 180               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> synced_doc_id             <span class="token punctuation">|</span> 0                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> stopword_table_name       <span class="token punctuation">|</span> test/my_stopwords <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> use_stopword              <span class="token punctuation">|</span> 1                 <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></code></pre>
  </div>
  <h4>
   <a name="idm46045076897200">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      This table is intended only for internal configuration. It is
          not intended for statistical information purposes.
     </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>
      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>
