MySQL 8.0 Version new features detailed introduction

MySQL development team announces MySQL 8.0.0 development milestone release (DMR) release! After that, someone might wonder why MySQL jumped from 5.x to 8.0. In fact, the MySQL 5.x series has lasted for many years, from the time it was acquired by Oracle to 5.1, and after the acquisition has been maintained at 5.x, such as 5.5,5.6,5.7 and so on. In fact, if according to the original release rhythm, 5.6.x can be regarded as 6.x,5.7.x as 7.x. So, just change the version naming method only.

MySQL is the standard configuration in many Web site technology stacks, is a popular open source database, has launched 8.0 of the first candidate release.

New features of MySQL 8.0 include:

Full out-of-the-box support for Unicode 9.0

Support for window functions and recursive SQL syntax, which in the past is impossible or difficult to write such a query statement

Enhanced support for native JSON data and document storage capabilities

MySQL 8.0 release, skipping multiple version numbers (starting from 5.5), because 6.0 modifications and 7.0 is used to keep the MySQL version of the cluster, so the version number of 8.0 is used.

Expected release date for MySQL 8.0

According to the MySQL policy "a new general" version of the release cycle is 18-24 months, MySQL does not commit to MySQL 8.0 release date. The most recent release of MySQL 5.7 was October 21 of 2015, so the official release of MySQL 8.0 may be in October 2017.

MySQL 8.0 Standardized Unicode path

Unicode, which is supported by default, is one of the biggest changes in MySQL 8.0. For a long time, MySQL has had many unresolved problems with Unicode. So, for MySQL 8.0来, a long-term plan is to fix as many of those persistent Unicode issues as possible.

MySQL 8.0 no longer sets Latin1 as the default encoding to prevent new users from using this problematic legacy option. UTF8MB4 is now recommended as the default character set for MySQL 8.0 and is designed to be faster than the UTF8MB3 character set that is not currently recommended, while also supporting more flexible sorting and case sensitivity.

Enhanced Unicode supports not only the non-western character set, but also the growing emoji expression.

MySQL 8.0 Support Window functions

Many implementations of the SQL language standard (such as Oracle, translator Note) Support window functions, which are capable of aggregating computations across multiple rows, and still allow access to individual rows from the query. In previous versions of MySQL, it was possible not to use window functions, but it was cumbersome and slow. To overcome this flaw, MySQL 8.0 implements the function of the window function through the standard SQL keyword over, somewhat like the implementation of its competitor PostgreSQL.

Another feature is the recursive common table expression, which allows you to recursively work with subqueries without using cursors or other workarounds that compromise performance.

MySQL 8.0 better supports document-based databases and JSON

MySQL 5.7 supports JSON, which allows MySQL to compete with native JSON and NoSQL databases. MySQL 8.0 extends support for JSON and performs better, adding the ability to return a range from a JSON query (like the function of the SQL statement "Top n"), as well as adding a new aggregation function to the same query statement, Semi-structured data that can be combined with MySQL native structured data and JSON.

Another improvement related to JSON includes the documentation store for MySQL. Reads and writes to the MySQL document store are transactionally consistent, allowing for a rollback of changes to the JSON data. The document data is stored in an open, Geojson format for geospatial data, and can be indexed so that it can be searched by the way it is picked up.

Other key features of MySQL 8.0

Other features of the MySQL 8.0 program update include:

Added more options for locking lines, such as skip locked and nowait two options. which

Skip locked allows the operation to not lock out those rows that need to be ignored; NoWait throws an error as soon as it encounters a row lock.

MySQL can scale up and down based on the total amount of available memory to better leverage the deployment of virtual machines.

Added the "Hide index" feature so that the index can become invisible in the query optimizer. Indexes are synchronized with data changes to tables after they are marked as unavailable, but the optimizer does not use them. Suggestions for using hidden indexes are available when you do not decide whether an index needs to be persisted.

Now you can download several versions of MySQL 8.0 windows,macos,linux, FreeBSD and Solaris, or you can download the source code. You can download them from the download page of the official website by visiting the developer candidate version.