Brussels / 30 & 31 January 2016

schedule

ANALYZE for statements: MariaDB's new tool for diagnosing the optimizer


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

Photo of Sergei Petrunia Sergei Petrunia

Attachments

Links