tuning-primer.sh – an alternative for mysqltuner

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!

Comments

  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
        information

      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,
    Sujoy

    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.