- 20.30 INFORMATION_SCHEMA Tables for InnoDB
- 20.30.1 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
- 20.30.2 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
- 20.30.3 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
- 20.30.4 The INFORMATION_SCHEMA INNODB_TRX Table
- 20.30.5 The INFORMATION_SCHEMA INNODB_LOCKS Table
- 20.30.6 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
- 20.30.7 The INFORMATION_SCHEMA INNODB_SYS_TABLES Table
- 20.30.8 The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table
- 20.30.9 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table
- 20.30.10 The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table
- 20.30.11 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table
- 20.30.12 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table
- 20.30.13 The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View
- 20.30.14 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
- 20.30.15 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
- 20.30.16 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
- 20.30.17 The INFORMATION_SCHEMA INNODB_METRICS Table
- 20.30.18 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
- 20.30.19 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
- 20.30.20 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
- 20.30.21 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
- 20.30.22 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
- 20.30.23 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
The INNODB_FT_INDEX_CACHE table displays token
information about newly inserted rows in a
FULLTEXT index for an InnoDB
table. To avoid expensive index reorganization during DML
operations for an InnoDB
FULLTEXT index, the information about newly
indexed words is stored separately, and combined with the main
search index only when you issue the OPTIMIZE
TABLE statement for the 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 20.20. INNODB_FT_INDEX_CACHE Columns
| Column name | Description |
|---|---|
WORD | A word extracted from the text of a newly inserted row. |
FIRST_DOC_ID | The first document ID that this word appears in in the
FULLTEXT index. |
LAST_DOC_ID | The last document ID that this word appears in in the
FULLTEXT index. |
DOC_COUNT | The number of rows this word appears in in the
FULLTEXT index. The same word can occur
several times within the cache table, once for each
combination of DOC_ID and
POSITION values. |
DOC_ID | The document ID of the newly inserted row. This value might reflect the
value of an ID column that you defined for the underlying
table, or it can be a sequence value generated by
InnoDB when the table does not contain
a suitable column. |
POSITION | The position of this particular instance of the word within the relevant
document identified by the DOC_ID
value. The value does not represent an absolute position;
it is an offset added to the POSITION
of the previous instance of that word. |
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.For more information, see Section 12.9, “Full-Text Search Functions”.
User Comments
Add your own comment.