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 will significantly increase Data access performance in WEB applications, 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. Function Index Support2.2. built-in Chinese full-text index2.3. Multi-master replication2.4. Other

3. Reference

MySQL 5.7 new features Generated Column(function Index)_ database technology _linux Commune -linux System portal website . HTML

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

author :: Nickname: Old Wow's paw claw of Eagle idol iconoclast Image-smasher

Bird King "Bird Catcher Kok devout pious religious defender Defender of the Faith. Caracalla red cloak Caracalla red cloak king of beasts

abbreviation:: Emir Attilax Akbar Emile Atiraca

Full Name:: Emir Attilax Akbar bin Mahmud bin Attila bin Solomon bin Adam Al Rapanui Emile Atilax Akbaben Maham Solomon Ben Adam Arrapanui

Common name: Etila (Ayron), Email:[email protected]

title:Head of Uke headquarters, founder of Global Grid project,

Uke Friendship Association president Uke Hunting Association president Emir Uke Tribe chief Grand Chief,

Uke, Minister of Religious and Cultural Integration Affairs, Vice-Chairman of the Uke Reformation Commission

Uke system and chairman of the major conference committee, Uke Security Department Chief Brigade, Uke System Inspection Committee vice President,

UKE Chief CTO Software Division Director of Technical department deputy Director of Research and Development department Director of Product department deputy Manager Project department deputy Manager Uke Science and Technology research Institute Dean Uke Software Training Master

Uke Polynesia District chain Head of the area responsible for the Kingdom of Tonga Uke Kerr Glen, chain head, Line Is. district chain head, Uke Bouvet and South Georgia and South Sandwich Is. region chain Head

Uke, chairman of the Association of Software Standardization, vice president of Uke Database and storage Standardization Association

Uke, founder of Uke Hospital and Medical school, vice president of lifelong Education School

UEC, president of UECIP, director of UKE document Retrieval department, head of Department of image processing machine vision

Uke, chief Dean of the School of image processing and machine vision

Uke Outdoor Sports Association chairman of the resort chief Mayor Uke Press editor

reprint Please indicate source:Attilax's column? http://www.cnblogs.com/attilax/

--atiend V8

ATITIT.MYSQL 5.0 5.5 5.6 5.7 new feature new features