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://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html)
If I execute *show variable like 'have_query_cache'*, the result is YES.
The follow image show you my status into the global varaibles.
mysql> show global variables like 'query%';
+------------------------------+----------+
| Variable_name | Value |
+------------------------------+----------+
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 52428800 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
+------------------------------+----------+
7 rows in set (0.00 sec)
After execute the same query (select * from recursos) and run the
command show status like 'Qcache%' I obtain the next result (second image):
mysql> show status like 'qc%';
+-------------------------+----------+
| Variable_name | Value |
+-------------------------+----------+
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 52419952 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 4 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 1 |
+-------------------------+----------+
8 rows in set (0.00 sec)
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
