tutorial net
*********WOOOOOOW *********
We're happy to see you're enjoying our races (already 5 pages viewed today)! You can keep checking out by becoming a member of the tutorial net community. It's free!
You will also be able to keep track of your race progress, practice on exercises, and chat with other members.

Share
Go down
Admin
Posts : 207
Join date : 2017-11-11
Age : 27
Location : algeria
View user profilehttp://www.tutorial-net.com

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

on Wed Apr 11, 2018 9:03 am
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)
Back to top
Permissions in this forum:
You cannot reply to topics in this forum