Had to kill queries, lest analytics-store grind to a halt and take even longer to recover.
These ones: https://gerrit.wikimedia.org/r/#/c/178381/ On Sun, Dec 21, 2014 at 8:09 PM, Sean Pringle <[email protected]> wrote: > > This last few days analytics-store replication has started to lag by some > hours. Currently s1 (enwiki) and s5 (dewiki, wikidatawiki) are most > affected. Eventlogging is not lagging, due to the nicely batched writes it > does now-a-days :-) > > There are many slow queries running from the research user on stat1003, > referencing eventlogging tables like MobileWebDiffClickTracking*. > > I'm not sure who belongs to them, or if they're new, or if they're safe to > kill, so this is mainly a heads-up email. Let us know if ops should kill > stuff to let the box catch up again. > > BR > Sean > -- > DBA @ WMF > -- DBA @ WMF
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
