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.
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