My Oracle Support Banner

How To Remove Common Index Tables After Dropping All Full-text Indexes Of An InnoDB Table (Doc ID 2995571.1)

Last updated on JANUARY 16, 2024

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Goal

Common index tables (fts_*_deleted and fts_*_deleted_cachefts_*_being_deleted and fts_*_being_deleted_cachefts_*_config) are used for deletion handling and storing the internal state of full-text indexes. Unlike the auxiliary index tables, which are created for each full-text index, this set of tables is common to all full-text indexes created on a particular table.

Common index tables are retained even if all full-text indexes of an InnoDB table are dropped.

How can I remove common index tables after dropping all full-text indexes?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.