InnoDB Plugin 1.0 for MySQL 5.1
(Early Adopter Release) User’s Guide :: 7 Performance and Scalability Enhancements
Section Navigation [Toggle]
- 1 Introduction to the InnoDB Plugin
- 2 Fast Index Creation in the InnoDB Storage Engine
- 3 InnoDB Data Compression
- 4 InnoDB File Format Management
- 5 Storage of Variable-Length Columns
- 6 InnoDB INFORMATION_SCHEMA tables
- 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
- 8 Changes for Flexibility, Ease of Use and Reliability
- 9 Installing the InnoDB Plugin
- 10 Upgrading the InnoDB Plugin
- 11 Downgrading from the InnoDB Plugin
- 12 InnoDB Plugin Change History
- A Third-Party Software
- B Using the InnoDB Plugin with MySQL 5.1.30 or Earlier
- C List of Parameters Changed in the InnoDB Plugin 1.0
- Index
Table of Contents [+/-]
- 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
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).
