Barracuda檔案格式和Antelope的區別，barracudaantelope

Barracuda檔案格式和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 includes 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

};

 

Barracuda檔案格式由innodb5.1引入，包括compressed和dynamic檔案格式。Barracuda與Antelope的區別在於barracuda可以在不在叢集索引頁的資料上建立二級索引，並且能存更多資料在溢出頁。