Hello
I don't understand why
query_cache_size / query_cache_min_res_unit != Qcache_total_blocks and
Qcache_free_memory / query_cache_min_res_unit != Qcache_free_blocks
Can anybody enlight me so that I know if I have to increase the
Query-Cache or not?
mysql> SHOW status LIKE "Qcache_%";
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| Qcache_free_blocks | 10382 |
| Qcache_free_memory | 247491776 |
| Qcache_hits | 119254865 |
| Qcache_inserts | 5412923 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 58724815 |
| Qcache_queries_in_cache | 16002 |
| Qcache_total_blocks | 42464 |
+-------------------------+-----------+
mysql> SHOW variables LIKE "query_cache_%";
+------------------------------+------------+
| Variable_name | Value |
+------------------------------+------------+
| query_cache_limit | 8388608 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 268435456 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
+------------------------------+------------+
thanks,
-christian-
--
Christian Hammers WESTEND GmbH | Internet-Business-Provider
Technik CISCO Systems Partner - Authorized Reseller
Lütticher Straße 10 Tel 0241/701333-11
[EMAIL PROTECTED] D-52064 Aachen Fax 0241/911879
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
