Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.3Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / The InnoDB Storage Engine  /  InnoDB File-Format Management

14.10 InnoDB File-Format Management

AsInnoDB evolves, data file formats that are not compatible with prior versions ofInnoDB are sometimes required to support new features. To help manage compatibility in upgrade and downgrade situations, and systems that run different versions of MySQL,InnoDB uses named file formats.InnoDB currently supports two named file formats,Antelope andBarracuda.

This section discusses enablingInnoDB file formats for newInnoDB tables, verifying compatibility of different file formats between MySQL releases, and identifying the file format in use.

InnoDB file format settings do not apply to tables stored ingeneral tablespaces. General tablespaces provide support for all row formats and associated features. For more information, seeSection 14.6.3.3, “General Tablespaces”.

Note

The following file format configuration parameters have new default values:

  • Theinnodb_file_format default value was changed toBarracuda. The previous default value wasAntelope.

  • Theinnodb_large_prefix default value was changed toON. The previous default wasOFF.

The following file format configuration parameters are deprecated in and may be removed in a future release:

The file format configuration parameters were provided for creating tables compatible with earlier versions ofInnoDB in MySQL 5.1. Now that MySQL 5.1 has reached the end of its product lifecycle, the parameters are no longer required.