Query Optimization with MySQL 8.0 and MariaDB 10.3: The Basics

Monday 9:00AM - 12:00PM

@ Dow

MySQL/MariaDB

3 hours tutorial

Beginner

Tracks:
Tutorial

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


Speakers

Jaime Crespo

Jaime Crespo (Wikimedia Foundation)

Sr Database Administrator

Biography:

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


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863