MySQL 8.0

on YouTube ↗41m

" summary

MySQL 8.0 adds concrete, testable features not marketing fluff: window functions and CTEs for ranking, lag/lead and recursive tree queries; role-based user management and utf8mb4 default for emoji and accents; contention aware transactions claiming ~5x lower latency under load; generated defaults (UUID into BINARY) and a demoed instant ADD COLUMN that completes on a 50M-row table in ~0.26s; invisible and descending indexes flip optimizer plans instantly; check constraints and binary logging-on-by-default enable safer upgrades.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 0:48About MySQL
3. 4:50Performance
4. 7:24Create Table
5. 11:52Variables
6. 15:37Check Constraint
7. 20:37Index Visibility
8. 24:02Instant Columns
9. 25:29Window Functions
10. 32:22Cognitive Expressions
11. 37:28Lateral Join

" related talks

• 55mMySQL 8.0: Not Only Good, it's GREATGabriela D'Avila Ferrara · PHP UK Conference 2019
• 42mOMG MySQL 8.0 is out! Are we there yet?Gabriela D'Avila Ferrara · Laracon EU 2018
• 36mOMG MySQL 8.0 is out! Are we there yet?Gabriela D'Avila Ferrara · Dutch PHP Conference 2018
• 53mWhy are we excited about MySQL 8?Petr Zaytsev · HighLoad++ 2017
• 37m8.0 New FeaturesDave Stokes · Open Source 101 at Home 2020
• 28mMysql Optimizer Features in 5.7 and 8.0Sree Harsha Ramanavarapu · FOSSASIA Summit 2017
• 34mMySQL 8.0 New FeaturesDave Stokes · Open Source Summit + Embedded Linux Conference + OSPOCon 2021
• 52mWhat's New in MySQL 8.0?Dmitriy Lenev · РИТ++ 2017