New Features of MySQL5.6: improved optimizer Performance

If you are using MySQL, you should know what new features will be available in the next version, such as better scalability, high performance, and improved flexibility. The next MySQL version is 5.6, which lists the five new features of this version: the improvements of the optimizer MySQLOptimizer team has done a lot of work to continuously improve the efficiency of SQL queries.

If you are using MySQL, you should know what new features will be available in the next version, such as better scalability, high performance, and improved flexibility. The next MySQL version is 5.6. The five new features of this version are listed here: the Optimizer improvement MySQL Optimizer team has done a lot of work to continuously improve the efficiency of SQL queries.

If you are using MySQL, you should know what new features will be available in the next version, such as better scalability, high performance, and improved flexibility.

The next MySQL version is 5.6, which lists the five new features of this version:

Optimizer Improvement

The MySQL Optimizer team has done a lot of work to continuously improve the efficiency of SQL queries, mainly reflected in the index condition pushdown and multi-range read data. Index condition pushdown refers to moving the WHERE Condition Statement to the storage engine for processing, which can reduce the overload. Multi-range read means that when the query uses the second index, sort the disk blocks.

InnoDB Improvement

The MySQL InnoDB Storage engine team mainly provides NoSQL access interfaces to directly access InnoDB tables through Memcached APIs.

Use memcached API to directly access NoSQL

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

Better Replication

The MySQL Replication Module team mainly improved data integrity, availability, and performance.

Performance Schema

Performance Schema was introduced in analyticdb 5.5 and improved in analyticdb 5.6. It provides new functions including table lock, table I/O, and table lock wait.

From: creativedev

From: oschina