How do I keep a MySQL Fulltext Index up to date?

Question

Creating an index MySQL

After I have added the FULLTEXT index, how do I keep it up to date?

Added it this way : ALTER TABLE search_index ADD FULLTEXT(si_fulltext)

Tried to update it like this :

ALTER TABLE search_index MODIFY FULLTEXT(si_fulltext)
ALTER TABLE search_index CHANGE FULLTEXT(si_fulltext)

Thanks, Joe

score 5 · Accepted Answer · answered Jun 16 '11 at 19:01

5

Unless you disabled the index, the server should be keeping the index up to date as data changes in the column. If you'd like to explore what is in the index, you can use the myisam_ftdump utility:

http://dev.mysql.com/doc/refman/5.0/en/myisam-ftdump.html

answered Jun 16 '11 at 19:01

AJ.

27,586
18
84
94

Hi! sorry for the necro, but what do you mean by "as data changes in the column"? Does this include manual changes? like deleting a certain row and import a new one. – Roi Nov 06 '15 at 07:40

score 2 · Answer 2 · answered Jun 16 '11 at 18:59

2

It's updated automatically whenever data is inserted, updated or deleted form search_index.

answered Jun 16 '11 at 18:59

searlea

8,173
4
34
37

How do I keep a MySQL Fulltext Index up to date?

2 Answers2