主要新功能可以归结为以下几个方面:
1. Query Performance
ICP (Index Condition Pushdown)
MRR (Multi Range Read)
BKA (Batch Key Access)
New explain output
Innodb Persistent Statistics
2. Replication(更好的复制功能,MySQL 复制模块团队改进了数据完整性和可用性以及性能方面的提升。)
2.1Flexibility
Time Delay
Informational Events
Remote binary log lookup
Global Unique ServerIDs
Global Transaction ID
2.2Robustness
Crash-Safe Slaves/Master
Replication Event CheckSum
Self-trimed binlog
2.3Performance
Multiple-thread Slaves
Optimized Row Based Replication
3. Performance Schema(Performance Schema 是在 5.5 版本中引入的,5.6 做了改进,提供新功能包括:表锁、表I/O 以及表锁等待。)
1. Query Performance
ICP (Index Condition Pushdown)
MRR (Multi Range Read)
BKA (Batch Key Access)
New explain output
Innodb Persistent Statistics
2. Replication(更好的复制功能,MySQL 复制模块团队改进了数据完整性和可用性以及性能方面的提升。)
2.1Flexibility
Time Delay
Informational Events
Remote binary log lookup
Global Unique ServerIDs
Global Transaction ID
2.2Robustness
Crash-Safe Slaves/Master
Replication Event CheckSum
Self-trimed binlog
2.3Performance
Multiple-thread Slaves
Optimized Row Based Replication
3. Performance Schema(Performance Schema 是在 5.5 版本中引入的,5.6 做了改进,提供新功能包括:表锁、表I/O 以及表锁等待。)
4. Memcached API
具体详细信息参考官网文档 ,这里大致列出主要特性。
曾经写过一篇与复制特性相关的文章《mysql 5.6 新特性 主从延迟》