- 13.7.7.1. Overview of InnoDB Performance
- 13.7.7.2. Faster Locking for Improved Scalability
- 13.7.7.3. Using Operating System Memory Allocators
- 13.7.7.4. Controlling InnoDB Change Buffering
- 13.7.7.5. Controlling Adaptive Hash Indexing
- 13.7.7.6. Changes Regarding Thread Concurrency
- 13.7.7.7. Changes in the Read-Ahead Algorithm
- 13.7.7.8. Multiple Background I/O Threads
- 13.7.7.9. Asynchronous I/O on Linux
- 13.7.7.10. Group Commit
- 13.7.7.11. Controlling the Master Thread I/O Rate
- 13.7.7.12. Controlling the Flushing Rate of Dirty Pages
- 13.7.7.13. Using the PAUSE instruction in InnoDB spin loops
- 13.7.7.14. Control of Spin Lock Polling
- 13.7.7.15. Making Buffer Cache Scan Resistant
- 13.7.7.16. Improvements to Crash Recovery Performance
- 13.7.7.17. Integration with MySQL PERFORMANCE_SCHEMA
- 13.7.7.18. Improvements to Performance from Multiple Buffer Pools
- 13.7.7.19. Better Scalability with Multiple Rollback Segments
- 13.7.7.20. Better Scalability with Improved Purge Scheduling
- 13.7.7.21. Improved Log Sys Mutex
- 13.7.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.