Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
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 20.24. INNODB_FT_BEING_DELETED Columns
| Column name | Description |
|---|---|
DOC_ID |
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 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 TABLEstatement.
|
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 Section 12.9, "Full-Text Search Functions".