[Labs-l] Fw: query caching

Yetkin Sakal superyetkin at yahoo.com
Tue Jan 17 17:39:44 UTC 2017


I believe my "uncategorized pages" tool at http://tools.wmflabs.org/superyetkin/kategorisizsayfalar.php is showing cached results.
 

    On Tuesday, January 17, 2017 7:55 PM, Chase Pettet <cpettet at wikimedia.org> wrote:
 

 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





-- 
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 and IRC


   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20170117/05a16df5/attachment-0001.html>


More information about the Labs-l mailing list