provides a snapshot of the
INNODB_FT_DELETED table; it is used
only during an
maintenance operation. When
TABLE is run, the
INNODB_FT_BEING_DELETED table is
DOC_ID values are removed from the
INNODB_FT_DELETED table. Because the
typically 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 is empty initially. Before querying it, set the value
variable to the name (including the database name) of the table
that contains the
FULLTEXT index; for example
test/articles. The output appears similar to
the example provided for the
For related usage information and examples, see Section 14.16.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.
INNODB_FT_BEING_DELETED table has
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
InnoDBwhen the table contains no suitable column. This value is used when you do text searches, to skip rows in the
INNODB_FT_INDEX_TABLEtable before data for deleted rows is physically removed from the
FULLTEXTindex by an
OPTIMIZE TABLEstatement. For more information, see Optimizing InnoDB Full-Text Indexes.
You must have the
PROCESSprivilege to query this table.
COLUMNStable or the
SHOW COLUMNSstatement to view additional information about the columns of this table, including data types and default values.
For more information about
FULLTEXTsearch, see Section 18.104.22.168, “InnoDB Full-Text Indexes”, and Section 12.9, “Full-Text Search Functions”.