MariaDB Optimizer - ongoing development and changes
summary
Covers ongoing improvements to the MariaDB query optimizer (derived from the original MySQL optimizer), focusing on updating its cost calculations for modern workloads. Describes adding JSON histograms and changes to the range optimizer, and highlights new tunable parameters that give users more control over query planning and performance.
AI-written summary · about
related talks
42mMariaDB and MySQL — What Statistics the Optimizer Uses
38mQuery Optimizer in MariaDB 10.0 — Now Even Without Indexes
38mQuery Optimizer in MariaDB 10.0 — Now Even Without Indexes
01h 30mMySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your Queries
28mMysql Optimizer Features in 5.7 and 8.0
19mJSON Support: news, non-news, and the bigger picture
30mMySQL Indexes and Histograms to Speed Up Your Queries
27mState of MariaDB