InnoDB Plugin 1.0 for MySQL 5.1
(Early Adopter Release) User’s Guide :: 7 Performance and Scalability Enhancements :: 7.1 Overview
Section Navigation [Toggle]
- 7 Performance and Scalability Enhancements
- 7.1 Overview
- 7.2 Faster Locking for Improved Scalability
- 7.3 Using Operating System Memory Allocators
- 7.4 Controlling InnoDB Insert Buffering
- 7.5 Controlling Adaptive Hash Indexing
- 7.6 Changes Regarding Thread Concurrency
- 7.7 Changes in the Read Ahead Algorithm
- 7.8 Multiple Background I/O Threads
- 7.9 Group Commit
- 7.10 Controlling the Master Thread I/O Rate
- 7.11 Controlling the Flushing Rate of Dirty Pages
- 7.12 Using the PAUSE instruction in InnoDB spin loops
- 7.13 Control over spin lock polling
- 7.14 Making Buffer Cache Scan Resistant
- 7.15 Improvements to Crash Recovery Performance
InnoDB has always been highly efficient, and includes several unique architectural elements to assure high performance and scalability. InnoDB Plugin 1.0.6 includes several new features that take better advantage of recent advances in operating systems and hardware platforms, such as multi-core processors and improved memory allocation systems. In addition, this release permits you to better control the use of some InnoDB internal subsystems to achieve the best performance with your workload.
InnoDB Plugin 1.0.6 includes new capabilities in these areas:
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).
