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
InnoDBfile format, which previously did not have a name. It supports COMPACT and REDUNDANT row formats for
InnoDBtables and is the default file format in MySQL 5.6 to ensure maximum compatibility with earlier MySQL versions that do not support the Barracuda file format.
Barracuda is the newest file format. It supports all
InnoDBrow formats including the newer COMPRESSED and DYNAMIC row formats. The features associated with COMPRESSED and DYNAMIC row formats include compressed tables, off-page storage for long column data, and index key prefixes up to 3072 bytes (
innodb_large_prefix). See Section 14.9, “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.