Re: Query Cache questions

2008-09-17 Thread Bard Aase
ht prevent the first query from beeing flushed, which will make you able to use the cache for the third query. > > On 9/17/08, Bard Aase <[EMAIL PROTECTED]> wrote: >> >> On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote: >> > Ba

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: >>> &g

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