<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1484668407027_13292"><span id="yui_3_16_0_ym19_1_1484668407027_13329">Any update on this?</span></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1484668407027_13291"><br></div> <div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1484668407027_13203" style="display: block;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;" id="yui_3_16_0_ym19_1_1484668407027_13202"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1484668407027_13201"> <div dir="ltr" id="yui_3_16_0_ym19_1_1484668407027_13293"><font id="yui_3_16_0_ym19_1_1484668407027_13316" size="2" face="Arial"> On Tuesday, January 10, 2017 10:20 PM, Yetkin Sakal <superyetkin@yahoo.com> wrote:<br></font></div> <br><br> <div class="y_msg_container" id="yui_3_16_0_ym19_1_1484668407027_13208"><div id="yiv1862314859"><div id="yui_3_16_0_ym19_1_1484668407027_13207"><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;" id="yui_3_16_0_ym19_1_1484668407027_13206"><div id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25143"><span>Hello Jamie,</span></div><div id="yui_3_16_0_ym19_1_1484668407027_13209"><span><br clear="none"></span></div><div dir="ltr" id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25174"><span id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25175">Is there any other caching mechanism on labs replicas? For the past few days, I see my tools are showing results that I believe did not appear before. How can we make sure the queries run on replica servers return consistent results?</span></div> <div class="yiv1862314859qtdSeparateBR" id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25735"><br clear="none"><br clear="none"></div><div class="yiv1862314859yahoo_quoted" id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25381" style="display:block;"> <div id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25380" style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"> <div id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25379" style="font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"> <div class="yiv1862314859yqt3501451851" id="yiv1862314859yqtfd24156"><div dir="ltr" id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25378"><font id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25377" size="2" face="Arial"> On Tuesday, January 10, 2017 9:31 PM, Jaime Crespo <jcrespo@wikimedia.org> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div class="yiv1862314859y_msg_container" id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25740"><div id="yiv1862314859"><div id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25739"><div dir="ltr" id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25738"><div id="yiv1862314859yui_3_16_0_ym19_1_1484063873261_25737">Hi, Yetkin,<br clear="none"><br clear="none"></div>If you mean query cache on the labs replica servers or the tools-db one, it is disabled by default on all servers:<br clear="none"><br clear="none">```<br clear="none">$ mysql -e "SHOW GLOBAL VARIABLES like '%query_cache%'"<br clear="none">+------------------------------+---------+<br clear="none">| Variable_name | Value |<br clear="none">+------------------------------+---------+<br clear="none">| query_cache_size | 0 |<br clear="none">| query_cache_type | OFF |<br clear="none">+------------------------------+---------+<br clear="none">```<br clear="none"><br clear="none"></div><div class="yiv1862314859gmail_extra"><br clear="none"><div class="yiv1862314859gmail_quote">On Tue, Jan 10, 2017 at 9:56 AM, Yetkin Sakal <span dir="ltr"><<a rel="nofollow" shape="rect" ymailto="mailto:superyetkin@yahoo.com" target="_blank" href="mailto:superyetkin@yahoo.com">superyetkin@yahoo.com</a>></span> wrote:<br clear="none"><blockquote class="yiv1862314859gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="yiv1862314859yqt1831851194" id="yiv1862314859yqt73470"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"><div id="yiv1862314859m_3161912492224105553yui_3_16_0_ym19_1_1484063873261_15835">Hello,</div><div id="yiv1862314859m_3161912492224105553yui_3_16_0_ym19_1_1484063873261_15940"><br clear="none"></div><div id="yiv1862314859m_3161912492224105553yui_3_16_0_ym19_1_1484063873261_15937">Is there any way to eliminate caching on Tool Labs? SQL_NO_CACHE option in MySQL does not seem to work at all.</div><div><br clear="none"></div><div id="yiv1862314859m_3161912492224105553yui_3_16_0_ym19_1_1484063873261_15994">Thanks.<br clear="none"></div></div></div></div><br clear="none">______________________________ _________________<br clear="none">
Labs-l mailing list<br clear="none">
<a rel="nofollow" shape="rect" ymailto="mailto:Labs-l@lists.wikimedia.org" target="_blank" href="mailto:Labs-l@lists.wikimedia.org">Labs-l@lists.wikimedia.org</a><br clear="none">
<a rel="nofollow" shape="rect" target="_blank" href="https://lists.wikimedia.org/mailman/listinfo/labs-l">https://lists.wikimedia.org/ mailman/listinfo/labs-l</a><br clear="none">
<br clear="none"></blockquote></div><br clear="none"><br clear="all"><br clear="none">-- <br clear="none"><div class="yiv1862314859gmail_signature"><div dir="ltr"><div>Jaime Crespo<br clear="none"></div><<a rel="nofollow" shape="rect" target="_blank" href="http://wikimedia.org/">http://wikimedia.org</a>><br clear="none"></div></div>
</div></div></div><br clear="none"><br clear="none"></div> </div></div><div class="yiv1862314859yqt3501451851" id="yiv1862314859yqtfd89325"> </div></div><div class="yiv1862314859yqt3501451851" id="yiv1862314859yqtfd43888"> </div></div></div></div></div><br><br></div> </div> </div> </div></div></body></html>