Mysql Optimizer Features in 5.7 and 8.0 - Sree Harsha Ramanavarapu - FOSSASIA Summit 2017
Channel: FOSSASIA
Date: 19/03/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