Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about the new features of MySQL 8.0. the article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

After being acquired by Sun, MySQL made a transitional version 6. 0, and it wasn't long before it went offline (I was shocked to hear that someone was using version 6. 0 online.) After being acquired by Oracle, it finally ushered in a decent version 5. 6, followed by versions 5. 7 and 8. 0. From this point of view, the decline and fall of Sun is not unreasonable.

P.S, as mentioned above, version 6.0 has been used, and the 7.x series version is dedicated to NDB Cluster, so the new version number starts at 8.0.

When it was first acquired by Oracle, everyone panicked, and it seemed that they even had a joint signature petition, but it was a pity that it really responded to the saying, "those who go along prosper and those who go against die."

Founder Monty messed with MariaDB again, but it was also lukewarm. After the release of MySQL 8.0, MariaDB announced that it was not going to merge the InnoDB engine, which made it even more embarrassing. Can you have fun in the future? Over the past two years, Mr. Monty has come to China from time to time to show his face, but it seems to have changed.

To cut the gossip, let's take a look at the features of 8.0.

1.1 performance optimization related

Quickly add new columns. Having played the game DBA, tears welled up in my eyes, thinking about the tough days when I got up early to make changes (╥╯ ^ ╰╥)

Histogram. There is no index, do not want to build an index, the index is not accurate? No, there is also a histogram.

Functional indexing and expression indexing, developers should love these two functions.

Eliminates the global buffer pool mutex. It seems that this feature Percona has been available since version 5.5, and the official team is a little slow in this area.

Inverted index. You can arrange in positive, reverse, or mixed order, any posture can be satisfied, em...

Invisible index. Delete an index, want to delete but do not dare to do so, how to break? Invisible index to help. After it becomes invisible, observe for a while, make sure it is not affected, and then delete it.

The introduction of WRITESET mode greatly improves the efficiency of parallel replication and further reduces the delay of master-slave replication.

For the JSON data type, add Multi-valued indexes to make it more convenient for JSON search.

The syntax of HINT is enhanced to make it easier to dynamically set options when executing a query and adopt different strategies for different SQL.

There is a new TempTable engine, which is much better than the original tmptable.

Other optimizations.

1.2 functional enhancements in management, replication and security

Group Relication is officially launched. Very well, it is moving steadily towards high performance and high availability, first to achieve read scalability and then to achieve write scalability. Look forward to the realization of distributed Sharding in the near future, by that time, those NEWSQL who boast so much on the market will be mute, saying a little bitterly in the past two years.

Clone Plugin and ReplicaSet features, with MySQL Shell, it is much more convenient to deploy a new slave instance, or InnoDB Cluster node.

The sqlrequireprimary_key option setting enforces that each table must have a primary key. In the master-slave environment, it is believed that too many people have suffered losses without primary keys. Of course, I didn't, hey.

The self-increment ID is persisted after the instance is restarted, but the small enhancement solves the big logic problem in the business.

Extra admin port, the administrator can open the back door for himself.

After modifying the configuration parameters online, the SET PERSIST syntax is persisted and there is no need to manually modify the my.cnf.

Lock enhancement, adding SKIP LOCK, NOWAIT LOCK lock mode, and BACKUP LOCk.

Window function, CTE. Do statistical analysis of the gospel of the students.

These are the new features of MySQL 8.0 shared by the editor. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.