Here’s a list of the TOP 10 MySQL 8.0 features for DBAs and OPS, with some detailed explanations of what they are and links to more information. The features covered are:
- Temporary Tables Improvements
- Persistent global variables
- No more InnoDB System Tables
- Reclaim UNDO space from large transactions
- UTF8 performance
- Removing Query Cache
- Atomic DDLs
- Faster & More Complete Performance Schema (Histograms, Indexes, …) and Information Schema
- ROLES
- REDO & UNDO logs encrypted if tablespace is encrypted