MySQL 8.0: What is New in Optimizer and Executor?

Tuesday 4:50PM-5:15PM

@ Room B4&B5

MySQL / MariaDB

25 minutes conference

Intermediate

Tracks:
Developer

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!


Speakers

Manyi Lu

Manyi Lu (Oracle)

Director of Software Development

Biography:

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.


Slides



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