Barracuda文件格式和Antelope的区别

最新推荐文章于 2023-08-14 09:16:01 发布

yzs87

最新推荐文章于 2023-08-14 09:16:01 发布

阅读量2k

点赞数

分类专栏： MySQL源码分析

本文链接：https://blog.csdn.net/yanzongshuai/article/details/45625079

版权

MySQL源码分析专栏收录该内容

191 篇文章 87 订阅 ¥9.90 ¥99.00

订阅专栏

本文探讨了Barracuda文件格式，该格式自InnoDB5.1开始引入，特点包括compressed和dynamic模式。相较于Antelope，Barracuda允许在非聚集索引页创建二级索引，并能存储更多数据于溢出页，提升了存储效率。

摘要由CSDN通过智能技术生成

/** 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可以在不在聚集索引页的数据上创建二级索引，并且能存更多数据在溢出页。