Hi Sean,
Thanks for the email. The two create queries are mine. Should I kill one?
Leila On Mar 5, 2015 7:09 AM, "Sean Pringle" springle@wikimedia.org wrote:
Just a heads-up:
Analytics-store is seeing several hours of replag on s1, s4, and s6.
s4 is me doing a commonswiki schema change, which should be done shortly. s1 and s6 are lagging due to load from queries like:
create table staging.enwiki_intra select a.pl_from as page_id_from, a.pl_title as page_title_to, b.page_id as page_id_to from enwiki.pagelinks a left join enwiki.page b on a.pl_title=b.page_title where a.pl_namespace=0 and a.pl_from_namespace=0;
Some very large cross joins there. No doubt it's intended activity. And if not, now at least you know what's happening ;-)
BR Sean
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics