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

This article mainly introduces "what are the main features of MySQL 5.7". In daily operation, I believe many people have doubts about the main features of MySQL 5.7. Xiaobian consulted various materials and sorted out simple and easy to use operation methods. I hope to help you answer the doubts about "what are the main features of MySQL 5.7"! Next, please follow the small series to learn together!

The main features of MySQL 5.7 are:

Better performance: better optimization for multi-core CPU, solid state drive, lock, 100W QPS per second is no longer MySQL's pursuit, the next version can be 200W QPS is more concerned about our users

Better InnoDB Storage Engine

More robust replication capabilities: Replication brings a solution where data is not lost at all, and traditional financial customers can also choose to use MySQL databases. In addition, GTID online smooth upgrade also becomes possible

Better Optimizer: The significance of optimizer code refactoring will bring huge improvements in this and future releases, Oracle officials are solving the biggest problems before MySQL

Native JSON type support

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

New sys library: This will be the most frequently accessed library by DBAs in the future

innodb_buffer_pool_size can be adjusted online without stopping the library

Deadlock information can be logged to the error log

Support for direct viewing of execution plans for a connection online

Supports multi-source and multi-threaded replication

At this point, the study of "What are the main features of MySQL 5.7" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.