What are the new features of MySQL5.6

This article mainly introduces "what are the new features of MySQL5.6". In daily operation, I believe many people have doubts about the new features of MySQL5.6. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubts about "what are the new features of MySQL5.6?" Next, please follow the editor to study!

Improvement of optimizer

The MySQL Optimizer team has done a lot of work in order to continuously improve the efficiency of SQL queries, mainly reflected in the index condition pushdown and multi-range reading data. The pushdown of the index condition means that the WHERE conditional statement is moved to the storage engine to reduce overload, while multi-range reading means that the disk blocks are sorted when the query uses the second index.

InnoDB improvement

The MySQL InnoDB storage engine team mainly provides access to NoSQL, which provides direct access to InnoDB tables through Memcached's API.

Use memcached API to access NoSQL directly

This can greatly improve the performance of data access in Web applications and is suitable for some simple queries.

Better replication

The MySQL replication module team has mainly improved data integrity and availability as well as performance improvements.

Performance Schema

Performance Schema was introduced in version 5.5, which has been improved to provide new features such as table locks, table Icano, and table lock waiting.

At this point, the study on "what are the new features of MySQL5.6" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!