Jon -- we made some changes to stat1003 logins; I believe you need to use the internal address now. I _thought_ we sent updated instructions to this list but I can't find it.
What specific issues are you having? -Toby On Mon, Dec 22, 2014 at 9:37 AM, Jon Robson <[email protected]> wrote: > https://phabricator.wikimedia.org/T76671 has been open for a while. We > are just not sure how to deal with it. > > I'm a bit confused why MobileWebDiffClickTracking is so big. It should > be tiny compared to the other tables. MobileWebClickTracking is the > nasty one. > > For some reason I'm having issues sshing into stat1003 to explore further. > > On Mon, Dec 22, 2014 at 9:33 AM, Dan Garry <[email protected]> wrote: > > There is over six months of data in MobileWebClickTracking_5929948. > Maryana, > > maybe the older data could be purged as well? That'd probably speed up > the > > queries. > > > > Dan > > > > On 22 December 2014 at 09:29, Maryana Pinchuk <[email protected]> > > wrote: > >> > >> Thanks for the heads up -- the MobileWebDiffClickTracking schema has > >> gotten way too big to query, it looks like. We'll figure out a way to > break > >> it up into more manageable chunks so it doesn't cause issues like this. > >> > >> > >> > >> On Dec 22, 2014, at 7:57 AM, Nuria Ruiz <[email protected]> wrote: > >> > >> 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 > >>> > >> > > > > > > > > -- > > Dan Garry > > Associate Product Manager, Mobile Apps > > Wikimedia Foundation > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
