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. I don't know if I managed to explain this in a understandable way, but it's worth a shot... -- 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]