Abstract
This is the User’s Guide for InnoDB Plugin 1.0.8 for MySQL 5.1.
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.
This User’s Guide documents the installation and removal procedures and the additional features of the InnoDB Plugin 1.0.8 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”.
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_CMP and
INNODB_CMP_RESETINNODB_CMPMEM and INNODB_CMPMEM_RESETINNODB_TRX ColumnsINNODB_LOCKS ColumnsINNODB_LOCK_WAITS Columnsinnodb_thread_concurrency