Hi friends, I need your help.
I want to configure the Query Cache, but it dosn't work.
I have installed MySQL 5.0.19 in Mandrake Linux. The server has 2GB
memory ram, 150 gb hard disk, exclusive for dbms.
I configure my system how say the home page. I follow step by step the
instructions. (http:
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.
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
