INNODB_FT_BEING_DELETED table is a snapshot
INNODB_FT_DELETED table that
is only used during an
TABLE maintenance operation. When
OPTIMIZE TABLE is run, the
INNODB_FT_BEING_DELETED table is emptied, and
DOC_IDs are removed from the
INNODB_FT_DELETED table. Because the
have a short lifetime, this table has limited utility for
monitoring or debugging. For information about running
OPTIMIZE TABLE on tables with
FULLTEXT indexes, see
Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”.
This table initially appears empty, until you set the value of the
innodb_ft_aux_table. The output
appears similar to the example output provided for the
For related usage information and examples, see Section 14.13.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.
Table 21.27 INNODB_FT_BEING_DELETED Columns
|The 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 |
You must have the
PROCESSprivilege to query this table.