Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  The INFORMATION_SCHEMA INNODB_FT_CONFIG Table


The INNODB_FT_CONFIG table displays metadata about the FULLTEXT index and associated processing for an InnoDB table.

Before you query this table, set the configuration variable innodb_ft_aux_table to the name (including the database name) of the table that contains the FULLTEXT index, for example test/articles.

For related usage information and examples, see Section 14.12.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.

Table 20.23 INNODB_FT_CONFIG Columns

Column nameDescription
KEYThe name designating an item of metadata for an InnoDB table containing a FULLTEXT index.
VALUEThe value associated with the corresponding KEY column, reflecting some limit or current value for an aspect of a FULLTEXT index for an InnoDB table.


| KEY                       | VALUE             |
| optimize_checkpoint_limit | 180               |
| synced_doc_id             | 0                 |
| stopword_table_name       | test/my_stopwords |
| use_stopword              | 1                 |


  • This table is only intended for internal configuration. It is not intended for statistical information purposes.

  • Use DESCRIBE or SHOW COLUMNS to view additional information about the columns of this table including data types and default values.

  • You must have the PROCESS privilege to query this table.

  • The values for the KEY column might evolve depending on the needs for performance tuning and debugging for InnoDB full-text processing. The key values include:

    • optimize_checkpoint_limit: The number of seconds after which an OPTIMIZE TABLE run will stop.

    • synced_doc_id: The next DOC_ID to be issued.

    • stopword_table_name: The database/table name for a user defined stopword table. This field appears empty if there is no user-defined stopword table.

    • use_stopword: Indicates whether or not a stopword table is used, which is defined when the FULLTEXT index is created.

  • For more information about InnoDB FULLTEXT search, see Section, “InnoDB FULLTEXT Indexes”, and Section 12.9, “Full-Text Search Functions”.

Download this Manual
User Comments
Sign Up Login You must be logged in to post a comment.