This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Click and register at Eventbrite
View analytic
Friday, April 4 • 16:00 - 16:45
P158 MySQL EXPLAIN Explained

Sign up or log in to save this to your schedule and see who's attending!

The EXPLAIN command of MySQL is a very useful tool for understanding how MySQL will execute a query. Understanding how to interpret the information from the EXPLAIN command is essential to get good performance from your MySQL database server.

The format of the query execution plan (QEP) presented by MySQL EXPLAIN is very different from an Oracle, this presentation will give Oracle DBAs a basic understanding of to use this information to tune a MySQL environment.

The presentation we will cover a lot of different examples of how to take advantage of the output from MySQL EXPLAIN to improve your MySQL system.

avatar for Øystein Grøvlen

Øystein Grøvlen

Oracle NO
Øystein Grøvlen is a Senior Principal Software Engineer in the MySQL group at Oracle, where he works on the MySQL Query Optimizer. Dr. Grøvlen has a PhD in Computer Science from the Norwegian University of Science and Technology. Before joining the MySQL team 5 years ago, he was a contributor on the Apache Derby project and Sun's Architectural Lead on Java DB. Prior to that, he worked for 10 years on development of... Read More →

Friday April 4, 2014 16:00 - 16:45
Congress 3 Color Magic