[Labs-l] enwiki replication stopped

[John]

See revision_userindex and archive_userindex

On Sat, Apr 19, 2014 at 2:56 PM, Maximilian Doerr <cybernet678 at yahoo.com>wrote:

> While TLC is being given, any chance of providing indexed tables of
> revision and archive where rev_user and ar_user turn out results as fast as
> rev_user_text and ar_user_text does?  They are a bit slow at the moment,
> and can cause load times for the edit counter to hit 2 digits for someone
> with <100,000 edits.
>
> Gesendet von Maximilian's iPhone.
> (Sent from Maximilian's iPhone.)
>
> > On Apr 19, 2014, at 12:33, Marc-André Pelletier <
> mpelletier at wikimedia.org> wrote:
> >
> >> On 04/19/2014 12:21 PM, John wrote:
> >> Taking a look enwiki_p is at 1 day, 8:06:02 lag. I think its probably
> >> due to someone having a broken request.
> >>
> >> I know Coren will end up killing it, but it would be useful to know who
> >> is causing these issues.
> >
> > Not this time; there were some system control statements issued in prod
> > that cannot work on the replicas that have stalled the replication
> > timeline.  This will need a bit of tender loving care from our DBA.
> >
> > -- Marc
> >
> >
> > _______________________________________________
> > Labs-l mailing list
> > Labs-l at lists.wikimedia.org
> > https://lists.wikimedia.org/mailman/listinfo/labs-l
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wikimedia.org/pipermail/labs-l/attachments/20140420/864a684b/attachment.html>