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
