MySQL tune query_cache_limit not hitting

Nate Evans

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?

Gonchik Tsymzhitov

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.