--- Comment #13 from Sean Pringle <sprin...@wikimedia.org> ---
FTR, correction for my comment #10: I said:
"Note that I left term_language in terms_search despite the partitions because
getMatchingIDs query still benefits from ICP when term_search_key is used with
a poorly performing short prefix: LIKE 'a%'."
This is actually wrong for MariaDB 5.5. ICP is not being used inside the
partition (though it apparently will be possible in the future). Looks like the
speed-up for getMatchingIDs here is only due to the pruning and the smaller
partitioned indexes generating fewer Handler_read% hits.
You are receiving this mail because:
You are on the CC list for the bug.
Wikibugs-l mailing list