Shulou(Shulou.com)05/31 Report--

This article will explain in detail what new features are released in MySQL 8.0 official version. The quality of the article is high, so Xiaobian shares it with you for reference. I hope you have a certain understanding of relevant knowledge after reading this article.

MySQL 8.0 release 8.0.11 has been released, MySQL 8 is officially 2 times faster than MySQL 5.7, and brings a lot of improvements and faster performance!

Note: Upgrading from MySQL 5.7 to MySQL 8.0 is supported only by using in-place, and downgrades from MySQL 8.0 to MySQL 5.7 (or from a MySQL 8.0 version to any earlier MySQL 8.0 version) are not supported. The only supported alternative is to back up the data before upgrading.

Here is a brief overview of the notable new features and improvements in MySQL 8.

1. MySQL 8.0 is twice as fast as MySQL 5.7. MySQL 8.0 delivers better performance for read/write workloads, IO-intensive workloads, and highly competitive ("hot spot" contention issues) workloads.

2. NoSQL: MySQL has been providing NoSQL storage since version 5.7, and this feature has been greatly improved in version 8.0. This feature eliminates the need for a separate NoSQL document database, and MySQL document storage provides multi-document transaction support and full ACID compliance for schema-less JSON documents.

3. Window Functions: Since MySQL 8.0, a new concept called window functions has been added, which can be used to implement several new query methods. Window functions are similar to aggregate functions such as SUM() and COUNT(), but instead of merging the results of a multi-row query into a single row, they put the results back into the multi-row. The window function does not require GROUP BY.

4. Hidden indexes: In MySQL 8.0, indexes can be "hidden" and "displayed." When an index is hidden, it is not used by the query optimizer. We can use this feature for performance debugging, for example, we hide an index and then observe its impact on the database. If the database performance has declined, this index is useful, and then it can be "restored to display"; if the database performance does not see changes, this index is redundant, you can consider deleting it.

5. Descending indexes: MySQL 8.0 provides support for indexes to be sorted in descending order, and values in such indexes are sorted in descending order.

6. Common Table Expressions (CTE): Use CTE to make query statements clearer when using embedded tables in complex queries.

7. UTF-8 encoding: Starting with MySQL 8, use utf8mb4 as the default character set for MySQL.

8. JSON: MySQL 8 significantly improves support for JSON, adding the JSON_EXTRACT() function to extract data from JSON fields based on path query parameters, and JSON_ARRAYAGG() and JSON_OBJECTAGG() aggregate functions to combine data into JSON arrays and objects, respectively.

9. Reliability: InnoDB now supports atomicity of table DDL, i.e. DDL on InnoDB tables can also achieve transaction integrity, either fail rollback or successfully commit, without partial success in DDL, and crash-safe features, metadata stored in a single transaction data dictionary.

10. High Availability: InnoDB clusters provide an integrated native HA solution for your database.

11. Security: OpenSSL improvements, new default authentication, SQL roles, password strength, authorization.

About MySQL 8.0 official release of the new features are shared here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.