The following is a brief list of new features in MySQL 8.0 -
Transactions used to store information about objects Data Dictionary.
Atomic Data Definition Language (DDL) statements used to combine updates to data dictionaries, storage engine operations, etc.
The security level has been improved and DBAs (database administrators) gain greater flexibility in account management.
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.
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 has improved MySQL's JSON functionality, including the addition of ->>', the inline path operator.
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!