Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MySQL Query Optimizer Overview

MySQL Query Optimizer Overview

 19 April 01:20 PM - 2:20 PM @ Ballroom C
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Development
Scalability/Performance
Topics:
MySQL
Optimization
Programming

Description

This presentation gives an introduction to the MySQL query optimizer. Knowing how queries are optimized and executed will help you write better performing queries. The main phases of the MySQL optimizer and the main optimization strategies are presented. Examples of optimization strategies that will be presented are query transformations, data access strategies, the range optimizer, the join optimizer, and subquery optimization. An overview of the cost model and how the optimizer does cost estimations are included. New optimizations introduced in MySQL 5.7 will be included in the presentation.

Speakers

Olav Sandstå's picture

Olav Sandstå

Senior Principal Software Engineer, Oracle

Biography:

Olav Sandstå is a Senior Principal Software Engineer in the MySQL group at Oracle, where he works on the MySQL Query Optimizer. Before joining the MySQL team he worked on performance improvements for the Apache Derby database. Prior to that he worked for 10 years on development of Clustra, a highly available DBMS. Olav has PhD from the database research group at the Norwegian University of Science and Technology.

Share this talk