Urgh. Let me clear something up, those are the tables I am using. rev_user, ar_user, are slow, ar_user_text, and rev_user_text work just fine. On Apr 20, 2014, at 10:09 AM, John <[email protected]> wrote:
> 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
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
