What is the difference between the Barracuda file format and Antelope? barracudaantelope
/** There are currently two InnoDB fileformats which are used to group
Features with similar restrictions anddependencies. Using an enum allows
Switch statements to give a compilerwarning when a new one is introduced .*/
Enum innodb_file_formats_enum {
/** Antelope File Format: InnoDB/MySQL up to 5.1.
Thisformat includes REDUNDANT and COMPACT row formats */
UNIV_FORMAT_A = 0,
/** Barracuda File Format: Introduced in InnoDB plugin for 5.1:
Thisformat supported des COMPRESSED and DYNAMIC row formats. It
Includesthe ability to create secondary indexes from data that
Isnot on the clustered index page and the ability to store more
Dataoff the clustered index page .*/
UNIV_FORMAT_ B = 1
};
The Barracuda file format is introduced by innodb5.1, including the compressed and dynamic file formats. The difference between Barracuda and Antelope is that barracuda can create secondary indexes on data not on the clustered index page and store more data on the overflow page.