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]