Hi Sean, On Thu, Mar 5, 2015 at 9:59 PM, Sean Pringle <sprin...@wikimedia.org> wrote:
> Hi Leila > > On Fri, Mar 6, 2015 at 1:38 AM, Leila Zia <le...@wikimedia.org> wrote: > > Hi Sean, > > > > Thanks for the email. The two create queries are mine. Should I kill > one? > > Lag has now reached 24h for s1 and s6, plus I found a few other > 'research' user connections apparently fully blocked waiting on > staging metadata, so I've killed your queries. > Thanks for letting me know. > I recommend building tables like that using batched inserts, so both > replication and other people can co-exist with you :-) Super large > write-transactions running for more than an hour or two are never a > good idea. > makes sense. will follow your advice. Leila > > BR > Sean > > _______________________________________________ > Analytics mailing list > Analytics@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/analytics >
_______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics