Ever since its first release, we are continuing consolidating and developing InnoDB Full-Text Search feature. There is one recent improvement that worth blogging about. It is an effort with MySQL Optimizer team that simplifies some common queries’ Query Plans and dramatically shorted the query time. I will describe the issue, our solution and the end result by some performance numbers to demonstrate our efforts in continuing enhancement the Full-Text Search capability.
The Issue:
As we had discussed in previous Blogs, InnoDB implements
Full-Text index as reversed auxiliary tables. The query once
parsed will be reinterpreted into several queries into related
auxiliary tables and then results are merged and consolidated to
come up with the final result. So at the end of the query, we’ll
have all matching records on hand, sorted by their ranking or by
their Doc IDs.
Unfortunately, MySQL’s optimizer and …
[Read more]