Queries not in Cache

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=gcdmg-mysql-2@m.gmane.org

Re: Queries not in Cache

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=gcdmg-mysql-2@m.gmane.org

Re: Queries not in Cache

--0016e6476de25bf9c10486007f9a
Content-Type: text/plain; charset=ISO-8859-1

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=vegivamp@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

--0016e6476de25bf9c10486007f9a--