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]
