[Labs-l] Fw: query caching

[Chase Pettet]

Yetkin,

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?

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

> Any update on this?
>
> On Tuesday, January 10, 2017 10:20 PM, Yetkin Sakal <superyetkin at yahoo.com>
> wrote:
>
>
> 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
> <https://lists.wikimedia.org/mailman/listinfo/labs-l>
>
>
>
>
> --
> Jaime Crespo
> <http://wikimedia.org>
>
>
>
>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l
>
>


-- 
Chase Pettet
Engineering Manager -- Labs
chasemp on phabricator <https://phabricator.wikimedia.org/p/chasemp/> and
IRC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20170117/85438f0a/attachment.html>