Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers

Written by RackerHacker, MySQL Tuner should help: http://mysqltuner.pl/mysqltuner.pl - 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
add comment

Personally, I prefer well known tuning-primer.sh

http://www.day32.com/MySQL/

share|improve this answer
add comment

Your Answer

 
discard

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.