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!
Speakers: Sergei Petrunia