Nov 05, 2018
 Percona Live Open Source Database Conference Europe 2018
  Jaime Crespo

Query Optimization with MySQL 8.0 and MariaDB 10.3: The Basics

Tutorial on the foundations of query optimization to speed up query execution with MySQL 8.0 and MariaDB 10.3:

* Example database and environment setup
* Query profiling (what queries to optimize first?)
* Access types and basic indexing
- How indexes work to speed-up queries
- BTREE indexes
- EXPLAIN
- InnoDB peculiarities
* Multi-column indexing
- Column order
- Index condition pushdown
- Index_merge
* FULLTEXT indexing
* Join execution and optimization
- Nested-loop
- Other strategies and variants: MRR and hash joins
* Subquery issues
- Issues with subqueries in older versions
- Semi-Join execution and other optimizations



About the Author

Jaime Crespo

Jaime is the Senior DBA of the Wikimedia Foundation, managing Wikipedia databases.