Information Schema INNODB_FT_BEING_DELETED Table

The Information Schema INNODB_FT_BEING_DELETED table is only used while document ID's in the related INNODB_FT_DELETED are being removed from an InnoDB fulltext index while an OPTIMIZE TABLE is underway. At all other times the table will be empty.

The SUPER privilege is required to view the table, and it also requires the 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.

Comments

Comments loading...

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ Information Schema InnoDB Tables ↑
Information Schema INNODB_BUFFER_PAGE Table
Information Schema INNODB_BUFFER_PAGE_LRU Table
Information Schema INNODB_BUFFER_POOL_PAGES Table
Information Schema INNODB_BUFFER_POOL_PAGES_BLOB Table
Information Schema INNODB_BUFFER_POOL_PAGES_INDEX Table
Information Schema INNODB_BUFFER_POOL_STATS Table
Information Schema INNODB_CHANGED_PAGES Table
Information Schema INNODB_CMP and INNODB_CMP_RESET Tables
Information Schema INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
Information Schema INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
Information Schema INNODB_FT_BEING_DELETED Table
Information Schema INNODB_FT_CONFIG Table
Information Schema INNODB_FT_DEFAULT_STOPWORD Table
Information Schema INNODB_FT_DELETED Table
Information Schema INNODB_FT_INDEX_CACHE Table
Information Schema INNODB_FT_INDEX_TABLE Table
Information Schema INNODB_LOCK_WAITS Table
Information Schema INNODB_LOCKS Table
Information Schema INNODB_METRICS Table
Information Schema INNODB_MUTEXES Table
Information Schema INNODB_SYS_COLUMNS Table
Information Schema INNODB_SYS_DATAFILES Table
Information Schema INNODB_SYS_FIELDS Table
Information Schema INNODB_SYS_FOREIGN Table
Information Schema INNODB_SYS_FOREIGN_COLS Table
Information Schema INNODB_SYS_INDEXES Table
Information Schema INNODB_SYS_SEMAPHORE_WAITS Table
Information Schema INNODB_SYS_TABLES Table
Information Schema INNODB_SYS_TABLESPACES Table
Information Schema INNODB_SYS_TABLESTATS Table
Information Schema INNODB_SYS_VIRTUAL Table
Information Schema INNODB_TABLESPACES_ENCRYPTION Table
Information Schema INNODB_TABLESPACES_SCRUBBING Table
Information Schema INNODB_TRX Table
Information Schema TEMP_TABLES_INFO Table

Information Schema INNODB_FT_BEING_DELETED Table

Comments

Products

Services

Pricing

Resources

About Us

Download MariaDB