Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Optimizer: What’s New in 5.7, JSON and More.....

Optimizer: What’s New in 5.7, JSON and More.....

 21 April 11:00 AM - 11:50 AM @ Ballroom C
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Development
Scalability/Performance
Topics:
MySQL
Optimization
NoSQL

Description

There are substantial improvements in optimizer in MySQL 5.7. Most noticeably, users can now combine relational data with noSQL. A new JSON datatype has been introduced. Users can easily search and manipulate JSON documents with the help of built-in JSON functions. Functional indexes are now supported through both stored and virtual generated columns. On the performance side, MySQL can avoid creating temporary tables for UNION ALL, do more-efficient sorting, enable range scans on IN queries with row value expressions, make use of condition filtering, and more. Beyond performance improvements, DBAs’ lives now become easier. It is possible to run EXPLAIN on a running query, and MySQL provides a new query rewrite plug-in for handling potential performance regressions. Come to this session to learn how you can leverage these new features. We will also take a sneak peek at 5.8 at the end.

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