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?
Thanks,
Uwe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]