Skip to main content
Question

Innodb query_cache_size variable


Forum|alt.badge.img+6
  • New Contributor
  • 4 replies

Hello JAMF nation.

I'm trying to find a good value for the query_cache_size variable of innodb.
Our Environment manages about 15K macs and 45K ipads.

Any suggestions are appreciated

2 replies

Forum|alt.badge.img+10
  • Valued Contributor
  • 193 replies
  • January 5, 2018

I have 25K Macs and 13K iPads with query_cache_size set to 16M. This is a recent setting so I have only had it under load for about a week now. I set query_cache_type to 1 and size to 16M just before Christmas break mid December. I have not seen any negative impact but can't really say if it has helped any yet either. I may let it ride like this for another week and then bump it up again to see if it makes a difference.


Forum|alt.badge.img+10
  • Valued Contributor
  • 193 replies
  • January 5, 2018

@Josman you have probably already seen the MySql reference manual. However, for others that have not there is some great info in there. Also, at the bottom is a link to some additional info on query cache settings and what to monitor to base your scaling on.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings