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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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
TAGS
AUG Leaders

Atlassian Community Events