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
MySQL Connectors
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]

Preface and Legal Notices
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
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

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

Previous / Next / Up / Table of Contents

User Comments

Add your own comment.

Top / Previous / Next / Up / Table of Contents

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

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

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

About MySQL
Contact Us
How to Buy
Partners
Job Opportunities
Site Map

Legal
Legal Policies
Your Privacy Rights
Terms of Use
Trademark Policy
Contributor Agreement

© 2013, Oracle Corporation and/or its affiliates