Nov 06, 2018
 Percona Live Open Source Database Conference Europe 2018
  Marco Tusa

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.



About the Author

Marco Tusa

Marco has his own international practice for the past twenty seven years. His experience and expertise are in a wide variety of information technology and information management fields of application and cover research, development, analysis, quality control, project management and team management. Marco has move to Percona as manager of the Consulting Rapid Response Team on October 2013. Marco has moved from Italy to Ottawa, Canada in 2011 where he actually lives with his family. He has being working as employee for the SUN Microsystems as MySQL Professional Service manager for South Europe., and previously in MySQL AB. He has worked with the Food and Agriculture Organization of the United Nation since 1994, leading the development of the Organization’s hyper textual environment.Team leader for the FAO corporate database support. For several years he has led the development group in the WAICENT/Faoinfo team. He has assisted in defining the Organization’s guidelines for the dissemination of information from the technology and the management point of view. He has acted as coordinator between WAICENT and other departments; he has been a member of the FAO Information Management and Technology Committee since 1999. He designed and lead the development of some of the main web related FAO projects, and web publish architecture. He has participated in field missions in order to perform analysis, reviews and evaluation of the status of local projects, providing local support and advice.