[Labs-l] query caching

Yetkin Sakal superyetkin at yahoo.com
Tue Jan 10 19:20:05 UTC 2017

Hello Jamie,
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? 

    On Tuesday, January 10, 2017 9:31 PM, Jaime Crespo <jcrespo at wikimedia.org> wrote:

 Hi, Yetkin,

If you mean query cache on the labs replica servers or the tools-db one, it is disabled by default on all servers:

$ mysql  -e "SHOW GLOBAL VARIABLES like '%query_cache%'"
| Variable_name                | Value   |
| query_cache_size             | 0       |
| query_cache_type             | OFF     |

On Tue, Jan 10, 2017 at 9:56 AM, Yetkin Sakal <superyetkin at yahoo.com> wrote:

Is there any way to eliminate caching on Tool Labs? SQL_NO_CACHE option in MySQL does not seem to work at all.

______________________________ _________________
Labs-l mailing list
Labs-l at lists.wikimedia.org
https://lists.wikimedia.org/ mailman/listinfo/labs-l

Jaime Crespo

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20170110/9cf91a63/attachment.html>

More information about the Labs-l mailing list