Hi Sean,

On Thu, Mar 5, 2015 at 9:59 PM, Sean Pringle <springle@wikimedia.org> wrote:
Hi Leila

On Fri, Mar 6, 2015 at 1:38 AM, Leila Zia <leila@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