# Information Schema INNODB\_FT\_BEING\_DELETED Table

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `INNODB_FT_BEING_DELETED` table is only used while document ID's in the related [INNODB\_FT\_DELETED](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables/information-schema-innodb_ft_deleted-table) are being removed from an InnoDB [fulltext index](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/full-text-indexes) while an [OPTIMIZE TABLE](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizing-tables/optimize-table) is underway. At all other times the table will be empty.

The `SUPER` [privilege](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant) is required to view the table, and it also requires the [innodb\_ft\_aux\_table](https://mariadb.com/docs/server/server-usage/storage-engines/innodb/innodb-system-variables#innodb_ft_aux_table) system variable to be set.

It has the following column:

| Column  | Description                                                                                                                              |
| ------- | ---------------------------------------------------------------------------------------------------------------------------------------- |
| DOC\_ID | Document ID of the row being deleted. Either an underlying ID value, or a sequence value generated by InnoDB if no usable option exists. |

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}