MySQL5.5的亮点 和MySQL Cluster 7.1介绍
MySQL5.5亮点
InnoDB
- 多个缓冲池实例
- 多个回滚段
- 扩展变化和清除缓冲调度
- Improved Log Sys and Flush List mutex 改善日志系统
- 改进锁策略
- 改进InnoDB互斥,读写锁,线程和I/O操作的策略
改进win32,64平台下的性能/规模
扩展到32个内核
半同步复制
性能架构
SIGNAL/RESIGNAL (finally!)
新的增强分区
Configuring the heartbeat period
More than 10x improvement in recovery times
200% performance gain for MySQL 5.5 over 5.1.40
MySQL Cluster 7.1 (GA)
- NDBINFO – improved real time status and usage statistics
- MYSQL Cluster Manager (CGE only)
- Sub-second failover and self healing recovery
- Parallel multi-master architecture
- Low latency – real time responsiveness