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

MySQL 8.0 official version 8.0.11 has been released, and officials say MySQL 8 is twice as fast as MySQL 5.7. it also brings a lot of improvements and faster performance!

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

MySQL 8.0 is a very exciting new version of the world's most popular open source database. Some key enhancements include:

SQL window functions, common table expressions, NOWAIT and SKIP LOCKED, descending indexes, grouping, regular expressions, character sets, cost models and histograms.

JSON extended syntax, new features, improved sorting and partial updates. Using the JSON table function, you can use the SQL mechanism for JSON data.

GIS Geographic support. Spatial reference system (SRS), as well as SRS-aware spatial data types, spatial indexing and spatial functions.

Reliability DDL statements have become atomistic and crash-safe, and metadata is stored in a single transaction data dictionary. Supported by InnoDB!

Significant enhancements in observability performance architecture information architecture configuration variables and error logging.

Manageable remote management, undo table space management and new real-time DDL.

Security OpenSSL improvements, new default authentication, SQL roles, decomposition super privileges, password strength, and so on.

Performance InnoDB is significantly better in terms of read / write workloads, IO binding workloads, and highly contended "hot" workloads. Resource group feature has been added to provide users with an option to optimize for specific workloads on specific hardware by mapping user threads to CPU

Some highlights are described above, and I encourage you to delve further into the complete series of milestone blog posts- 's 8.0. 0. 1, 8. 0. 1, 8. 0. 2, 8. 0. 3 and 8. 4-and even further down the personal work log and its specifications and implementation details. Or you may just want to look at the source code on github.com/mysql.

Developer function

MySQL developers need new features, and MySQL 8.0 provides many new and more demanding features in areas such as SQL,JSON, regular expressions, and GIS. Developers also want to be able to store Emojis, so UTF8MB4 is now the default character set in 8.0. Finally, the data type has been improved, bitwise operations have been performed on the BINARY data type, and IPv6 and UUID capabilities have been improved.

The following is a brief introduction to the new features and improvements in MySQL 8 that are worth watching.

1. Performance: MySQL 8.0 is twice as fast as MySQL 5.7s. MySQL 8.0 brings better performance in the following areas: read / write workloads, IO-intensive workloads, and highly competitive ("hot spot" hot competitive issues) workloads.

2. NoSQL:MySQL began to provide NoSQL storage function in 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 complete ACID compliance for JSON documents in schema-less schema.

3. Window function (Window Functions): since MySQL 8.0, a new concept called window function has been added, which can be used to implement several new query methods. The window function is similar to aggregate functions such as SUM () and COUNT (), but instead of merging the results of multiple rows of queries into one row, it puts the results back into multiple rows. That is, the window function does not need GROUP BY.

4. Hidden indexes: in MySQL 8.0, indexes can be "hidden" and "shown". When the 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 there is a decline in database performance, the index is useful, and then it can be "restored to display"; if there is no change in database performance, the index is redundant and can be deleted.

5. Descending indexes: MySQL 8.0 provides support for sorting indexes in descending order, and values in this index are also sorted in descending order.

6. Common table expressions (Common Table Expressions CTE): when using embedded tables in complex queries, use CTE to make the query statement clearer.

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

8. JSON:MySQL 8 has greatly improved support for JSON, adding the JSON_EXTRACT () function to extract data from the JSON field based on path query parameters, and the JSON_ARRAYAGG () and JSON_OBJECTAGG () aggregate functions for combining data into JSON arrays and objects, respectively.

9. Reliability: InnoDB now supports the atomicity of the table DDL, that is, the DDL on the InnoDB table can also achieve transaction integrity, either failed rollback or successfully committed, avoiding the partial success of DDL. In addition, it also supports the crash-safe feature, in which metadata is stored in a single transaction data dictionary.

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

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

These are the details of the latest version of mysql, please pay attention to other related articles!

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.