- 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_SYS_DATAFILES Table
- 20.30.15 The INFORMATION_SCHEMA INNODB_SYS_TABLESPACES Table
- 20.30.16 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
- 20.30.17 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
- 20.30.18 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
- 20.30.19 The INFORMATION_SCHEMA INNODB_METRICS Table
- 20.30.20 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
- 20.30.21 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
- 20.30.22 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
- 20.30.23 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
- 20.30.24 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
- 20.30.25 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
The INNODB_FT_INDEX_TABLE table displays
information about the inverted index used to process text searches
against the FULLTEXT index of 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 20.21. INNODB_FT_INDEX_TABLE Columns
| Column name | Description |
|---|---|
WORD | A word extracted from the text of the columns that are part of a
FULLTEXT. |
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 row containing the word. 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. |
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.