Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL 8.0 Optimizer Guide

MySQL 8.0 Optimizer Guide

 24 April - 1:30 PM - 4:30 PM @ Ballroom E
Experience level: 
Beginner
Duration: 
3 hours tutorial
Tracks:
Developer
Topics:
MySQL
Optimization
Fundamentals

Description

Many users who follow MySQL development are aware that recent versions introduce a number of improvements to query execution (via the addition of new execution strategies, and an improved cost model). But what is not talked about enough, is that the diagnostic features are also significantly better. For example, since EXPLAIN FORMAT=JSON shows cost information, it is possible to have an x-ray view of how decisions are being made internally. This in-turn actually makes teaching query optimization easier as well! This tutorial takes a fresh look at how to optimize queries using features that may not be available in earlier versions (hence the title MySQL 8.0). The content comes from www.unofficialmysqlguide.com, and examples will use EXPLAIN FORMAT=JSON, Optimizer Trace and Visual Explain on a small sample database.

Speakers

Morgan Tocker's picture

Morgan Tocker

MySQL Product Manager, Oracle

Biography:

Morgan works on the product management team at Oracle, and is responsible for the MySQL Server.

Share this talk