The INFORMATION_SCHEMA INNODB_FT_INSERTED 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 18.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 PROCESS privilege to query this table.
• For more information, see , "Full-Text Search Functions".

Retornar