Mysql Optimizer Features in 5.7 and 8.0 - Sree Harsha Ramanavarapu - FOSSASIA Summit 2017

Published on: Sunday, 19 March 2017

Speaker(s): Sree Harsha Ramanavarapu (Bangalore)

Abstract:
New Optimizer features in MySQL 5.7:* Enabling users to combine relational database and NoSQL data through the new JSON datatype and supporting functions.* Generating column values on the fly without storing them in the tables using generated columns.* Utilizing functional indexes on generated columns to index parts of the JSON data.Sneak peek of the optimizer features in the MySQL 8.0 labs release:[Recursive] Common Table Expressions:* Enable users to write complex queries through the support of Common Table Expressions with recursive feature.Performance Improvements:* Improved performance through support for descending indexes which generate new query plans thus avoiding sorting operations.* A new pre-fetch buffer based on optimizer estimate helps enhance storage engine's capability to fetch more number of rows in a single operation.Enhancements:* UUID values can now be stored as BINARY(16) datatype.* The bitwise operations have been extended to BINARY/BLOB datatypes thus supporting bit wise operation even on large values like IPV6 addresses.* Invisible indexes to help DBAs to evaluate the impact on performance when an index is dropped without actually dropping it.

(Type: Talk | Track: Database - MySQL Day | Room: Curie & Hershel (Floor 2))

Event Page: http://2017.fossasia.org

Produced by Engineers.SG

Organization