What are the new features in MySQL 8.0

Editor to share with you what are the new features of MySQL 8.0. I hope you will gain a lot after reading this article. Let's discuss it together.

MySQL is currently the most trusted and widely used open source database platform. Ten of the ten most popular and high-traffic websites in the world rely on MySQL. MySQL 8.0 builds on this momentum by providing comprehensive improvements designed to enable innovative DBA and developers to create and deploy the next generation of Web, embedded, mobile and cloud / SaaS / PaaS / DBaaS application platforms on the latest generation of development frameworks and hardware.

What are the new features in MySQL 8.0?

1. The database now contains a transaction data dictionary.

two。 Comes with Atomic DDL statement support.

3. Enhance security and account management.

4. Improvement of resource management.

5. Several InnoDB enhancements.

6. New backup lock.

7. The default character set has changed from latin1 to utf8mb4.

8. Some JSON enhancements.

9. Use International Components for Unicode (ICU) to provide regular expression support.

10. The new error record now uses the MySQL component architecture.

Enhancements to 11.MySQL replication.

twelve。 Common table expressions (non-recursive and recursive) are supported.

13. There is an enhanced optimizer.

14. Additional window functions and so on.

After reading this article, I believe you have a certain understanding of the new features in MySQL 8.0. if you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!