Forums

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

Should I enable the query cache in MySQL for JIRA 6.3.15?

DavidM
Contributor
April 11, 2015

When using JIRA 6.3.15 and JIRA Agile 6.6.80, I see lots of repetitive queries. Those aren't particularly bad, but it makes me consider whether we should have the query cache turned on. We do this in our staging database and see a hit rate of about 30%. That's not really high enough to justify the overhead of a 70% miss rate, but that's staging where we aren't getting the same profile of queries.

1 answer

1 accepted

0 votes
Answer accepted
Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 11, 2015

The best answer is try it and see.   Nobody has your usage pattern.  The overhead cost is minimal for a few days of experimentation.

DavidM
Contributor
April 14, 2015

I was hoping for responses such as "we tried in once but it wasn't really worth it" or "we see a hit rate of 70%!!" However, this answer is probably the wisest. Thank you!

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, out of office, loom, confluence, async collaboration, meeting recaps, remote teamwork, team alignment, knowledge sharing, AI-powered notes, productivity tools, workforce continuity, teamwork collection

Put your meeting notes on autopilot with Loom + Confluence

AI-powered meeting notes keep work moving even if you’re out of the office. Enjoy your well-deserved time off and return refreshed, confident you’ll catch up in no time.

Learn more
AUG Leaders

Atlassian Community Events