InnoDB evolves, data file formats that are not
compatible with prior versions of
sometimes required to support new features. To help manage
compatibility in upgrade and downgrade situations, and systems that
run different versions of MySQL,
named file formats.
InnoDB currently supports two
named file formats, Antelope
Antelope is the original
InnoDB file format, which previously did not
have a name. It supports
InnoDB tables and is the default
file format in MySQL 5.5 to ensure maximum compatibility with
earlier MySQL versions that do not support the Barracuda file
Barracuda is the newest
file format. It supports all
formats including the newer
formats. The features associated with
formats include compressed tables and off-page storage for long
column data. See Section 14.11, “InnoDB Row Storage and Row Formats”.
This section discusses enabling file formats for new
InnoDB tables, verifying compatibility of
different file formats between MySQL releases, identifying the file
format in use, and downgrading the file format.