Sergei Petrunia

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.

This talk aims to cover everything about the current state of JSON support.

First, I'll cover the newest addition, JSON_TABLE in MariaDB 10.6.

Then, I'll discuss the power of JSONPath in MariaDB and how it compares to the SQL Standard and other databases. This is technically non-news but it hasn't been discussed before.

Finally, we'll take a look at other present and missing features and see what are the biggest and lowest-hanging fruits in JSON support in MariaDB.

MariaDB 10.1 has a new tool for diagnosing optimizer issues: ANALYZE for statements.

The talk with start with an introduction to ANALYZE [FORMAT=JSON] command. Then, I'll show how one can use ANALYZE to quickly pinpoint various kinds of optimizer issues. The talk is only 20 minutes long, but we will be able to solve multiple query optimization problems because ANALYZE command allows one to do it so quickly!

MariaDB 10.1 has a new tool for diagnosing optimizer issues: ANALYZE for statements.

The talk with start with an introduction to ANALYZE [FORMAT=JSON] command. Then, I'll show how one can use ANALYZE to quickly pinpoint various kinds of optimizer issues. The talk is only 20 minutes long, but we will be able to solve multiple query optimization problems because ANALYZE command allows one to do it so quickly!