Explore the latest features of MySQL 8.0 in this informative 34-minute conference talk by Dave Stokes from Oracle. Learn about the end-of-life for MySQL 5.6, the new data dictionary, UTF8MB4 optimization, and hash joins. Discover MySQL's capabilities as a NoSQL JSON document store database and the introduction of the MySQL Shell. Delve into invisible indexes and columns, enhanced user details, binary log compression, and random password generation. Gain insights on EXPLAIN ANALYZE, JSON document validation, constraint checks, histograms, and improved JSON support including JSON_TABLE. Understand common table expressions (CTEs), window functions for granular analysis, InnoDB Cluster, Replica Set, and the Clone Plugin. This comprehensive overview equips database professionals with knowledge of MySQL 8.0's powerful new functionalities and improvements.
Overview
Syllabus
Intro
MySQL 5.6 EOL
MySQL 8.0
Data Dictionary
Optimized for UTF8MB4
Hash Joins
MySQL as a NoSQL JSON Document Store Database
MySQL Shell
Invisible Index
Invisible Column
User Details
Binary Log Compression
Random Passwords
EXPLAIN ANALYZE
JSON Document Validation
Constraint Checks
Histograms
CATS
Better JSON Support including JSON_TABLEO
Common Table Expressions or CTES
Window Functions. More granular analysis
InnoDB Cluster
Replica Set
Clone Plugin
David Stokes
Taught by
Linux Foundation
