query_cache_size - a total size of memory that server utilizes for query caching. query_cache_limit - maximum size of result set that can be cached. I'd suggest leaving query_cache_limit at 1 mb (the default value), and tune query_cache_size until you have reasonably low qcache_lowmem_prunes value.
On 8/15/05, Maxim Vexler <[EMAIL PROTECTED]> wrote: > Mysql's query cache has two option's [query_cache_limit] and > [query_cache_size]. > The documentation is not clear (for me) on their purpose and correct > usage tactics. > > What does the [query_cache_size] sets, the maximum memory space a > single query can utilize ? Is it wise to set it to the same size as > [query_cache_limit] ? > > How much memory would you recommend setting the caching to, if I have > 1GB on the system, and it runs httpd/php & mysql all together ? > > > I've also included a dump from our live server, for which I have > configured the query cache. for reference (or criticism) : > > mysql> SHOW STATUS LIKE 'Qcache%'; > +-------------------------+---------+ > | Variable_name | Value | > +-------------------------+---------+ > | Qcache_queries_in_cache | 1007 | > | Qcache_inserts | 98199 | > | Qcache_hits | 97128 | > | Qcache_lowmem_prunes | 49330 | > | Qcache_not_cached | 671 | > | Qcache_free_memory | 1063112 | > | Qcache_free_blocks | 340 | > | Qcache_total_blocks | 2374 | > +-------------------------+---------+ > 8 rows in set (0.00 sec) > > mysql> SHOW global VARIABLES like 'query_cache%'; > +-------------------+---------+ > | Variable_name | Value | > +-------------------+---------+ > | query_cache_limit | 5242880 | > | query_cache_size | 3145728 | > | query_cache_type | ON | > +-------------------+---------+ > 3 rows in set (0.00 sec) > > > Thank you. > > -- > Cheers, > Maxim Vexler (hq4ever). > > Do u GNU ? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Alexey Polyakov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
