Re: Query Cache questions

2008-09-17 Thread Ananda Kumar
okie..got u On 9/17/08, Bard Aase <[EMAIL PROTECTED]> wrote: > > On Wed, Sep 17, 2008 at 12:42 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > >>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

Re: Query Cache questions

2008-09-17 Thread Bard Aase
On Wed, Sep 17, 2008 at 12:42 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: >>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

Re: Query Cache questions

2008-09-17 Thread Ananda Kumar
>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 <[EMAIL PRO

Re: Query Cache questions

2008-09-17 Thread Bard Aase
On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: > Bard Aase schrieb: >> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: >>> Hi, >>> >>> I have two questions regarding the query cache: >>> >>> 1. What is the difference between query_cache_limit and que

Re: Query Cache questions

2008-09-17 Thread Uwe Kiewel
Bard Aase schrieb: > On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> 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

Re: Query Cache questions

2008-09-17 Thread Bard Aase
On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> 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 re