MySQL 8.0 and comparison with MySQL 5.7

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.

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.