https://bugzilla.wikimedia.org/show_bug.cgi?id=68396
--- Comment #2 from Sean Pringle <[email protected]> --- The eventlogging slaves (analytics-store and s1-analytics-slave) already have indexes on (wiki, timestamp) for all tables, plus the optimizer chooses to automatically index the derived tables generated by the subqueries. The result isn't terrible: ~4m for wiki = 'enwiki' and ~1m for dewiki. How frequently will the queries run? -- 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
