程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> SyBase數據庫 >> SyBase教程 >> Barracuda文件格式和Antelope的區別

Barracuda文件格式和Antelope的區別

編輯:SyBase教程

Barracuda文件格式和Antelope的區別


/** 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可以在不在聚集索引頁的數據上創建二級索引,並且能存更多數據在溢出頁。

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved