14.13 InnoDB Performance

14.13.1 InnoDB Buffer Pool Configuration
14.13.2 InnoDB Mutex and Read/Write Lock Implementation
14.13.3 Configuring the Memory Allocator for InnoDB
14.13.4 Configuring InnoDB Change Buffering
14.13.5 Configuring Thread Concurrency for InnoDB
14.13.6 Configuring the Number of Background InnoDB I/O Threads
14.13.7 Group Commit
14.13.8 Configuring the InnoDB Master Thread I/O Rate
14.13.9 Using the PAUSE Instruction in InnoDB Spin Loops
14.13.10 Configuring Spin Lock Polling
14.13.11 InnoDB Integration with MySQL Performance Schema
14.13.12 Better Scalability with Multiple Rollback Segments
14.13.13 Configuring InnoDB Purge Scheduling
14.13.14 Optimizing InnoDB Read-Only Transactions
14.13.15 Using the CRC32 Checksum Algorithm for Faster Checksums
14.13.16 Storing InnoDB Undo Logs in Separate Tablespaces
14.13.17 Optimizer Statistics
14.13.18 Estimating ANALYZE TABLE Complexity for InnoDB Tables

This section provides information about InnoDB features and enhancements related to performance and scalability.

Tips and guidelines for tuning InnoDB tables are provided in the optimization chapter. See Section 8.5, “Optimizing for InnoDB Tables”.