MySQL 8 advance tuning with Resource Group
MySQL 8 introduces a feature that is explained in a single document page, but that can help a lot if correctly used.
It is well hidden, in the optimization: optimizing of the MySQL server chapter.
I am talking of Resource Groups.
Resource groups permit assigning threads running within the server to particular groups so that threads execute according to the resources available to the group.
Group attributes enable control over its resources, to enable or restrict resource consumption by threads in the group. DBAs can modify these attributes as appropriate for different workloads.
This small simple feature can be a blast in case you have contention between different type of load on your database.
The simplest example is a combination of OLTP/OLAP or OLTP/ETL.
In this presentation, I will illustrate the feature and how it can be easily and successfully implement.
Also covering those contexts, like large enterprises, where code dynamic is not as agile as we would like to be.