Full-Text Index Maintenance

Index Maintenance

InnoDB updates full-text indexes lazily in the background. Force a sync with OPTIMIZE TABLE. Check pending updates with the INNODB_FT_BEING_DELETED table.

Example

-- Force index sync
OPTIMIZE TABLE articles;

-- Check FT index status
SET GLOBAL innodb_ft_aux_table = 'mydb/articles';
SELECT * FROM information_schema.INNODB_FT_INDEX_TABLE LIMIT 10;

SQL

Full Editor

Pro Tip

Run OPTIMIZE TABLE during low-traffic windows — it rebuilds the index.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned