"MySQL"-MySQL 8.0 official edition new Highlights

MySQL 8.0 official version 8.0.11 has been released, the official said MySQL 8 than MySQL 5.7 twice times faster, but also brought a lot of improvements and faster performance!

Note: Upgrading from MySQL 5.7 to MySQL 8.0 is only supported by using the In-place method and does not support downgrading from MySQL 8.0 to MySQL 5.7 (or downgrading from one MySQL 8.0 version to any earlier MySQL 8.0 Version). The only supported alternative is to back up the data before the upgrade.

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

1. Performance: MySQL 8.0 is twice times faster than MySQL 5.7. MySQL 8.0 brings better performance in the following areas: Read/write workloads, IO-intensive workloads, and high-competition ("Hot spot" hotspot competition issues) workloads.

2. Nosql:mysql provides NoSQL storage functionality from version 5.7, which is now being improved in the 8.0 release. This feature eliminates the need for a standalone NoSQL document database, and the MySQL document store also provides multi-document transaction support and full ACID compliance for JSON documents in schema-less mode.

3. Windowing function (Window Functions): Starting with MySQL 8.0, a new concept called Window function, which can be used to implement several new query methods. The window function is similar to SUM (), COUNT (), but it does not merge multiple rows of query results into one row, but instead puts the results back into multiple rows. That is, the window function does not require GROUP by.

4. Hide index: In MySQL 8.0, the index can be "hidden" and "displayed". When the index is hidden, it is not used by the query optimizer. We can use this feature for performance debugging, such as hiding an index first, and then observing its impact on the database. If the performance of the database is degraded, the index is useful, then "restore" it, and if the performance of the database does not show a change, the index is redundant and can be considered for deletion.

5. Descending index: MySQL 8.0 provides support for indexing in descending order, and the values in this index are sorted in descending order as well.

6. Common table expression (Common table Expressions CTE): When using embedded tables in complex queries, using a CTE makes 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 greatly improves support for JSON by adding json_extract () functions that extract data from JSON fields based on path query parameters, and Json_arrayagg () and J, which are used to combine data into JSON arrays and objects, respectively Son_objectagg () aggregation function.

9. Reliability: InnoDB now supports the atomicity of table DDL, that is, the DDL on the InnoDB table can also implement transactional integrity, either fail back, or successfully commit, without the partial success of DDL, and also support the Crash-safe feature, where metadata is stored in a single transaction The data dictionary.

10. High Availability (HI availability): The InnoDB cluster provides an integrated native HA solution for your database.

11. Security: Improvements to OpenSSL, new default authentication, SQL role, password strength, authorization.

Detailed Update Description: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html
Official Release Notes: https://blogs.oracle.com/mysql/announcing-general-availability-of-mysql-80
What's new in MySQL 8 Official edition: https://mysqlserverteam.com/whats-new-in-mysql-8-0-generally-available/

Windows (x86, 64-bit), ZIP Archive (mysql-8.0.11-winx64.zip) 183.3M
https://dev.mysql.com/downloads/file/?id=476233

Windows (x86, 64-bit), ZIP Archive (mysql-8.0.11-winx64-debug-test.zip) 230.5M
Debug Binaries & Test Suite
https://dev.mysql.com/downloads/file/?id=476234

Other versions >>> https://dev.mysql.com/downloads/mysql/8.0.html

"MySQL"-MySQL 8.0 official edition new Highlights