文档介绍:赖明星
数据库技术组
2015年4月2日
What’s New In MySQL
Overview
Scalability
Scalable Read Only Transactions
Improved Adaptive Flushing
Optimizer and Execution
Index Condition pushdown (ICP)
Multi-Range-Read (MRR)
Replication
Multi-Threaded Slave
Global Transaction Identifiers
Transparency
Many new INFORMATION_SCHEMA Tables
Explain for UPDATE/DELETE queries
Operational Improvements
Online DDL
User Defined DATA DIRECTORY for Innodb Tables
New Functionality for Developers
Memcached API in Innodb
Full Text Search index for Innodb
Overview: Scalability
• Scalable Read Only Transactions
• Concurrent Innodb data file extension
• Multiple background Purge Threads
• Improved Purge lag control
• Split of “Kernel Mutex”
• Data Dictionary Cache
• Improved Adaptive Flushing
• Page Cleaner/Separate Flush Thread
• Cache Coherence and False Sharing
• Reduced Locking for Partitioned table
• Reduced Contention for LOCK_open
• multiple table_open_cache instances
• Large (over 4GB) redo logs support
• mit for Binary Log
Overview: Optimizer and Execution
• Index Condition Pushdown(ICP)
• Multi-Range-Read(MRR)
• Faster Order By nidxcol LIMIT N
• Persistent Statistics for Innodb
• Improvements to pression
• Fast Page Checksums(CRC32)
• 4k and 8k Page sizes for Innodb
• Subquery Optimizations
Overview: Replication
• Multi-Threaded Slave
• Global Transaction Identifiers
• Crash Safe and Binlog
• Replication Event Checksums
• Time Delayed Replication
• Server UUID f
• Replication Utilites for Failover and Admin
Overview: Transparency
• Many new INFORMATION_SCHEMA Tables
• INNODB_METRICS
• Buffer Pool Information Tables
• Meta Data Information Tables
• Statements/Stages  instrumentation
• Aggregations by User, Host etc
• Explain for UPDATE/DELETE queries
• JSON output with more information
Overview: Operational Improvements
• Separate Tablespaces for Innodb Undo Logs
• Fast Restart – Preloading Innodb Buffer Pool
• Online DDL
• Remote Bi