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" <sprin...@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 >
_______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics