Great - thanks all.
> On Dec 22, 2014, at 9:58 AM, Jon Robson <[email protected]> wrote: > > It's fine. Andrew fixed issues for me. I just had to switch > stat1003.wikimedia.org for stat1003.eqiad.wmnet :-) > >> On Mon, Dec 22, 2014 at 9:49 AM, Toby Negrin <[email protected]> wrote: >> 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
