This might be me.  Killing the query I'm worried about.   I'll report back. 

On Tue, Jul 29, 2014 at 5:46 PM, Christian Aistleitner <> wrote:

just a quick heads up that the replication lag on
analytics-store.eqiad.wmnet (aka “The one machine to rule them all”)
has risen to >12 hours for s1 replicas. Other replicas are fine.

So on analytics-store.eqiad.wmnet:
* enwiki is affected.
* log (EventLogging) is affected.

Other databases (like dewiki, eswiki, ...) on
analytics-store.eqiad.wmnet are /not/ affected.

For queries that only rely on enwiki, or log, you can use


as drop in replacement. enwiki and log are not lagging there.

I filed RT ticket 8032:

Best regards,

---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ----
                           Companies' registry: 360296y in Linz
Christian Aistleitner
Kefermarkterstrasze 6a/3     Email:
4293 Gutau, Austria          Phone:          +43 7946 / 20 5 81
                             Fax:            +43 7946 / 20 5 81

Analytics mailing list