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 <[email protected]> wrote: > Any update on this? > > On Tuesday, January 10, 2017 10:20 PM, Yetkin Sakal <[email protected]> > 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 <[email protected]> > 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 <[email protected]> > 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 > [email protected] > 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l > > -- Chase Pettet Engineering Manager -- Labs chasemp on phabricator <https://phabricator.wikimedia.org/p/chasemp/> and IRC
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
