MySQL Query Cache isn't working.

Hey everyone,

I can't seem to get query caching to work by default, which i would imagine it should. Is there something I'm missing here? Any help would be appreciated.

I'm running a dedicated 4gb server for mysql alone.

my.cnf:
query_cache_type        = 1
query_cache_limit       = 1M
query_cache_size        = 128M

Open in new window


mysql output:
mysql> SHOW VARIABLES LIKE '%query_cache%';
+------------------------------+-----------+
| Variable_name                | Value     |
+------------------------------+-----------+
| have_query_cache             | YES       | 
| query_cache_limit            | 1048576   | 
| query_cache_min_res_unit     | 4096      | 
| query_cache_size             | 134217728 | 
| query_cache_type             | ON        | 
| query_cache_wlock_invalidate | OFF       | 
+------------------------------+-----------+
6 rows in set (0.00 sec)

mysql> SHOW STATUS LIKE '%qcache%';
+-------------------------+----------+
| Variable_name           | Value    |
+-------------------------+----------+
| Qcache_free_blocks      | 21207    | 
| Qcache_free_memory      | 84123496 | 
| Qcache_hits             | 22579540 | 
| Qcache_inserts          | 10565072 | 
| Qcache_lowmem_prunes    | 0        | 
| Qcache_not_cached       | 842169   | 
| Qcache_queries_in_cache | 47005    | 
| Qcache_total_blocks     | 115267   | 
+-------------------------+----------+
8 rows in set (0.00 sec)

Open in new window



Thanks!
LVL 6
lpxtechAsked:
Who is Participating?
 
lpxtechConnect With a Mentor Author Commented:
This question was a mistake. Overlooked qcache output.
0
 
lpxtechAuthor Commented:
This was a mistake. There's actually no problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.