OMG MySQL 8.0 is out! Are we there yet?
summary
MySQL 8.0 actually shows concrete wins: instant DDL that adds columns without table copies, real window functions and common table expressions for rowwise analytics and recursive queries, and invisible indexes to test index impact. Defaults change too — UTF8MB4 collation and binary logging enabled — and there's a new scheduler algorithm (Kits/CATs style) and JSON diff updates; demos and benchmarks report multi‑fold throughput or millisecond schema changes.
AI-written summary · about
chapters (14)
- 0:00Start
- 5:06New default Charset
- 7:16Other defaults & variables
- 8:59Transaction Scheduling
- 12:21ALGORITHM INSTANT
- 15:04Invisible Indexes
- 17:41Descending Indexes
- 21:42What they do?
- 22:27Window Functions
- 25:46Named Windows!
- 31:02Common Table Expressions
- 31:53Rank episodes by million viewers
- 36:05Recursive CTE
- 37:12Fibonacci
