- 13.7.8.1. Enabling New File Formats
- 13.7.8.2. Dynamic Control of System Configuration Parameters
- 13.7.8.3.
TRUNCATE TABLEReclaims Space - 13.7.8.4. InnoDB Strict Mode
- 13.7.8.5. Controlling Optimizer Statistics Estimation
- 13.7.8.6. Better Error Handling when Dropping Indexes
- 13.7.8.7. More Compact Output of
SHOW ENGINE INNODB MUTEX - 13.7.8.8. More Read-Ahead Statistics
This chapter describes several features in InnoDB 1.1 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.