>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 PROTECTED]> wrote: > > 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] > >
