conferences | speakers | series

Improved histograms in MariaDB 10.8

home

Improved histograms in MariaDB 10.8
FOSDEM 2022

MariaDB 10.8 is getting improved histograms, called JSON_HB. This talk will cover - what the new histograms are, - what are the advantages over the old histograms, - how do they compare to histograms in MySQL 8.

At the end of the talk, I'll cover a closely related topic of usage of the histogram data in the query optimizer: - why this is hard, - what are known limitations and their workarounds - what MariaDB team is doing to improve this.

Speakers: Sergei Petrunia