<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Could this in anyway, no matter how remote, be a link to the slow query times enwiki has been spitting out? Anomie suggests they are cold files in the database, but I don’t understand how that should be happening with indexes in that area.<div class=""><br class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Cyberpower678<br class="">English Wikipedia Account Creation Team<br class="">Mailing List Moderator</div><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><br class=""></div><br class="Apple-interchange-newline">
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On Nov 26, 2014, at 09:54, Magnus Manske <<a href="mailto:magnusmanske@googlemail.com" class="">magnusmanske@googlemail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">I already submitted<br class=""><br class=""><a href="https://phabricator.wikimedia.org/T75980" class="">https://phabricator.wikimedia.org/T75980</a><br class=""><div class=""><br class=""></div><div class="">and</div><div class=""><br class=""></div><div class=""><a href="https://phabricator.wikimedia.org/T75511" class="">https://phabricator.wikimedia.org/T75511</a><br class=""></div><br class=""><div class="gmail_quote">On Wed Nov 26 2014 at 13:44:39 John <<a href="mailto:phoenixoverride@gmail.com" class="">phoenixoverride@gmail.com</a>> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr" class="">Actually it looks like things in the databases are completely screwy. idwiki.labsdb shows zero tables, but enwiki.labsdb "use idwiki_p" shows what it should. Looks like there may be a bigger issue<br class=""></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Wed, Nov 26, 2014 at 7:58 AM, Krinkle <span dir="ltr" class=""><<a href="mailto:krinklemail@gmail.com" target="_blank" class="">krinklemail@gmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class=""><div class="">Seems to be at least 62 days behind on commonswiki</div><div class=""><br class=""></div><div class="">tin.eqiad.wmnet$ sql commonswiki</div><div class="">rc_id: 142360816</div><div class="">rc_timestamp: 2014-11-26 12:55:31</div><div class=""><div class=""><br class=""></div><div class="">tools-login$ sql commonswiki</div></div><div class="">rc_id: 136903866</div><div class="">rc_timestamp: 2014-09-24 12:51:42</div><div class=""><br class=""></div><div class="">See also <a href="https://tools.wmflabs.org/unpatrollededitstats/commonswiki/" target="_blank" class="">https://tools.wmflabs.org/unpatrollededitstats/commonswiki/</a><br class=""><br class=""></div><div class="">
<div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; word-wrap: break-word;" class="">— Krinkle</div>
</div>
<br class=""><div class=""><div class="">On 23 Nov 2014, at 12:56, John <<a href="mailto:phoenixoverride@gmail.com" target="_blank" class="">phoenixoverride@gmail.com</a>> wrote:</div><br class=""><blockquote type="cite" class=""><div dir="ltr" class="">enwiki's replication lag is at 114256 and growing.<br class=""></div>
_______________________________________________<br class="">Labs-l mailing list<br class=""><a href="mailto:Labs-l@lists.wikimedia.org" target="_blank" class="">Labs-l@lists.wikimedia.org</a><br class=""><a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank" class="">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br class=""></blockquote></div><br class=""></div><br class="">_______________________________________________<br class="">
Labs-l mailing list<br class="">
<a href="mailto:Labs-l@lists.wikimedia.org" target="_blank" class="">Labs-l@lists.wikimedia.org</a><br class="">
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank" class="">https://lists.wikimedia.org/mailman/listinfo/labs-l</a><br class="">
<br class=""></blockquote></div><br class=""></div>
______________________________<u class=""></u>_________________<br class="">
Labs-l mailing list<br class="">
<a href="mailto:Labs-l@lists.wikimedia.org" target="_blank" class="">Labs-l@lists.wikimedia.org</a><br class="">
<a href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank" class="">https://lists.wikimedia.org/<u class=""></u>mailman/listinfo/labs-l</a><br class="">
</blockquote></div>
_______________________________________________<br class="">Labs-l mailing list<br class=""><a href="mailto:Labs-l@lists.wikimedia.org" class="">Labs-l@lists.wikimedia.org</a><br class="">https://lists.wikimedia.org/mailman/listinfo/labs-l<br class=""></div></blockquote></div><br class=""></div></body></html>