Skip navigation links
InnoDB Plugin 1.0 for MySQL 5.1 (Early Adopter Release) User’s Guide
1 Introduction to the InnoDB Plugin »
Section Navigation      [Toggle]

InnoDB Plugin 1.0 for MySQL 5.1 (Early Adopter Release) User’s Guide

This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).

Provided that you reproduce the above copyright notice, this list of conditions and the following disclaimer on all copies of this documentation (the “Documentation”) for the InnoDB Plugin for MySQL (the “Program”): (a) permission is hereby given to make a reasonable number of complete copies of the Documentation in formats of your choice, solely for your use with the Program, and (b) you may copy and distribute unmodified and complete versions of the content of this Documentation in format(s) of your choice, but only in conjunction with your otherwise-authorized distribution of the Program.

THIS DOCUMENTATION IS PROVIDED BY INNOBASE OY AND ITS CONTRIBUTORS “AS IS” AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL INNOBASE OY OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS DOCUMENTATION, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Abstract

Starting with version 5.1, MySQL AB has promoted the idea of a “pluggable” storage engine architecture , which permits multiple storage engines to be added to MySQL. Beginning with MySQL version 5.1, it is possible for users to swap out one version of InnoDB and use another. The pluggable storage engine architecture also permits Innobase Oy to release new versions of InnoDB containing bug fixes and new features independently of the release cycle for MySQL.

The current “early adopter” status means that the InnoDB Plugin is recommended for performance, functionality, and compatibility testing, but not yet for deployment in mission-critical situations.

This User’s Guide documents the installation and removal procedures and the additional features of the InnoDB Plugin 1.0.6 for MySQL 5.1.

WARNING: Because the InnoDB Plugin introduces a new file format, restrictions apply to the use of a database created with the InnoDB Plugin with earlier versions of InnoDB, when using mysqldump or MySQL replication and if you use the InnoDB Hot Backup utility. See Section 1.5, “Operational Restrictions”.

Table of Contents     [+/-]

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     [+/-]
Index

List of Tables   [+/-]

List of Examples   [+/-]

This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).