MySQL 8.0 New Features
summary
MySQL 8.0 (current stable 8.0.26) moves metadata into a data dictionary in InnoDB enabling millions of tables, sets utf8mb4 as the optimized default, and adds hash joins plus a NoSQL JSON document API based on protobufs. The new mysql shell with JS/Python/SQL supports parallel dump/load, clone-based fast replicas, router integration and listens on port 33060. Other practical changes: EXPLAIN ANALYZE runs the actual query, invisible indexes/columns, JSON Schema validation, binary log compression (zstd), random password creation, histograms and multi-value JSON indexes.
AI-written summary · about
chapters (25)
- 0:00Intro
- 1:55MySQL 5.6 EOL
- 2:14MySQL 8.0
- 4:04Data Dictionary
- 5:23Optimized for UTF8MB4
- 6:09Hash Joins
- 7:16MySQL as a NoSQL JSON Document Store Database
- 8:01MySQL Shell
- 10:29Invisible Index
- 11:17Invisible Column
- 13:23User Details
- 16:25Binary Log Compression
- 16:54Random Passwords
- 17:34EXPLAIN ANALYZE
- 19:13JSON Document Validation
- 21:35Constraint Checks
- 22:33Histograms
- 24:09CATS
- 25:05Better JSON Support including JSON_TABLEO
- 26:28Common Table Expressions or CTES
- 27:08Window Functions. More granular analysis
- 28:07InnoDB Cluster
- 29:17Replica Set
- 29:51Clone Plugin
- 32:55David Stokes
