ATITIT.MYSQL 5.0 5.5 5.6 5.7 New features
1 . MySQL 5.6 5 features 1
1 . 1. improvements to the optimizer 1
1 . 2. InnoDB Improvements 1
1 . 3. Direct access to NoSQL using the memcached API 2
1 . 4. Better Replication 2
1 . 5. Performance Schema 2
2 . MySQL 5.7.6 2
2 . 1. built-in Chinese full-text index 2
2 . 2. Multi-master replication 2
2 . 3. Other 2
3 . Reference 2
1.MySQL 5.6 5 features
The next version of MySQL is 5.6, which lists the 5 features of this version:
1.1.improvements to the optimizer
MySQL Optimizer team did a lot of work in order to continuously improve the efficiency of SQL query, mainly reflected in the index conditions pushdown and a wide range of reading data. The pushdown of the index condition means that the WHERE condition statement is moved to the storage engine for processing, which reduces the overload, while a multi-range read means that when the query uses a second index, the disk block is sorted.
author:: Nickname:Old Wow's claws( Full Name::AttilaxAkbar Al Rapanui Attilaksachanui) Kanji Name:Ayron, email:[email protected]
Reprint please indicate source: http://www.cnblogs.com/attilax/
1.2.InnoDB Improvements
the MySQL InnoDB Storage Engine team primarily provides a NoSQL access interface that can be Memcached the API directly accesses the InnoDB table.
1.3.Direct access to NoSQL using the memcached API
This can greatly improve the performance of data access in WEB applications and is suitable for some simple queries.
1.4.Better Replication
The MySQL replication module team has primarily improved data integrity and availability, as well as performance improvements.
1.5.Performance Schema
The performance Schema was introduced in version 5.5, and 5.6 has been improved to provide new features including table locks, table I/O, and table lock waits.
2.MySQL 5.7.62.1.built-in Chinese full-text index2.2.Multi-master replication2.3. Other
3.Reference
MySQL 5.7.6 new features at a glance - push cool . htm
new features of MySQL 5.6 - Open source Chinese community . htm
MySQL 5.6 new Features (translated) -Wulantian 's Column - Blog channel -CSDN. Net.htm
ATITIT.MYSQL 5.0 5.5 5.6 5.7 new feature new features