OMG MySQL 8.0 is out! Are we there yet?
summary
MySQL 8.0 makes concrete changes you can use now: utf8mb4 as the default charset, binary logging on by default and a new auth plugin using TLS, plus a dedicated-server tuning mode. A new transaction scheduler (CATS) boosts throughput roughly threefold and cuts latency about fivefold under contention. You get invisible indexes that toggle without table rebuilds, true descending index scans, window functions and recursive CTEs (Fibonacci demo), atomic DDL with a transactional data dictionary, JSON partial updates, roles, instant ADD COLUMN, better UUID and geo support and a NoSQL X DevAPI.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 6:58Transaction scheduling
- 10:21Invisible indexes
- 16:08Functions
- 23:44Common Table Expressions
- 24:32Ranking
- 26:43Recursive City
- 31:19Recursion
- 32:04Other bits
