MariaDB and MySQL — What Statistics the Optimizer Uses

on YouTube ↗42m

" summary

Explains which table and column statistics MariaDB and MySQL optimizers use to estimate query costs and choose execution plans. Covers types of collected statistics (histograms, cardinality, NULL counts, etc.), how they are gathered and stored, and how better statistics lead to more accurate planner decisions for large multi‑gigabyte tables.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 2:16MySQL stats problems
3. 7:32MariaDB solution
4. 10:03Stats demo
5. 13:39Histogram benefits
6. 18:15Sampling extrapolation
7. 20:36Summary and new features
8. 23:53Q&A

" related talks

• 35mMySQL Indexes and Histograms to Speed Up Your QueriesDavid Stokes · Data Con LA 2021
• 30mMySQL Indexes and Histograms to Speed Up Your QueriesDave Stokes · CakeFest 2022
• 38mQuery Optimizer in MariaDB 10.0 — Now Even Without IndexesSergey Golubchik · HighLoad++ 2013
• 45mHistograms in MySQL and MariaDBSergei Petrunia · Percona Live Open Source Database Conference 2017
• 54mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013
• 01h 30mMySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your QueriesDave Stokes · All Things Open 2020
• 38mQuery Optimizer in MariaDB 10.0 — Now Even Without IndexesSergey Golubchik · HighLoad++ 2013
• 57mPerformance Analysis and Optimization of MySQLPetr Zaytsev · HighLoad++ 2013