Solved

MySQL Query Cache isn't working.

Posted on 2011-02-19
2
521 Views
Last Modified: 2012-06-27
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!
0
Comment
Question by:lpxtech
  • 2
2 Comments
 
LVL 6

Accepted Solution

by:
lpxtech earned 0 total points
ID: 34932408
This question was a mistake. Overlooked qcache output.
0
 
LVL 6

Author Closing Comment

by:lpxtech
ID: 34932410
This was a mistake. There's actually no problem.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question