21.30.25 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table

The INNODB_FT_BEING_DELETED table is a temporary work table while document IDs in the INNODB_FT_DELETED table are being removed from an InnoDB FULLTEXT index during an OPTIMIZE TABLE operation. Because its contents typically have a short lifetime, this table has limited utility for monitoring or debugging.

This table is only accessible to users with the SUPER privilege. This table initially appears empty, until you set the value of the configuration variable innodb_ft_aux_table.

Table 21.25 INNODB_FT_BEING_DELETED Columns

Column nameDescription
DOC_IDThe document ID of the row that is in the process of being deleted. 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. See Optimizing InnoDB Full-Text Indexes for more information.

Notes: