目 录
概要..........................................................................................................................4
性能上的改进..............................................................................................................5
InnoDB 成为默认的数据库引擎...................................................................................5
改进事务中对元数据的加锁机制.................................................................................5
提升 MySQL 在 win32/64 系统上的性能........................................................................5
InnoDB 数据恢复效率大大提升...................................................................................5
InnoDB 同时支持多个 BufferPool 实例..........................................................................6
InnoDB 同时支持多个回滚段......................................................................................6
InnoDB 提升默认的并发线程策略...............................................................................6
InnoDB 细粒度控制后台 I/O 线程数量..........................................................................6
InnoDB 可配置的主线程 I/O 速率................................................................................6
InnoDB 可控制的自适应 hash 索引操作........................................................................6
InnoDB 重新支持批量日志写入...................................................................................6
Linux 平台原生异步 I/O 支持......................................................................................6
Linux 平台原生原子操作支持.....................................................................................7
支持扩展的数据变化缓冲..........................................................................................7
扩展性方面的提升.......................................................................................................8
Log Sys Mutex 和 Flush List Mutex 粒度更细..................................................................8
数据页 GC 逻辑从主线程中剥离.................................................................................8
可用性方方面的提升....................................................................................................9
(半同步复制 Google Patch)..................................................................................................................9
复制心跳................................................................................................................9
自动 Relay Log 恢复..................................................................................................9
管理和效率方面的提升...............................................................................................10
快速索引创建........................................................................................................10
高效数据压缩........................................................................................................10
新的 Performance Schema..................................................................................................................10
新参数解释...............................................................................................................11
Innodb_use_native_aio........................................................................................................................11
Innodb_buffer_pool_instance..............................................................................................................12
Innodb_change_buffering....................................................................................................................12
Innodb_purge_threads.........................................................................................................................13
Innodb_purge_batch_size....................................................................................................................14
性能测试..................................................................................................................15
测试目的..............................................................................................................15
机器配置..............................................................................................................15
Linux 配置.........................................................................................................15
服务器存储性能测试...............................................................................................15
只读 IOPS 测试..................................................................................................16
配置.............................................................................................................16
测试结果.......................................................................................................16
只读带宽测试....................................................................................................17
配置.............................................................................................................17
测试结果.......................................................................................................17
