Why are we excited about MySQL 8?
summary
MySQL 8 introduces a native data dictionary so DDL becomes atomic and schema lookups are hundreds to thousands of times faster, invisible and descending indexes let teams test index changes safely, and a new temp-table engine plus separate undo tablespaces reduce long-transaction pain. Security gains include role-based privileges, password-history enforcement and a faster authentication plugin; replication gains parallel-applier improvements. Persistent auto_increment values, persistent global variables and improved JSON partial updates make upgrades and high‑concurrency ops far more predictable.
AI-written summary · about
chapters (30)
- 0:00Introduction to MySQL 8
- 1:51Native data dictionary
- 6:29UTF8MB4 and emojis support
- 7:34Security improvements
- 11:10Auto-increment persistence
- 12:14Undo tablespace cleanup
- 14:40Autotuning for SSDs
- 15:42JSON document updates
- 16:02Invisible indexes
- 17:08Temporary table storage engine
- 18:13Backup-safe operations
- 19:17Optimizer histograms
- 20:21Performance Schema upgrades
- 21:27Fake indexes in optimizer
- 22:53Performance Schema views
- 23:55Persistent global variables
- 25:03Default SSD optimizations
- 26:09Binary log retention
- 26:32Cache removal impact
- 26:55Batch operations improvements
- 27:38Resource groups
- 29:08Multi-threaded performance
- 31:21SKIP LOCKED feature
- 32:04Descending order indexes
- 32:28JSON functions at SQL level
- 33:51JSON array expressions
- 34:13Window functions support
- 35:58GIS and spatial features
- 36:42Document store interface
- 37:26Q&A session
