What's New in MySQL 8.0?
summary
MySQL 8.0 introduces a new data dictionary with corresponding changes to INFORMATION_SCHEMA and atomic DDL support, adds query features like Common Table Expressions, window functions, invisible and descending indexes, and improves Unicode handling. The release also provides flexible locking options for queries (SKIP LOCKED / NOWAIT), role-based privilege management, and enhancements to replication performance and features.
AI-written summary · about
chapters (12)
- 0:00MySQL 8.0 intro
- 1:21MySQL version overview
- 4:57New dictionary data
- 10:00Atomic DDL
- 21:23Query execution improvements
- 28:35Window functions
- 31:24Invisible and descending indexes
- 33:52Unicode 8.0 support
- 37:07Flexible locking
- 38:25Role-based privileges
- 39:54Replication enhancements
- 45:13Q&A
