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

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

Notes:

• This table initially appears empty, until you set the value of the configuration variable innodb_ft_aux_table.
  
  
• 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, last_optimized_word, deleted_doc_count, total_word_count, optimize_start_time, optimize_end_time, stopword_table_name, use_stopword, and table_state.
  
  
• For more information, see , "Full-Text Search Functions".
  
  

Retornar