The InnoDB Storage Engine for MySQL contains several important new features:
Fast index creation: add or drop indexes without copying the data
Data compression: shrink tables, to significantly reduce storage and i/o
          New row format: fully
          off-page storage of long BLOB,
          TEXT, and VARCHAR
          columns
        
File format management: protects upward and downward compatibility
          INFORMATION_SCHEMA
          tables: information about compression and locking
        
Note that the ability to use data compression and the new row format require the use of a new InnoDB file format called “Barracuda”. The previous file format, used by the built-in InnoDB in MySQL versions 5.0 and 5.1 is now called “Antelope” and does not support these features, but does support the other features introduced with the InnoDB storage engine.
      The InnoDB storage engine is upward compatible from standard InnoDB as
      built in to, and distributed with, MySQL. Existing databases can
      be used with the InnoDB Storage Engine for MySQL. The new parameter
      innodb_file_format can help protect upward and downward
      compatibility between InnoDB versions and database files,
      allowing users to enable or disable use of new features that can
      only be used with certain versions of InnoDB.
    
The built-in InnoDB in MySQL since version 5.0.21 has a safety feature that prevents it from opening tables that are in an unknown format. However, as noted in Section 11.2, “The Built-in InnoDB, the Plugin and File Formats”, the system tablespace may contain references to new-format tables that confuse the built-in InnoDB in MySQL. These references are cleared in a “slow” shutdown of the InnoDB storage engine.
With previous versions of InnoDB, no error would be returned until you try to access a table that is in a format “too new” for the software. Beginning with version 1.0.1 of the InnoDB storage engine, however, to provide early feedback, InnoDB checks the system tablespace before startup to ensure that the file format used in the database is supported by the storage engine. See Section 4.4.1, “Startup File Format Compatibility Checking” for the details.
This is the User’s Guide for InnoDB storage engine 1.1 for MySQL 5.5, generated on 2010-04-13 (revision: 19994) .

