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 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: [EMAIL PROTECTED]
http://blog.elzapp.com
:wq

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to