Online / 5 & 6 February 2022

visit

Improved histograms in MariaDB 10.8


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

Photo of Sergei Petrunia Sergei Petrunia

Links