InnoDB is a open source and default general purpose MySQL storage engine built for high performance and reliability , Antelope is the original InnoDB file format which supports both COMPACT and REDUNDANT row formats for InnoDB tables. Barracuda is the newest file format. It supports InnoDB row formats including the newer COMPRESSED and DYNAMIC row formats . The features associated with COMPRESSED and DYNAMIC row formats including compressed tables, efficient storage of off-page columns, and index key prefixes up to 3072 bytes (innodb_large_prefix).
The following file format configuration parameters have new default values:
- The innodb_file_format default value is now changed to Barracuda . The previous default value was Antelope.
- The innodb_large_prefix default value is changed to ON . The previous default value was OFF
The following configuration parameters are deprecated in and may be removed in the future