Geek asks and answers

How to keep MySQL constant index up to date?

Creating a MySQL Index

After I added the FULLTEXT index, how do I update it?

Added so: ALTER TABLE search_index ADD FULLTEXT(si_fulltext)

I tried updating it as follows:

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

Thanks Joe

+3
source share
2 answers

If you have not disabled the index, the server must update the index before the data in the column changes. If you want to examine what is in the index, you can use the utility myisam_ftdump:

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

+5
source

It updates automatically when data is inserted, updated or deleted. search_index.

+2
source

More articles:


All Articles