Hi All,
Currently, I use full-text search for my project with defined as FULLTEXT KEY keyword (keyword). If I search the new record withWHERE MATCH (keyword) AGAINST ('fox') then nothing response but using like query then data existed. The data only return with full-text search if I use OPTIMIZE TABLE search_table FLUSH; or I need waiting for some time later. So is this expected or may I did something wrong? And How long the data is re-indexed if I don’t use OPTIMIZE TABLE FLUSH command?
Many Thanks
Thanks for submitting your first question to the forums! 