Re: Queries not in Cache

2010-05-07 Thread Darvin Denmian
Can somebody help me with this? Thanks! On Thu, May 6, 2010 at 10:39 AM, Darvin Denmian darvin.denm...@gmail.com wrote: Hello, I've activated the query_cache in Mysql with the variable query_cache_limit value to 1 MB. My question is: How to know what queries wasn't cached because they

Re: Queries not in Cache

2010-05-07 Thread Johan De Meersman
What queries, precisely, I can't tell you, but you can have a good idea about how your cache performs using the stuff in show global variables; and the online manuals about what it all means :) Look at 'show global variables like %qcache%', for a start. On Fri, May 7, 2010 at 2:22 PM, Darvin

Queries not in Cache

2010-05-06 Thread Darvin Denmian
Hello, I've activated the query_cache in Mysql with the variable query_cache_limit value to 1 MB. My question is: How to know what queries wasn't cached because they have exceeded the value of query_cache_limit? **Sorry for my Brazilian Englihs :( Thanks! -- MySQL General Mailing List For