ATITIT.MYSQL 5.0 5.5 5.6 5.7 new feature new features

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