We are recently using tuning-primer.sh and finding it is better than mysqltuner.
Insatllation
cd /usr/local/bin wget https://launchpadlibrarian.net/78745738/tuning-primer.sh chmod u+x tuning-primer.sh
mysqltuner looks like giving wrong suggestions sometimes. Also its not mysql 5.6 ready something which we are using everywhere.
Running
tuning-primer.sh
For example, mysqltuner on mysql 5.6 ask us to change value of table_cache variable. It is renamed to table_open_cache. So following mysqltuner suggestion blindly can be risky sometimes.
Though, both are good tools. Use both!
I have to do 02 first:
1-/ you have to create a ~/.my.cnf. reference: https://rtcamp.com/tutorials/mysql/mycnf-preference/
2-/ use apt-get install bc
May I know which OS/version you are using? I would like to know which OS does not has
bcpreinstalled.About ~/.my.cnf it is mere convenience part. If that file is not present, you need to specify username and password while running commands.
I am using Ubuntu 12.04 LTS. Your posts is very helpful so I just want to update a little bit
information
Did not get you? What would you like to update?
Brother Rahul I have done the following commands that you mentioned about in my server but I am not getting any result output so can you tell me how to use this one ?
Thank You,
Sujoy
What happens when you run command:
tuning-primer.sh?Ok Understand it started working after quite sometime I think it takes time to load 🙂