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
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
>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
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
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
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