We are recently using
tuning-primer.sh and finding it is better than mysqltuner.
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.
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
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
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 ?
What happens when you run command:
Ok Understand it started working after quite sometime I think it takes time to load 🙂