My Oracle Support Banner

How To Identify The Full Text Index Belongs To Which Table Based On File names FTS_*_*_INDEX_1.ibd (Doc ID 2674813.1)

Last updated on JUNE 02, 2020

Applies to:

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


To find out which table has the full text index based on the FTS_*_*_INDEX_1.ibd file name in the data directory.


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

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