https://bugzilla.wikimedia.org/show_bug.cgi?id=53577
--- Comment #13 from Sean Pringle <sprin...@wikimedia.org> --- Much better than it was. I'm now trialing partitioned logging tables on one slave per production shard and directing these queries to those boxes. Since most of the queries use log_user = N, partitioning on key(log_user) allows the optimizer to use partition pruning. Still have to track down and sort out the ones without log_user = N. They're infrequent and low priority. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l