Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL 8.0: What is New in the Optimizer?

MySQL 8.0: What is New in the Optimizer?

 25 April - 1:20 PM - 2:10 PM @ Ballroom C
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Developer
Topics:
MySQL
Optimization
NoSQL

Description

There are substantial improvements in the Optimizer in MySQL 8.0. Most noticeably, we have added support for advanced SQL features like common table expressions, windowing functions and grouping() function. We also made DBAs’ life easier with invisible index, and additional hints that can be used together with the query rewrite plugin. On the performance side, cost model changes will make a huge impact. We have made JSON support even more powerful by adding functions requested by our users. Come and learn about new features in MySQL 8.0!

Speakers

Manyi Lu's picture

Manyi Lu

Director Software Development, Oracle

Biography:

I have 15 years experience in the database field. I am currently working as senior engineering manager at Oracle, heading the MySQL optimizer team. Previously, I held various positions both as product manager and engineering manager at Sun Microsystems.

Share this talk