Adding mobile tech so they are aware, I am guessing we need to query for that data in a more efficient fashion.
On Mon, Dec 22, 2014 at 4:10 AM, Sean Pringle <[email protected]> wrote: > 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 > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
