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 <mpinchuk(a)wikimedia.org>
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 <nuria(a)wikimedia.org> 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 <springle(a)wikimedia.org>
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 <springle(a)wikimedia.org>
> 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
> Analytics(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/analytics
>