Hi Leila On Fri, Mar 6, 2015 at 1:38 AM, Leila Zia <[email protected]> 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. 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. BR Sean _______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
