<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">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.<br><div><div>On Apr 20, 2014, at 10:09 AM, John <<a href="mailto:phoenixoverride@gmail.com">phoenixoverride@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">See revision_userindex and archive_userindex<br><br><div class="gmail_quote">On Sat, Apr 19, 2014 at 2:56 PM, Maximilian Doerr <span dir="ltr"><<a href="mailto:cybernet678@yahoo.com" target="_blank">cybernet678@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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.<br>
<br>
Gesendet von Maximilian's iPhone.<br>
(Sent from Maximilian's iPhone.)<br>
<div class="HOEnZb"><div class="h5"><br>
> On Apr 19, 2014, at 12:33, Marc-André Pelletier <<a href="mailto:mpelletier@wikimedia.org">mpelletier@wikimedia.org</a>> wrote:<br>
><br>
>> On 04/19/2014 12:21 PM, John wrote:<br>
>> Taking a look enwiki_p is at 1 day, 8:06:02 lag. I think its probably<br>
>> due to someone having a broken request.<br>
>><br>
>> I know Coren will end up killing it, but it would be useful to know who<br>
>> is causing these issues.<br>
><br>
> Not this time; there were some system control statements issued in prod<br>
> that cannot work on the replicas that have stalled the replication<br>
> timeline. This will need a bit of tender loving care from our DBA.<br>
><br>
> -- Marc<br>
><br>
><br>
> _______________________________________________<br>
> Labs-l mailing list<br>
> <a href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br>
> <a href="https://lists.wikimedia.org/mailman/listinfo/labs-l">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
<br>
_______________________________________________<br>
Labs-l mailing list<br>
<a href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br>
</div></div></blockquote></div><br>
_______________________________________________<br>Labs-l mailing list<br><a href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br>https://lists.wikimedia.org/mailman/listinfo/labs-l<br></blockquote></div><br></body></html>