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

14.2.5. InnoDB Features for Flexibility, Ease of Use andReliability

14.2.5.1. Support for Read-Only Media
14.2.5.2. Larger Size Limit for Redo Log Files
14.2.5.3. 2-Byte Collation IDs for InnoDB Tables
14.2.5.4. The Barracuda File Format
14.2.5.5. Dynamic Control of System Configuration Parameters
14.2.5.6. TRUNCATE TABLE Reclaims Space
14.2.5.7. InnoDB Strict Mode
14.2.5.8. Controlling Optimizer Statistics Estimation
14.2.5.9. Better Error Handling when Dropping Indexes
14.2.5.10. More Compact Output of SHOW ENGINE INNODB MUTEX
14.2.5.11. More Read-Ahead Statistics
14.2.5.12. Increase VARCHAR Size In-Place
14.2.5.13. Enhanced innochecksum Capability

This section describes several recently added InnoDB features that offer new flexibility and improve ease of use, reliability and performance. The Barracuda file format improves efficiency for storing large variable-length columns, and enables table compression. Configuration options that once were unchangeable after startup, are now flexible and can be changed dynamically. Some improvements are automatic, such as faster and more efficient TRUNCATE TABLE. Others allow you the flexibility to control InnoDB behavior; for example, you can control whether certain problems cause errors or just warnings. And informational messages and error reporting continue to be made more user-friendly.