… table without updating indexes took 18 seconds, and about the same time was spent on rebuilding the index using fast index creation. So we have 36 seconds in total which is about 1.7 times faster than updating indexes… impact on ALTER TABLE with the optimization disabled, and absolutely no effect on the optimized case, which resulted in an almost…
Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!
March 4, 2013 By 7 Comments
… we’ve sorted this out, let’s drop and rebuild our FT index on the InnoDB table and try the above queries… rows are completely different; the scores are zero, which means “no match.” This looks promising, so let’s explore further. Again… KEY to an InnoDB table, be prepared for a table rebuild. Calculation of match score is completely different between the two…
