Shulou(Shulou.com)06/02 Report--

This article mainly introduces what are the main features of MySQL 5.7. what is introduced in this article is very detailed and has a certain reference value. Interested friends must read it!

MySQL 5.7 main features:

Better performance: better optimization for multi-core CPU, solid state disk and lock. 100W QPS per second is no longer the pursuit of MySQL. Whether the next version can be 200W QPS is more concerned by our users.

A better InnoDB storage engine: there is too much content, just wait for the third edition of Inside's "inside MySQL Technology: InnoDB Storage engine"

More robust replication: replication brings a solution that does not lose data at all, and traditional financial customers can also choose to use MySQL databases. In addition, it is possible for GTID to upgrade smoothly online

Better optimizer: the meaning of optimizer code refactoring will bring great improvements in this version and later versions, and Oracle is officially solving the problem before MySQL.

Native JSON type support: document databases are already crying in the toilet.

Better geographic information service support: InnoDB natively supports geolocation types and supports GeoJSON,GeoHash features

New sys library: this is a feature of Inside (although 5.6 can also be supported), but not many people seem to know about it. In the future, this will be the most frequently accessed library by DBA.

These are all the contents of the article "what are the main features of MySQL 5.7.Thank you for reading!" Hope to share the content to help you, more related 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.