Added Features
- 提高安全性
- SQL mode changes
- 即時更新表結構
- 優化 InnoDB
- supports stacked diagnostics areas
- EXPLAIN 可以顯示更多資訊
- 觸發
- 新增 LOG 機制
- MySQL Test Suite
- mysql client
- Database name rewriting with mysqlbinlog
- HANDLER with partitioned tables
- Index condition pushdown support for partitioned tables
- WITHOUT VALIDATION support for ALTER TABLE … EXCHANGE PARTITION
- Master dump thread improvements
- Globalization improvements
- Changing the replication master without STOP SLAVE
Deprecated Features
Removed Features
- 更改密碼加密格式
- 移除一些資料類型
- 使用
Performance Schema tables 取代 SHOW ENGINE INNODB MUTEX
參考:What Is New in MySQL 5.7