What is the difference between the Barracuda file format and Antelope? barracudaantelope

Source: Internet
Author: User

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 */



/** 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 .*/




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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.