[Labs-l] query caching

[Yetkin Sakal]

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:

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

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





-- 
Jaime Crespo
<http://wikimedia.org>


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