tuning-primer.sh – an alternative for mysqltuner

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!


  1. Pete Avatar

    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

    1. Rahul Bansal Avatar

      May I know which OS/version you are using? I would like to know which OS does not has bc preinstalled.

      About ~/.my.cnf it is mere convenience part. If that file is not present, you need to specify username and password while running commands.

      1. Pete Avatar

        I am using Ubuntu 12.04 LTS. Your posts is very helpful so I just want to update a little bit

      2. Rahul Bansal Avatar

        Did not get you? What would you like to update?

  2. Sujoy Dhar Avatar

    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,

    1. Rahul Bansal Avatar

      What happens when you run command: tuning-primer.sh ?

      1. Sujoy Dhar Avatar

        Ok Understand it started working after quite sometime I think it takes time to load 🙂

Book a strategy call
with our experts

No obligation. Limited slots.

Contact Form Business Enquiry

"*" indicates required fields

Please attach any RFP, project specification, or document that you would like to share.
Drop files here or
Max. file size: 50 MB.
    This field is for validation purposes and should be left unchanged.