Skip to content
PERCONA MONITORING AND MANAGEMENT DOCUMENTATION

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

MySQL InnoDB file format in use

Description

Prior to MySQL version 8, InnoDB had two file formats: Antelope and Barracuda. Barracuda is the preferred file format.

Starting with MySQL 8, the following InnoDB file format variables are deprecated:

  • Innodb_file_format

  • Innodb_file_format_check

  • Innodb_file_format_max

  • innodb_large_prefix

File format variables were necessary for creating tables compatible with earlier versions of InnoDB in MySQL 5.1. Now that MySQL 5.1 has reached the end of its product lifecycle, these options are no longer required.

Resolution

Barracuda is the recommended file format, support for Antelope is removed from MySQL 8.

Need more support from Percona?

Percona experts bring years of experience in tackling tough database performance issues and design challenges.