See revision_userindex and archive_userindex On Sat, Apr 19, 2014 at 2:56 PM, Maximilian Doerr <[email protected]>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 < > [email protected]> 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 > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/labs-l > > _______________________________________________ > Labs-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l >
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
