InnoDB 1.1 for MySQL 5.5 User’s Guide :: 7 InnoDB Performance and Scalability Enhancements
Section Navigation [Toggle]
- Preface and Legal Notices
- 1 Introduction to InnoDB 1.1
- 2 Fast Index Creation in the InnoDB Storage Engine
- 3 InnoDB Data Compression
- 4 InnoDB File-Format Management
- 5 How InnoDB Stores Variable-Length Columns
- 6 InnoDB INFORMATION_SCHEMA tables
- 7 InnoDB Performance and Scalability Enhancements
- 7.1 Overview of InnoDB Performance
- 7.2 Faster Locking for Improved Scalability
- 7.3 Using Operating System Memory Allocators
- 7.4 Controlling InnoDB Change 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 Asynchronous I/O on Linux
- 7.10 Group Commit
- 7.11 Controlling the Master Thread I/O Rate
- 7.12 Controlling the Flushing Rate of Dirty Pages
- 7.13 Using the PAUSE Instruction in InnoDB Spin Loops
- 7.14 Control of Spin Lock Polling
- 7.15 Making the Buffer Pool Scan Resistant
- 7.16 Improvements to Crash Recovery Performance
- 7.17 Integration with the MySQL Performance Schema
- 7.18 Improvements to Performance from Multiple Buffer Pools
- 7.19 Better Scalability with Multiple Rollback Segments
- 7.20 Better Scalability with Improved Purge Scheduling
- 7.21 Improved Log Sys Mutex
- 7.22 Separate Flush List Mutex
- 8 Changes for Flexibility, Ease of Use and Reliability
- 9 Installing the InnoDB Storage Engine
- 10 Upgrading the InnoDB Storage Engine
- 11 Downgrading the InnoDB Storage Engine
- 12 InnoDB Storage Engine Change History
- A Third-Party Software
- B List of Parameters Changed in InnoDB 1.1 and InnoDB Plugin 1.0
- InnoDB Glossary
- Index
Table of Contents [+/-]
- 7.1. Overview of InnoDB Performance
- 7.2. Faster Locking for Improved Scalability
- 7.3. Using Operating System Memory Allocators
- 7.4. Controlling InnoDB Change 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. Asynchronous I/O on Linux
- 7.10. Group Commit
- 7.11. Controlling the Master Thread I/O Rate
- 7.12. Controlling the Flushing Rate of Dirty Pages
- 7.13. Using the PAUSE Instruction in InnoDB Spin Loops
- 7.14. Control of Spin Lock Polling
- 7.15. Making the Buffer Pool Scan Resistant
- 7.16. Improvements to Crash Recovery Performance
- 7.17. Integration with the MySQL Performance Schema
- 7.18. Improvements to Performance from Multiple Buffer Pools
- 7.19. Better Scalability with Multiple Rollback Segments
- 7.20. Better Scalability with Improved Purge Scheduling
- 7.21. Improved Log Sys Mutex
- 7.22. Separate Flush List Mutex
This section discusses recent InnoDB enhancements to performance and scalability, covering the performance features in InnoDB 1.1 with MySQL 5.5, and the features in the InnoDB Plugin for MySQL 5.1. This information is useful to any DBA or developer who is concerned with performance and scalability. Although some of the enhancements do not require any action on your part, knowing this information can still help you diagnose performance issues more quickly and modernize systems and applications that rely on older, inefficient behavior.
Copyright © 1997, 2013, Oracle and/or its affiliates. All
rights reserved.
Legal Notices
User Comments
Add your own comment.