Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to be able to get an recommendation of what values I should set my my.cnf to. Especially the query_cache_size and join_buffer_size. Is there a script out there that can monitor my server and give me a recommendation? Or any other solution?

I found a few scripts, but their recommendations did not give any specific numbers...

share|improve this question

Written by RackerHacker, MySQL Tuner should help: - you'll be lucky to find one that suggests the actual values though as these are heavily dependant on the code you're running.

share|improve this answer

Personally, I prefer well known

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.