On Mon, May 12, 2014 at 11:48 PM, Gilles Dubuc <[email protected]> wrote:
> It would be awesome if you could add a similar (wiki, timestamp) index for > exactly the same reasons to all the MultimediaViewerNetworkPerformance* > tables on the same database. Those tables haven't been problematic yet > because they're a lot smaller, but we might as well make all Multimedia > EventLogging queries faster in one swoop. > This is in progress, but is happening online to avoid replag so will probably take a couple days. I set pt-online-schema-change to simply index (wiki,timestamp) on all large log tables. There are other queries in the slow log that look like they might benefit.
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
