Key New Features of MySQL 8

Key New Features of MySQL 8

MySQL's eighth version is coming soon and is expected to be released in 2018. Within 28 months after MySQL 5.7.9's first general-purpose version was launched, MySQL 8 released five candidate versions from 8.0.0 to 8.0.4. These Release Candidates are only for development and use, and should not be used in the production system. Because these candidate versions do not support version upgrades, users may encounter the problem of incompatible data formats between candidate versions and general available (GA) versions.

First, you may notice that a jump occurs on the version number. This is because MySQL discards version 6 and uses version 7 for enterprise product lines.

Window Function is the most interesting feature in MySQL 8. Other database engines have implemented this feature. Window functions perform aggregation operations on a series of query rows, and generate results for each row to aggregate peripheral data.

Similar to a window function, recursive CTE (Common Table Expressions) allows users to execute subqueries that reference themselves without using a cursor. This slide details this feature.

The default Character Set of MySQL 8 is also supported from "Latin1" to "utf8mb4 ". Utf8mb4 supports up to four bytes of each character. It is the preferred character set for many applications because it supports most extended collation (for example,utf8mb4_ja_0900_as_csAnd emoji characters. In terms of storage, the default storage engine of MySQL 8 will use InnoDB.

The hidden index allows DBA to set an index not to be considered by the query optimizer. This feature is used to test the impact of a specified index on query performance. You can restore the visibility of an index in query optimization before you enable the index. MySQL 8 also greatly improved its support for JSON, and added a path-based query parameter to extract data from JSON fields.JSON_EXTRACT()Function, and is used to combine data into a JSON array and an object respectively.JSON_ARRAYAGG()AndJSON_OBJECTAGG()Aggregate functions.

MySQL 8 provides flexible role support, supports CREATE, DROP, and GRANT roles, and can even assign one role to another, it also limits the availability of available roles in MySQL 8 for each session or host. You can also call the ROLES_GRAPHML () function to visualize the role GraphML.

MySQL 8 was planned to be released in October 2017, but 8.0.4 RC was not released in January 23, 2018. It seems that at least two candidate versions need to be released before the GA version is officially launched.

Best New Features of MySQL 8

This article permanently updates link: https://www.bkjia.com/Linux/2018-03/151251.htm