user2696962
Reputation: 575
How to check the actual queries Qcache_not_cached
How can I check which queries query_cache didn't cache? my Qcache_not_cached is very large and I would like to know which queries are not cached and why.
| Qcache_not_cached | 12843 |
Upvotes: 0
Views: 769
Answers (1)
user2705358
Reputation: 36
You can run the status of Qcache_not_cached and show status like 'Qcache_hits' before and after your queries. If you see the cache size increased then the query is being cached and if the size remains the same then it's not.
Upvotes: 1
Related Questions
- Qcache_hits always 0
- How to check query_cache_type value on my server
- How to detect if MySQL query is from cache?
- query_cache_size, Qcache_total_blocks and query_alloc_block_size
- How to list cached queries in MySQL? (Qcache_queries_in_cache)
- View mysql query cache contents
- Log queries which are cached and those which are not
- SHOW STATUS LIKE 'Qcache%'; variable values remain 0 even i enabled query cache
- How to check MySQL cache lifetime?
- Mysql: qcache_not_cached