During a performance investigation, it is of course necessary to try to optimize queries in the first place because often, as demonstrated, it is these that most affect the performance of MySQL, no matter which version we use on a server.
When we maximize our queries and our data model is well organized, we can look at the question of MySQL configuration and try to improve the most important variables that could help MySQL performance.
Keep in mind that you have to change one thing at a time, especially if you already have a solid configuration. If this is a new configuration, or if you have worked with the default configuration until now, do not implement all the changes at once. Take the time to monitor the server after each change.
So, let's explore the most popular variables that affect the overall performance:
- innodb_buffer_pool_size...