On Mon, May 12, 2014 at 11:48 PM, Gilles Dubuc gilles@wikimedia.org 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.