Solved

MySQL Query Cache isn't working.

Posted on 2011-02-19
2
517 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

919 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now