Shulou(Shulou.com)06/01 Report--

MySQL 8.0 for Windows v8.0.11 official Free official Edition 64-bit

Data Dictionary (Data dictionary)

1) merging transactional data dictionaries that store database object information; previous versions were stored in metadata files and non-transactional tables

Atomic data definition statement (atomic DDL) (Atomic Data Definition Statements (Atomic DDL))

III. Security and account management (Security and account management)

1) A new caching_sha2_password authentication plugin is available (a new cachingsha2password authentication plug-in is available)

2) MySQL now supports roles, which are named collections of privileges (MySQL supports roles, which are named privilege sets)

3) MySQL now maintains information about password history, enabling restrictions on reuse of previous passwords (MySQL now maintains information about password history, allowing restrictions on the reuse of previous passwords)

4) MySQL now supports FIPS mode (MySQL now supports FIPS mode)

IV. Resource Management (Resource management)

1) you can create and manage resource groups and assign threads running by the server to specific groups, allowing threads to execute according to the resources available to the group

Fifth, InnoDB enhancement (InnoDB enhancements.)

1) automatically increase the count to write to the redo log to make the server persistent when the server is restarted

2) when the index number is destroyed, InnoDB will write a corruption flag in the redo log.

3) the InnoDB memcached plug-in supports multiple get operations (retrieving multiple key / value pairs in a single memcached query) and range queries

4) A new dynamic configuration option to control InnoDB deadlock detection, through which innodb_deadlock_detect can disable deadlock detection, and rely on innodb_lock_wait_timeout to set timeout transaction rollback to avoid affecting the normal operation of other transactions.

5) the number of index pages cached in the InnoDB buffer pool where each index is saved by INFORMATION_SCHEMA.INNODB_CACHED_INDEXES

6) all InnoDB temporary tables share the same temporary table space ibtmp1.

7) InnoDB tablespace encryption feature supports encryption of redo log and undo log data

8) InnoDB supports read statements locked by NOWAIT and SKIP LOCKED because of SHARE or UPDATE; NOWAIT indicates that the lock is returned immediately; SKIP LOCKED indicates that a multi-locked row returns the result

9) add partition, delete partition, merge partition, reconstruct partition, rebuild partition

10) the mysql storage engine uses a data dictionary instead of storing the engine's own data dictionary

11) mysql data dictionary and system tables create a single InnoDB tablespace file mysql.ibd under the mysql data directory

6. Character set support (Character set support)

1) The default character set has changed from latin1 to utf8mb4; default character set utf8mb4

7. Add JSON (json enhancements) AND OpenGIS spatial types

1) mysql provides a lot of json-related functions and API interfaces

8. Optimization program (Optimizer.)

1) MySQL now supports invisible indexes, which supports hidden indexes, which can be used to test whether the indexes created are optimized.

2) MySQL now supports descending indexes, adding descending index to speed up sorting related queries

9. (Common table expressions)

Window function (Window functions)

Regular expressions (Regular expression support)

Internal temporary Table (Internal temporary tables)

1) The TempTable storage engine replaces the MEMORY storage engine as the default engine for in-memory internal temporary tables

XIII. Log (logging)

1) which log components can be enabled through log_error_services; error logs are rewritten

14. Backup lock (Backup lock)

A new backup lock allows DML during online backups while preventing operations that may lead to inconsistent snapshots

Summary

The above is the introduction of the new features of the MySQL8.0.11 version introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.