Complete list of new features in MySQL 8.0

The following is a brief list of new features in MySQL 8.0 -

Transaction Data Dictionary

Transactions used to store information about objects Data Dictionary.

Atomic Data Definition Language

Atomic Data Definition Language (DDL) statements used to combine updates to data dictionaries, storage engine operations, etc.

Security Enhancements

The security level has been improved and DBAs (database administrators) gain greater flexibility in account management.

Encryption

Encryption defaults have been defined and table encryption is enforced globally. The 'default_table_encryption' variable is used to define the default encryption for newly created schemas. When creating a schema, you can define the schema's default encryption with the help of the "DEFAULT ENCRYPTION" clause.

InnoDB Engine

Changes to the InnoDB Engine - The value of the current maximum auto-increment counter is written to the "redo log" every time it changes.

JSON Enhancement

JSON Enhancement has improved MySQL's JSON functionality, including the addition of ->>', the inline path operator.

InnoDB support

In the new version, InnoDB supports parallel clustered index reading, which greatly improves CHECK TABLE performance. This feature does not apply to auxiliary index scans.

In the latest version, when the innodb_dedicated_server variable is enabled, The size and number of log files are configured based on the automatically configured buffer pool size. Previously, the log file size was configured based on the amount of memory that could be detected on the server, and the number of log files was not automatically configured.

The above is the detailed content of Complete list of new features in MySQL 8.0. For more information, please follow other related articles on the PHP Chinese website!