MySQL 8.0.0 is released. All the highlights are here!

MySQL 8.0.0 is released. All the highlights are here!
GuideMySQL is an open-source small-scale associated database management system. The developer is MySQL AB in Sweden. Currently, MySQL is widely used in small and medium websites on the Internet. Because of its small size, fast speed, and low total cost of ownership, especially the open source code, many small and medium websites have chosen MySQL as their website database to reduce their total cost of ownership.

Some may be surprised why MySQL jumped from 8.0. In fact, the MySQL 5.x series has continued for many years. It was 5.1 since it was acquired by Oracle, and it has been maintained in 5.xsince it was acquired, such as 5.5, 5.6, and 5.7. In fact, according to the original release pace, you can regard 5.6.x as 6.x, 5.7.x as 7.x. Therefore, we only changed the version naming method.

Highlights of MySQL 8.0.0

Transactions hold the data dictionary, which is completely out of the MylSAM storage engine.

The data dictionary is actually placed in some tables in 1nnoOB, and FRM, TRG, and pAR files are required in the long run of Xi J! Inf
RmationSchema is now available in a view of the data dictionary table. In principle, no MylSAM data is required.
Table type. All system tables can be placed in Inn0OB.

SQL role

A role is a set of Sighs. You can create roles, Grant and remove roles to other users. For permission management
Very convenient.

Uttsmb4 character set will become the default character set, and supports Unicode 9
The default character set is changed from 1atinl to uttsmb4, and collatlon is changed from latlnl_swedish_ci to utf8mb4_800_ci_ai by default.

Invisible Index

Some indexes can be set to invisible, so that the SOL optimizer will not use it, but it will continue to be in the back-end Forum
Update. When necessary, you can restore visibility at any time.

Bitwise operations can be performed on binary data.

Not only can bitwise operations be performed for BIGIN, but also for [VAR] BINARY/[TINY | MEDIUM | LONG] BLOB from 8.0.

Persistent global variables

The lnnoDB buffer can now estimate the number of tables and indexes in the primary memory cache, which allows the optimizer to select access
When using this method, you need to know whether the data can be stored in the disk.

Refactor BLOB

The read/update operations of segments are accelerated to accelerate JSON data operations.

Refactoring SQL Analyzer

Continuously improve the SQL analyzer. The old analyzer is difficult to maintain and expand due to its syntax complexity and top-down analysis methods.

Cost Model

The 1nn0OB buffer can now estimate the number of tables and indexes in the primary memory cache, which allows the optimizer to select access
When using this method, you need to know whether the data can be stored in the disk.

Persistent auto-Increment

Inn0OB persists the maximum value of the auto-increment sequence to the redo log. This lecture ring fixes a non-old 19
G bug.

Improve scanning Performance

This improves the performance of lnnOOB in the range of 10 to 10, and improves the performance of full table queries and range queries by 20%.

Temporary table

Cancel the temporary table compression and store the metadata of the temporary table to the memory.

Currently, 8.0.0 is a development version. If you want to experience and test the latest features, you can download the installation packages for each platform from dev.mysql.com [3. However, the MySQL package is getting bigger and bigger, and the Binary Package on the Linux platform is nearly 1 GB. If it is used in the product environment, continue to use the 8.0 series before 5.7 is stable. The latest version is 5.7.15 GA-this is only 600 M.

From: http://mt.sohu.com/20160918/n468647987.shtml

Address: http://www.linuxprobe.com/mysql-8-update.htmledit: Zheng Shuai, reviewer: FENG Qi