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

This article mainly shows you "what are the new features of MySQL 8.0". It is easy to understand and clear. I hope it can help you solve your doubts. Let me lead you to study and learn what are the new features of MySQL 8.0.

MySQL 8.0 DMR has been released, and what is significant is that the official MyISAM storage engine has finally been abandoned.

The main updates are as follows:

1.InnoDB stores the data dictionary, which means that MyISAM can be completely stripped from the MySQL database

Mr. 2.Invisible Index,Inside is very interested in this feature. Because in a production environment, you can use the sys library to determine which indexes are redundant. However, if you want to delete redundant indexes directly, you are worried about some risks.

3.Invisible Index gives us a good choice.

4. Role table function, the official MySQL finally provides Role function. InnoSQL proudly said that we implemented this feature in 5. 5%, even earlier than MariaDB. You know, in the game industry, regular password change is always a headache, and it's much easier to have Role. Of course, InnoSQL can also control the resources of Role. I don't know how to implement 8.0.

5.Cost Model is improved, and the optimizer can sense whether the page exists in the buffer pool. 5.7 actually the interface is open, but the pages in memory are not counted, and the return is 1.0.

6. Histogram support, MySQL also supports histogram. There should be a better implementation plan. Brother Haixiang talked about this feature at the IMG conference, and I heard that the performance improvement is very good.

7. Parameter persistence continues to be close to the Oracle database, but this feature itself is a hard requirement. How many pits have occurred in recent years because there is no parameter persistence?

8. With the improvement in scanning performance, the performance of InnoDB full table scan or range query has been improved by 5% to 20%. Excuse me, is the code written by HT so bad before?

9. ReFactor the implementation of BLOB to improve the update of JSON properties. I feel that the improvement in performance in this area may be very great. Leave a claw and test it later.

10. Persistence self-value-added, Taobao, Percona have made similar improvements over the years. But the official revision is elegant, self-writing redo, a problem left over from history is so simple and elegant to solve.

The 11.PS library adds indexes, and officials claim to have added more than 100 indexes. Indeed, Inside has come across a lot of scenarios where PS libraries take up 20 gigabytes of memory, and queries can be very inefficient. But will the memory cost go up further? Let's wait and see.

These are all the contents of the article "what are the New Features of MySQL 8.0?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.