This is the User’s Guide for InnoDB storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .
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
Beginning with MySQL version 5.1, it is possible to swap out one version of the InnoDB storage engine and use another (the “plugin”). This manual documents the latest InnoDB plugin, version 1.1, which works with MySQL 5.5 and features cutting-edge improvements in performance and scalability.
This User’s Guide documents the procedures and features that are specific to the InnoDB storage engine 1.1 for MySQL 5.5. It supplements the general InnoDB information in the MySQL Reference Manual.
The “early adopter” status means that the InnoDB Plugin 1.1 is recommended for performance, functionality, and compatibility testing, but not yet for deployment in mission-critical situations. The generally available (GA) version of the InnoDB Plugin has been announced as 1.0.7, for MySQL 5.1. (May not be available as of this date.)
WARNING: Because the InnoDB storage engine
1.0 and above introduces a new file format, restrictions apply
to the use of a database created with the InnoDB storage engine 1.0
and above, 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 [+/-]
INFORMATION_SCHEMA
tables [+/-]TRUNCATE TABLE
Reclaims SpaceSHOW ENGINE INNODB MUTEX
List of Tables [+/-]
CREATE TABLE
and ALTER TABLE
options
CREATE/ALTER TABLE
Warnings and Errors when InnoDB
Strict Mode is OFF
INNODB_CMP
and
INNODB_CMP_RESET
INNODB_CMPMEM
and INNODB_CMPMEM_RESET
INNODB_TRX
columns
INNODB_LOCKS
columns
INNODB_LOCK_WAITS
columns
innodb_thread_concurrency
This is the User’s Guide for InnoDB storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .