8.0 New Features
summary
MySQL 8.0 lists concrete, usable changes: EXPLAIN ANALYZE runs the query and reports expected versus actual to find optimizer mismatches; the clone plugin copies InnoDB tablespaces extremely fast for provisioning replicas; improved hash joins and multi-value indexes speed equi-join and JSON-array lookups; JSON Schema validation rejects bad documents at insert time; check constraints and dual-passwords ease migrations; binary-log compression and a new double-write buffer reduce IO and latency; MySQL Shell and connectors now support upgrade checks and parallel bulk loading.
AI-written summary · about
chapters (25)
- 0:00Start
- 1:45Upgrade Checker
- 4:47Agenda
- 9:40Binary Log Compression
- 10:56Alter User
- 11:21Tables and Row Syntax
- 12:29Random Passwords
- 13:30Hash Joints
- 15:15Explain Analyze
- 16:14Multivalued Indexes
- 16:39Multi Value Indexes
- 17:02Json
- 18:52Dual Passwords
- 20:43Mysql Upgrade Script
- 21:27Constraint Checks
- 22:44Admin Tcp / Ip Port
- 23:28Sub Queries
- 25:00Histograms
- 25:59Partial Updates
- 27:27Inner Db Cluster
- 28:29Clone Plugin
- 29:05New Shell
- 32:08Bulk Loader
- 32:43Parallel Bulkloader
- 34:37Performance Problems Caused by Mutexes
