From: Ananda Kumar (anandklgmail.com)
Date: Wed Sep 17 2008 - 05:42:53 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

>query_cache_limit is the maximum size of a single resultset in the
> cache. If your query results in a bigger resultset it will never get
> into the cache even if its room for it in the cache itself.

Even if there is room why will it not fit into the cache.

On 9/17/08, Bard Aase <elzappelzapp.com> wrote:
>
> On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <mlkiewel-online.de> wrote:
> > Bard Aase schrieb:
> >> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <mlkiewel-online.de>
> wrote:
> >>> Hi,
> >>>
> >>> I have two questions regarding the query cache:
> >>>
> >>> 1. What is the difference between query_cache_limit and
> query_cache_size?
> >>
> >> query_cache_limit is the maximum size of a single resultset in the
> >> cache. If your query results in a bigger resultset it will never get
> >> into the cache even if its room for it in the cache itself.
> >>
> >> query_cache_size is the maximum amount of data that may be stored in the
> cache.
> >
> > Do you talk about all usable cache memory for all resultsets?
>
> Yes
>
>
>
> --
> mvh base (Bård Aase)
> MSN: msnelzapp.com
> http://blog.elzapp.com
> :wq
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=anandklgmail.com
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]