MySQL :: InnoDB Plugin 1.0 for MySQL 5.1 User’s Guide :: 8 Changes for Flexibility, Ease of Use and Reliability

Skip navigation links

The world's most popular open source database

Login | Register

Developer Zone
Downloads
Documentation

MySQL Server
MySQL Enterprise
MySQL Workbench
MySQL Cluster
Topic Guides
Expert Guides
Other Docs
Archives
About

Documentation Library
- Table of Contents

Search manual:

InnoDB Plugin 1.0 for MySQL 5.1 User’s Guide :: 8 Changes for Flexibility, Ease of Use and Reliability

« 7.15 Improvements to Crash Recovery Performance

8.1 Overview »

Section Navigation [Toggle]

1 Introduction to the InnoDB Plugin
2 Fast Index Creation in the InnoDB Storage Engine
3 InnoDB Data Compression
4 InnoDB File-Format Management
5 Storage of Variable-Length Columns
6 InnoDB INFORMATION_SCHEMA Tables
7 Performance and Scalability Enhancements
8 Changes for Flexibility, Ease of Use and Reliability
9 Installing the InnoDB Plugin
10 Upgrading the InnoDB Plugin
11 Downgrading from the InnoDB Plugin
12 InnoDB Plugin Change History
A Third-Party Software
B Using the InnoDB Plugin with MySQL 5.1.30 or Earlier
C List of Parameters Changed in the InnoDB Plugin 1.0
D InnoDB Glossary
Index

Chapter 8. Changes for Flexibility, Ease of Use and Reliability

Table of Contents [+/-]

8.1. Overview

8.2. Enabling New File Formats

8.3. Dynamic Control of System Configuration Parameters [+/-]

8.3.1. Dynamically Changing innodb_file_per_table
8.3.2. Dynamically Changing innodb_stats_on_metadata
8.3.3. Dynamically Changing innodb_lock_wait_timeout
8.3.4. Dynamically Changing innodb_adaptive_hash_index

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

This is the User’s Guide for InnoDB Plugin 1.0.8 for MySQL 5.1, generated on 2012-02-14 (revision: 28615) .

Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices

Top / Previous / Next / Up / Table of Contents

Developer Zone
Documentation
Developer Articles
News & Events
Forums
Bugs
Forge
Planet MySQL
Labs

Downloads
MySQL Community Server
MySQL Proxy
MySQL Cluster
MySQL Workbench
MySQL Connectors
Archives
Snapshots
Mirrors

Documentation
MySQL Reference Manuals
MySQL Workbench
Expert Guides
Topic Guides
MySQL Cluster
Other Documents
MySQL University
About
Archives

Support
MySQL Meetups
Lists
Forums

Other
Legal
Contact Us
Site Map

© 2012, Oracle Corporation and/or its affiliates