Vicentiu Ciorbaru (MariaDB Foundation) delivers the talk, "MariaDB and MySQL - What Statistics Optimizer Needs Or When and How Not to Use Indexes", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

When your SQL query reaches the DBMS, it's the optimizer's job to decide how to execute it for you to get the result as fast as possible. To make this decision optimizer can examine the actual table data, but with multi gigabyte and terabyte tables, the only practical solution is to use various data statistics that were collected in advance. The better the statistics and the more precisely it describes the actual data, the faster the plan will be because the optimizer image of reality will be closer to the actual reality.

In this talk, you'll learn what data statistics MariaDB and MySQL can collect, what statements do that, how to tell the optimizer to use it (it won't necessarily do it automatically!) and how it can make your queries many times faster.

And, of course, when not to use indexes, when up-to-date statistics is enough.


Related Videos: Percona Live Sessions, MariaDB, MySQL, Big Data, Performance Optimization

Optimize and Troubleshoot MySQL using PMM
Using PMM to Identify and Troubleshoot Problematic MySQL Queries
MariaDB Observability
Google Cloud Platform: MySQL at Scale with Reliable HA
Analytical Queries in MySQL - PLO October 2020
MySQL Ecosystem on ARM - Krunal Bauskar - Percona Live ONLINE 2020
How Does Geo-Replication Work in TiDB? - Jay Lee - Percona Live ONLINE