https://bugzilla.wikimedia.org/show_bug.cgi?id=45529
--- Comment #7 from Sean Pringle <[email protected]> --- While this is still in limbo, to keep production alive, last week I added this temporary index: KEY `tmp1` (`term_language`,`term_type`,`term_entity_type`,`term_search_key`) This query form (2 in comment #3) was backing up to the point of pain on slaves: /* Wikibase\TermSqlIndex::getMatchingIDs */ select distinct term_entity_id from `wb_terms` where (term_language=? and term_search_key like ? and term_type=? and term_entity_type=?) or (term_language=? and term_search_key like ? and term_type=? and term_entity_type=?) limit ? Most examples were identical. Perhaps something could be cached. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
