Gabriel Ciciliani
MySQL Principal Consultant
Actions
Gabriel has been dedicated to databases as a DBA and consultant for the last 16 years. He has lead and participated in multiple projects across many technologies, including Oracle, MySQL, SQL Server and MongoDB. Gabriel defines himself as an automation super fan and he contributed to the development of two custom DBaaS platforms.
Gabriel holds a college degree in electronics, a degree in industrial engineering and a master's degree in information systems engineering. He is also a GCP, Oracle and Microsoft certified professional. Currently he is and independent Consultant specializing in MySQL/MariaDB/Percona Server query optimization
All things optimizer statistics
Statistics are key to optimal execution plans: is all the server relies on when building an execution plan in a handful of milliseconds.
This is more than a good reason to learn about what's collected, why and how this data is used.
Finally, we are also going to go over relevant parameters and MariaDB specific features.
Let's Talk About Query Tuning
Regardless of development frameworks, despite linters, besides countless sessions with the DBA, slow queries always end up making it to production. Proactive and reactive slow query tuning is still critical to ensure poorly written queries aren’t undermining server performance and wasting valuable compute resources. Cloud-based database managed services are not the exception: slow query root cause analysis requires human intervention. In this session I will discuss why slow query tuning is more relevant than ever, how to detect problems and guidelines to fix them.
Execution plans: Unrated
Knowing how MariaDB plans to execute a query enable us to spot performance problems in advance.
A small group of tools are available for this purpose, although understanding the information presented is not always straightforward.
In this session, we are going to familiarize with these tools, analyze the meaning of the information presented in detail and study real world cases to apply what we learned.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top