<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_1484063873261_25143"><span>Hello Jamie,</span></div><div><span><br></span></div><div id="yui_3_16_0_ym19_1_1484063873261_25174" dir="ltr"><span id="yui_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="qtdSeparateBR" id="yui_3_16_0_ym19_1_1484063873261_25735"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1484063873261_25381" 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_1484063873261_25380"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1484063873261_25379"> <div dir="ltr" id="yui_3_16_0_ym19_1_1484063873261_25378"><font id="yui_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></font></div> <br><br> <div class="y_msg_container" id="yui_3_16_0_ym19_1_1484063873261_25740"><div id="yiv3591672563"><div id="yui_3_16_0_ym19_1_1484063873261_25739"><div dir="ltr" id="yui_3_16_0_ym19_1_1484063873261_25738"><div id="yui_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="yiv3591672563gmail_extra"><br clear="none"><div class="yiv3591672563gmail_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="yiv3591672563gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="yiv3591672563yqt1831851194" id="yiv3591672563yqt73470"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"><div id="yiv3591672563m_3161912492224105553yui_3_16_0_ym19_1_1484063873261_15835">Hello,</div><div id="yiv3591672563m_3161912492224105553yui_3_16_0_ym19_1_1484063873261_15940"><br clear="none"></div><div id="yiv3591672563m_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="yiv3591672563m_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="yiv3591672563gmail_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><br></div> </div> </div> </div></div></body></html>