Improved histograms in MariaDB 10.8
summary
MariaDB 10.8 introduces a new histogram implementation called JSON_HB; the talk explains how these histograms work and what benefits they bring compared with MariaDB’s previous histograms. It also compares JSON_HB to MySQL 8’s histogram features and discusses how histogram data is used by the query optimizer, including practical difficulties, known limitations with possible workarounds, and ongoing improvements by the MariaDB team.
AI-written summary · about
related talks
45mHistograms in MySQL and MariaDB
35mMySQL Indexes and Histograms to Speed Up Your Queries
50mDiagnosing Database Issues With MySQL 8.0’s Performance Schema
01h 30mMySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your Queries
19mJSON Support: news, non-news, and the bigger picture
30mMySQL Indexes and Histograms to Speed Up Your Queries
42mMariaDB and MySQL — What Statistics the Optimizer Uses
34mMySQL 8.0 New Features