MySQL 8.0: What is New in Optimizer and Executor?

Tuesday 4:50PM-5:15PM

@ Room B4&B5

MySQL / MariaDB

25 minutes conference



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' lives easier with invisible indexes, 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 JSON table function, aggregation functions and more. Come and learn about new features in MySQL 8.0!


Manyi Lu

Manyi Lu (Oracle)

Director of Software Development


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


  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(@)
  • +1-888-401-3401
  • +1-919-948-2863