MySQLTuner – MYSQL Optimization and Tunning Script in Linux

The easiest way in Linux to optimize MYSQL data server performance, is to use mysqltuner script.

MySQLTuner is a script written in perl that will assist you with your MySQL configuration & make recommendations for increased performance and stability.

The simplest is to download the latest MySQLTuner version in plain text to your server using wget command:


chmod 0700


Another easy method is to install the mysqltuner application, since is already added to the Ubuntu repositories. Below is an example of an installation in Ubuntu version 18.4

sudo apt-get update && sudo apt-get -y upgrade

sudo apt-get install mysqltuner

sudo mysqltuner

As a result, you should get recommendations like this:

-------- Recommendations ----------
General recommendations:
  Control warning line(s) into /var/log/mysql/error.log file
  Control error line(s) into /var/log/mysql/error.log file
  MySQL started within last 24 hours - recommendations may be inaccurate
  Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  Adjust your join queries to always utilize indexes
Variables to adjust:
  join_buffer_size (> 1.0M, or always use indexes with joins)


byrev Written by:

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *