<div dir="ltr"><div>Yetkin,<br><br></div>I am not sure what the answer here is but I believe to get further with this issue specifics are needed. What queries? When are they run? What do you hope to get back that you are not? Which wiki databases are you querying? Can you show examples of specific inconsistent results?<br><div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 17, 2017 at 10:01 AM, Yetkin Sakal <span dir="ltr"><<a href="mailto:superyetkin@yahoo.com" target="_blank">superyetkin@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:13px"><div id="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13292"><span id="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13329">Any update on this?</span></div><div class="m_1988271060636826442qtdSeparateBR" id="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13291"><br></div> <div class="m_1988271060636826442yahoo_quoted" id="m_1988271060636826442yui_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="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13202"> <div style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:16px" id="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13201"> <div dir="ltr" id="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13293"><font id="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13316" size="2" face="Arial"> On Tuesday, January 10, 2017 10:20 PM, Yetkin Sakal <<a href="mailto:superyetkin@yahoo.com" target="_blank">superyetkin@yahoo.com</a>> wrote:<br></font></div> <br><br> <div class="m_1988271060636826442y_msg_container" id="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13208"><div id="m_1988271060636826442yiv1862314859"><div id="m_1988271060636826442yui_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="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13206"><div id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25143"><span>Hello Jamie,</span></div><div id="m_1988271060636826442yui_3_16_0_ym19_1_1484668407027_13209"><span><br clear="none"></span></div><div dir="ltr" id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25174"><span id="m_1988271060636826442yiv1862314859yui_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="m_1988271060636826442yiv1862314859qtdSeparateBR" id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25735"><br clear="none"><br clear="none"></div><div class="m_1988271060636826442yiv1862314859yahoo_quoted" id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25381" style="display:block"> <div id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25380" style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:13px"> <div id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25379" style="font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:16px"> <div class="m_1988271060636826442yiv1862314859yqt3501451851" id="m_1988271060636826442yiv1862314859yqtfd24156"><div dir="ltr" id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25378"><font id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25377" size="2" face="Arial"> On Tuesday, January 10, 2017 9:31 PM, Jaime Crespo <<a href="mailto:jcrespo@wikimedia.org" target="_blank">jcrespo@wikimedia.org</a>> wrote:<br clear="none"></font></div> <br clear="none"><br clear="none"> <div class="m_1988271060636826442yiv1862314859y_msg_container" id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25740"><div id="m_1988271060636826442yiv1862314859"><div id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25739"><div dir="ltr" id="m_1988271060636826442yiv1862314859yui_3_16_0_ym19_1_1484063873261_25738"><div id="m_1988271060636826442yiv1862314859yui_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">+-----------------------------<wbr>-+---------+<br clear="none">| Variable_name | Value |<br clear="none">+-----------------------------<wbr>-+---------+<br clear="none">| query_cache_size | 0 |<br clear="none">| query_cache_type | OFF |<br clear="none">+-----------------------------<wbr>-+---------+<br clear="none">```<br clear="none"><br clear="none"></div><div class="m_1988271060636826442yiv1862314859gmail_extra"><br clear="none"><div class="m_1988271060636826442yiv1862314859gmail_quote">On Tue, Jan 10, 2017 at 9:56 AM, Yetkin Sakal <span dir="ltr"><<a rel="nofollow" shape="rect" href="mailto:superyetkin@yahoo.com" target="_blank">superyetkin@yahoo.com</a>></span> wrote:<br clear="none"><blockquote class="m_1988271060636826442yiv1862314859gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="m_1988271060636826442yiv1862314859yqt1831851194" id="m_1988271060636826442yiv1862314859yqt73470"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:13px"><div id="m_1988271060636826442yiv1862314859m_3161912492224105553yui_3_16_0_ym19_1_1484063873261_15835">Hello,</div><div id="m_1988271060636826442yiv1862314859m_3161912492224105553yui_3_16_0_ym19_1_1484063873261_15940"><br clear="none"></div><div id="m_1988271060636826442yiv1862314859m_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="m_1988271060636826442yiv1862314859m_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" href="mailto:Labs-l@lists.wikimedia.org" target="_blank">Labs-l@lists.wikimedia.org</a><br clear="none">
<a rel="nofollow" shape="rect" href="https://lists.wikimedia.org/mailman/listinfo/labs-l" target="_blank">https://lists.wikimedia.org/ mailman/listinfo/labs-l</a><br clear="none">
<br clear="none"></blockquote></div><span class="HOEnZb"><font color="#888888"><br clear="none"><br clear="all"><br clear="none">-- <br clear="none"><div class="m_1988271060636826442yiv1862314859gmail_signature"><div dir="ltr"><div>Jaime Crespo<br clear="none"></div><<a rel="nofollow" shape="rect" href="http://wikimedia.org/" target="_blank">http://wikimedia.org</a>><br clear="none"></div></div>
</font></span></div></div></div><br clear="none"><br clear="none"></div> </div></div><div class="m_1988271060636826442yiv1862314859yqt3501451851" id="m_1988271060636826442yiv1862314859yqtfd89325"> </div></div><div class="m_1988271060636826442yiv1862314859yqt3501451851" id="m_1988271060636826442yiv1862314859yqtfd43888"> </div></div></div></div></div><br><br></div> </div> </div> </div></div></div><br>______________________________<wbr>_________________<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" rel="noreferrer" target="_blank">https://lists.wikimedia.org/<wbr>mailman/listinfo/labs-l</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Chase Pettet<br></div>Engineering Manager -- Labs<br></div><div>chasemp on <a href="https://phabricator.wikimedia.org/p/chasemp/" target="_blank">phabricator</a> and IRC<br></div></div></div></div></div></div>
</div></div></div>