Abstract
This is the User’s Guide for the InnoDB storage engine 1.1 for MySQL 5.5.
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.
Because InnoDB 1.1 is integrated with MySQL 5.5, it is generally available (GA) and production-ready.
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 older InnoDB Hot Backup product rather than the newer MySQL Enterprise Backup
product. See Section 1.4, “Compatibility Considerations for Downgrade and Backup”.
For legal information, see the Legal Notices.
Document generated on: 2012-12-08 (revision: 33432)
Table of Contents
INFORMATION_SCHEMA tablesTRUNCATE TABLE Reclaims SpaceSHOW ENGINE INNODB MUTEXList of Tables
CREATE TABLE and
ALTER TABLE optionsCREATE/ALTER TABLE Warnings and Errors when InnoDB
Strict Mode is OFFinnodb_thread_concurrency