ANALYZE for statements: MariaDB’s hidden gem
This video was presented at the MariaDB Server Fest, held online from 14-20 September 2020.
Q&A links
Other links
Abstract
Do you know about MariaDB’s ANALYZE for statements feature? It is a must if you need to analyze the performance of complex queries. It is very easy to use. This talk will give a lightning-fast introduction to the feature and show how one can quickly use it to pinpoint query performance problems. At the end of the talk we’ll compare with MySQL’s EXPLAIN ANALYZE feature, which was introduced last year.
Presenter
Sergei Petrunia is query optimizer developer at MariaDB Corporation. He has implemented the ANALYZE feature in MariaDB, and contributed to Optimizer Trace, Window Functions, subquery optimizations, and other query optimizer features.
Date and time
- Paris: Monday 14 September, 12.30 – 13.00 CEST (UTC +2)
- New York: Tuesday September 15, 14.35 – 15.05 / 2.35pm – 3.05pm EDT (UTC -4)
- Beijing / Singapore: Sunday 20 September, 16.40 – 17.05 CST / SGT (UTC +8)