Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

MySQL 8.0: what’s new in Optimizer

MySQL 8.0: what’s new in Optimizer

 4 October 12:20 PM - 1:10 PM @ Zürich 1
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
MySQL
Topics:
MySQL
Optimization
Fundamentals

Description

There are substantial improvements in optimizer in MySQL 5.7 & MySQL 8.0. Most noticeably, users can now combine relational data with noSQL using the new JSON features. Functional indexes are now supported through generated columns. We also made DBAs’ life easier with explain on a running query and query rewrite plugin. On the performance side, MySQL can avoid creating temporary tables for UNION ALL, enable range scans on IN queries with row value expressions, make use of condition filtering, and more as in 8.0 we have histograms, invisible indexes, common table expressions and we extended the JSON support.

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


Slides