- 19.30 INFORMATION_SCHEMA Tables for InnoDB
- 19.30.1 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
- 19.30.2 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
- 19.30.3 The INFORMATION_SCHEMA INNODB_TRX Table
- 19.30.4 The INFORMATION_SCHEMA INNODB_LOCKS Table
- 19.30.5 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
- 19.30.6 The INFORMATION_SCHEMA INNODB_SYS_TABLES Table
- 19.30.7 The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table
- 19.30.8 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table
- 19.30.9 The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table
- 19.30.10 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table
- 19.30.11 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table
- 19.30.12 The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View
- 19.30.13 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
- 19.30.14 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
- 19.30.15 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
- 19.30.16 The INFORMATION_SCHEMA INNODB_METRICS Table
- 19.30.17 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
- 19.30.18 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
- 19.30.19 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
- 19.30.20 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
- 19.30.21 The INFORMATION_SCHEMA INNODB_FT_INSERTED Table
- 19.30.22 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
- 19.30.23 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 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 19.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
PROCESSprivilege to query this table.The values for the
KEYcolumn might evolve depending on the needs for performance tuning and debugging forInnoDBfull-text processing. Currently, the key values includeoptimize_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, andtable_state.For more information, see Section 12.9, “Full-Text Search Functions”.
User Comments
Add your own comment.