Tutorial MySQL - Tutorial to learn how to optimize the performance of MySQL

SQL databases and especially MySQL remain one of the cornerstones of the vast majority of websites. MySQL works very well out of the box , however, as soon as the database is stressed enough, we realize that the default settings deserve a little optimization. Let's take a look at all this!

Recently one of the servers Peerus beginning to have sacred peak load ( load) during high load hours, with MySQL main responsible. A hundred or so simultaneous connections and a few dozens of requests per second on bases of several tens of gigabytes. It's a little more than the average WordPress, but nothing unmanageable for a well tuned MySQL.

Therefore, before imagining take a more powerful server, sharder (horizontal partitioning) tables or whatever, we must make the most of our dear RDBMS.

We will focus here on the InnoDB engine, which tends to supplant MyISAM. However, this is not the magic answer to all types of uses . Moreover, even if we speak of MySQL, it is with its fork MariaDB that I used to work since a few years. Given the lack of care that Oracle brings to the development of MySQL, Maria has even become the default MySQL variant in Debian .

In the remainder of this article, we will work most of the time directly from the MySQL shell to display and modify the settings (which can then be reflected in the configuration file (conf) to survive the restart). Comment Rate Article (5)