Skip navigation links
MySQL 5.6 Reference Manual :: 20 INFORMATION_SCHEMA Tables :: 20.30 INFORMATION_SCHEMA Tables for InnoDB :: 20.30.20 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
20.30.21 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table »
Section Navigation      [Toggle]

20.30.20 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.

This table is only accessible to users with the SUPER privilege.

Table 20.19 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.

Notes:

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

  • 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. Currently, the key values include optimize_checkpoint_limit, synced_doc_id, deleted_doc_count, stopword_table_name, and use_stopword.

  • For more information, see Section 12.9, “Full-Text Search Functions”.

Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices