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.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.
Table 21.8 INNODB_FT_CONFIG Columns
Column name | Description |
---|---|
KEY |
The name designating an item of metadata for an
InnoDB table containing a
FULLTEXT index. |
VALUE |
The value associated with the corresponding KEY
column, reflecting some limit or current value for an aspect
of a FULLTEXT index for an
InnoDB table. |
Example:
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG;
+---------------------------+-------------------+
| KEY | VALUE |
+---------------------------+-------------------+
| optimize_checkpoint_limit | 180 |
| synced_doc_id | 0 |
| stopword_table_name | test/my_stopwords |
| use_stopword | 1 |
+---------------------------+-------------------+
Notes:
This table is only intended for internal configuration. It is not intended for statistical information purposes.
Use
DESCRIBE
orSHOW 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 forInnoDB
full-text processing. The key values include:optimize_checkpoint_limit
: The number of seconds after which anOPTIMIZE TABLE
run will stop.synced_doc_id
: The nextDOC_ID
to be issued.stopword_table_name
: Thedatabase/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 theFULLTEXT
index is created.
For more information about
InnoDB
FULLTEXT
search, see Section 14.8.2.3, “InnoDB FULLTEXT Indexes”, and Section 12.9, “Full-Text Search Functions”.