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 Denmian wrote:

> Can somebody help me with this?
>
> Thanks!
>
> On Thu, May 6, 2010 at 10:39 AM, Darvin Denmian
>  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 have exceeded the
> > value of "query_cache_limit"?
> >
> > **Sorry for my Brazilian Englihs :(
> >
> > Thanks!
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel


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
 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 have exceeded the
> value of "query_cache_limit"?
>
> **Sorry for my Brazilian Englihs :(
>
> Thanks!
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



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 list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org