segments for index in innodb

Post author: 戛戛Happy
Post link: <a href="https://blog.gagahappy.cn/segments-for-index-in-innodb/" title="segments for index in innodb">https://blog.gagahappy.cn/segments-for-index-in-innodb/
Copyright Notice: All articles in this blog are licensed under <a href="https://creativecommons.org/licenses/by-nc-sa/4.0/" rel="noopener" target="_blank"> BY-NC-SA unless stating additionally.

Posted on 2015-04-12 In mysql , innodb

Two segments are allocated for each index in InnoDB. One is for nonleaf nodes of the B-tree, the other is for the leaf nodes. Keeping the leaf nodes contiguous on disk enables better sequential I/O operations, because these leaf nodes contain the actual table data.

每个索引拥有2个segment，一个用于非叶结点，另一个用于叶子结点