InnoDB Plugin 1.0 for MySQL 5.1
(Early Adopter Release) User’s Guide :: 7 Performance and Scalability Enhancements :: 7.15
Improvements to Crash Recovery Performance
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
Starting with InnoDB Plugin 1.0.7, a number of optimizations speed up certain steps of the recovery that happens on the next startup after a crash. In particular, scanning the redo log and applying the redo log are faster. You do not need to take any actions to take advantage of this performance enhancement. If you kept the size of your logfiles artificially low because recovery took a long time, you can consider increasing the logfile size.
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).
