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