Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL tune query_cache_limit not hitting

Nate Evans April 23, 2016

Should I be using MySQL query cache with confluence, jira?  It doesn't seem to be hitting

 

query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 256M

Do you guys have any more detailed MySQL tuning information?

1 answer

0 votes
Gonchik Tsymzhitov
Community Champion
March 15, 2017

Hi, 

could you provide? 

  1. SHOW VARIABLES LIKE '%query_cache%';
  2. show status like '%Qcache%';
  3. ((Qcache_hits/(Qcache_hits+Qcache_inserts+Qcache_not_cached))*100)

In fact, query_cache_size = 256M it is so much. 

 

 

 

 

 

 

Suggest an answer

Log in or Sign up to answer