暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Index ITLs

原创 Jonathan Lewis 2020-04-05
715

在就索引浪费大量空间,并且由于并发性和ITL(interested transaction list 事务槽)条目的累积问题,空间增长到预期大小的三倍(甚至四倍)的问题发表了一系列简短的贴子之后。我认为为这个系列贴子建个索引以便可以按顺序阅读,是个好主意。

Index Quiz 1 : 问题介绍
Index Quiz 2 : 用block dump来回答问题
Index Explosion : 演示问题
Index Explosion – 2 : 解释问题
Index Explosion – 3 : 解决问题
Index Explosion – 4 : 绕过问题
treedump :研究索引结构的一个有用的选项(尽管有时代价较大)
treedump 2: 关于tree dumps的另一个研究

原文链接和内容如下:
https://jonathanlewis.wordpress.com/2009/09/19/index-itls/
After wrting a short series of notes on a problem with indexes wasting a lot of space and growing to three (or even four) times the size you might expect due to a problem with concurrency and ITL (interested transaction list) entries accumulating, I thought it would be a good idea to create a little index for the series to make it easier to read them in order:

Index Quiz 1 : An introductory question
Index Quiz 2 : Answering the question with block dumps
Index Explosion : Demonstrating the issue
Index Explosion – 2 : Explaining the problem
Index Explosion – 3 : Solving the problem
Index Explosion – 4 : Working around the problem
treedump : A useful (though sometimes expensive) option for looking into index structures
treedump 2: Another look at tree dumps.

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论