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

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.