InnoDB 1.1 for MySQL 5.5 User’s Guide (Early Adopter Release) :: 8 Changes for Flexibility, Ease of Use and Reliability :: 8.3 Dynamic Control of System Configuration Parameters
Section Navigation [Toggle]
- 8 Changes for Flexibility, Ease of Use and Reliability
- 8.1 Overview of Changes for Flexibility, Ease of Use and Reliability
- 8.2 Enabling New File Formats
- 8.3 Dynamic Control of System Configuration Parameters
- 8.4 TRUNCATE TABLE Reclaims Space
- 8.5 InnoDB Strict Mode
- 8.6 Controlling Optimizer Statistics Estimation
- 8.7 Better Error Handling When Dropping Indexes
- 8.8 More compact output of SHOW ENGINE INNODB MUTEX
- 8.9 More Read Ahead Statistics
[+/-]
With the InnoDB storage engine it now is possible to chance certain system configuration parameters dynamically, without shutting down and restarting the server as was previously necessary. This increases up-time and facilitates testing of various options. You can now set these parameters dynamically:
This is the User’s Guide for InnoDB storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .
