- 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_DELETED table records rows that
are deleted from the FULLTEXT index for an
InnoDB table. To avoid expensive index
reorganization during DML operations for an
InnoDB FULLTEXT index, the
information about newly deleted words is stored separately,
filtered out of search results when you do a text search, and
removed from 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 19.21. INNODB_FT_DELETED Columns
| Column name | Description |
|---|---|
DOC_ID |
The document ID of the newly deleted 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 skip rows in the
innodb_ft_index_table table, when you
do text searches before data for deleted rows is
physically removed from 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.