Documentation Home
MySQL 9.1 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
Man Pages (TGZ) - 259.5Kb
Man Pages (Zip) - 366.7Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.1 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA InnoDB Tables  /  The INFORMATION_SCHEMA INNODB_FT_CONFIG Table

28.4.15 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table

TheINNODB_FT_CONFIG table provides metadata about theFULLTEXT index and associated processing for anInnoDB table.

This table is empty initially. Before querying it, set the value of theinnodb_ft_aux_table system variable to the name (including the database name) of the table that contains theFULLTEXT index (for example,test/articles).

For related usage information and examples, seeSection 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.

TheINNODB_FT_CONFIG table has these columns:

  • KEY

    The name designating an item of metadata for anInnoDB table containing aFULLTEXT index.

    The values for this column might change, depending on the needs for performance tuning and debugging forInnoDB full-text processing. The key names and their meanings include:

    • optimize_checkpoint_limit: The number of seconds after which anOPTIMIZE TABLE run stops.

    • synced_doc_id: The nextDOC_ID to be issued.

    • stopword_table_name: Thedatabase/table name for a user-defined stopword table. TheVALUE column is empty if there is no user-defined stopword table.

    • use_stopword: Indicates whether a stopword table is used, which is defined when theFULLTEXT index is created.

  • VALUE

    The value associated with the correspondingKEY column, reflecting some limit or current value for an aspect of aFULLTEXT index for anInnoDB 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