What Is New in MySQL 8.0
|Feature||Mysql 5.7||Mysql 8.0|
|Data Dictionary||Stored in metadata files and non-transactional tables||Transactional data dictionary that stores information about database objects.|
|Atomic Data Definition Statements (Atomic DDL)||————-||Dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic transaction combined by an atomic DDL statement.|
|Security and Account management||1. MyISAM (nontransactional) grant tables||1. InnoDB (transactional) grant tables.|
|2. Account-management statements (such as CREATE USER or DROP USER) for naming multiple users could succeed for some users and fail for others.||2. Each statement is transactional and either succeeds for all named users or rolls back and no effect if any error occurs.|
|3. mysql_native_password plugin.||3.caching_sha2_password authentication plugin is available. Like the sha256_password plugin.|
|4. Not supported.||4. MySQL now supports roles, which are named collections of privileges.|
|5. Single password for each account.||5. Accounts are now permitted to have dual passwords.|
|Resource management||Not supported||1. Creation and management of resource groups.
2. Threads can be assigned to particular groups running within the server so that threads execute according to the resources available to the group.
|Character Set support||Default character set : latin1||Default character set : utf8mb4|
|Data Type support||Use of expressions as default values for the BLOB, TEXT, GEOMETRY, and JSON data types.|
|Indexes Visibility||Supports only visible indexes.||Now supports invisible indexes.|
And many more features and enhancements.