State of the Dolphin
summary
MySQL 8.0 adds document-first features and operational tooling: the JSON_TABLE function maps JSON into relational rows so SQL can join and index document fields, CTEs and window functions handle adjacency/analytics, and utf8mb4 optimizations claim 3–15× string performance. Operational features include invisible indexes that stay maintained while hidden for safe drop testing, skip-locked/no-wait row locks to avoid contention, a crash-safe data dictionary, histograms in the optimizer, resource groups, and a lab claim of >1M TPS lab result.
AI-written summary · about
chapters (20)
- 0:00Introduction
- 0:33Example venue
- 1:11Data model
- 2:01Location
- 2:42Distance
- 3:18Emoji
- 4:04Character
- 4:23Developer
- 6:19InDesign
- 9:35JasonTable
- 10:28Datadriven
- 10:52Common Table Expressions
- 11:25Use of Table Expressions
- 12:18Use of Functions
- 13:18Avoid Confrontation
- 15:08Operations
- 16:49Monitoring
- 19:31Performance Improvements
- 22:08Resource Groups
- 23:57Release Candidate
