What is MySQL Tuning, Its Usage

Mysql performance tuning, written in perl language, analyzes your mysql and mariadb performance, and presents you as output the “my.cnf” file analysis that needs to be done for deficiencies, pluses and optimization.

The first script, which was released as mysqltuner, was published in the github site as mysql tuning by Matthew Montgomery by adding innovation over time.

What is MySQL?

MySQL is a Relational Database Management System (RDBMS) named after founder Michael Widenius’ daughter “My” and SQL stands for “Structured Query Language”.

The first version of this database was released in 1995, and later Oracle, with Sun Microsystems, acquired the same in January 2010.

What is My.cnf File?

The my.cnf file is the settings file of the database management systems on your linux server.

Do not forget that it is a very valuable and important file for your database and server. In server optimizations, mysql, mariadb settings are usually made here. In fact, our friends who say that I am doing a lot of server optimization(!) replace the my.cnf file with the file they have previously set and leave it.

And so they think they are doing server optimization 🙂

So what does this mean?

Let’s transfer VIP information to digitaltechau.com followers immediately :)) My.cnf file should contain separate settings for each server. The number of connections there, cache operations vary according to the characteristics of your server and database.

In this part, mysql tuning (prime), which you will use very easily, comes to your rescue so that you do not need someone else’s copy information.

Warning: If you leave the my.cnf file empty, it will use NULL, that is, the default settings and the server database settings, and no other reason for cancer will be sought.

Warning 2: Take a backup of my.cnf file, save it aside. Then you can write me a thank you message in the comment section instead of swearing :))

Where is my.cnf file?

By the way, where is the my.cnf file?

The my.cnf file is located in different locations depending on the operating systems you are using.

Linux: For Linux servers the my.cnf file is usually located here,

/etc/my.cnf
/etc/mysql/my.cnf
/usr/etc/my.cnf
~/.my.cnf

I don’t know where it is because I don’t work with Windows servers 🙂 Anyway, if a new linux system develops and the location of this file changes, we can search it with the find command in linux:

“find / -name my.cnf” (please delete the quotes and type the command!)

I realize we have found our my.cnf file, and now let’s go back to MySQL Tuning, the mysql optimization tool.

How does MySQL work?

MySQL is based on a client-server model. The core of MySQL is the MySQL server, which processes all database instructions (or commands). MySQL server is available as a separate program for use in a client-server network environment and as a library that can be embedded (or linked) into separate applications.

MySQL works with various utilities that support the management of MySQL databases. Commands are sent to MySQL Server via the MySQL client installed on a computer.

MySQL was originally developed to handle large databases quickly. Although MySQL is typically installed on only one machine, users can send the database to multiple locations as they can access it through different MySQL client interfaces. These interfaces send SQL statements to the server and then display the results.

MySQL Performance Tuning / MySQL Tuner Installation and Usage

Now let’s get to the most important issue. Let’s explain the mysql performance tuning setup.

Let’s go to the github link and copy it. Then let’s connect to our server via SSH connection. (You can use Putty)

Let’s pull our file to our server with our wget command:

Command 1 : wget https://github.com/BMdan/tuning-primer.sh/blob/master/tuning-primer.sh

Let’s give the necessary permissions with the chmod command:

Command 2 : chmod u+x tuning-primer.sh

and let’s run our file:

Command 3 : ./tuning-primer.sh

And our program starts the analysis. In the README section of the software, it mentions that your database must be active for 48 hours, in order to get full efficiency. It will be beneficial for you to comply with this.

After the analysis is finished, the suggestions will appear on your screen in 3 colors.

• Reds are important warnings, they contain settings that you definitely need to fix.
• Yellow, alerts settings where you get moderate points you need to improve, and
• Greens are alerts that you get right and get full points.

For professional support about Mysql performance tuning, you can contact us from the contact section.