Spec-Zone .ru
спецификации, руководства, описания, API

14.2.4. InnoDB Performance Tuning and Troubleshooting

14.2.4.1. InnoDB Performance Tuning Tips
14.2.4.2. InnoDB Performance and Scalability Enhancements
14.2.4.3. InnoDB INFORMATION_SCHEMA tables
14.2.4.4. SHOW ENGINE INNODBSTATUS and the InnoDB Monitors
14.2.4.5. InnoDB General Troubleshooting
14.2.4.6. Starting InnoDB on a Corrupted Database
14.2.4.7. Troubleshooting InnoDB Data Dictionary Operations

This section explains the actions to take for InnoDB issues. Because much of the InnoDB focus is on performance, many issues are performance-related. You can use the tips here to track down problems after they occur, or do advance planning to avoid the problems entirely.