- 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_INSERTED table contains a list of
IDs for newly inserted rows, for an InnoDB
table with a FULLTEXT index. These IDs refer to
corresponding values within the
innodb_ft_index_table and
innodb_ft_index_cache tables. (When
you issue an OPTIMIZE TABLE
statement for the InnoDB table containing the
FULLTEXT index, the IDs are transferred from
the cache table to the table that represents the index.)
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.20. INNODB_FT_INSERTED Columns
| Column name | Description |
|---|---|
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. This value is used to look up rows in
the innodb_ft_index_cache table, when
you do text searches before the data is merged into the
FULLTEXT index by an
OPTIMIZE TABLE statement. |
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.