After creating a new replica of unused a db in lotus notes there is difference in db size. But the no of documents are same

huangapple go评论51阅读模式
英文:

After creating a new replica of unused a db in lotus notes there is difference in db size. But the no of documents are same

问题

这是版本8.5,对于可能的原因和解决方法有何想法?

我尝试删除副本并重新创建,但结果相同。副本中的文档数量与主数据库中相同。在创建新副本时是否出现了错误?如果是,请提供解决方案。

英文:

Any idea of what might be the reason and how to resolve it. This is in Version8.5

I tried deleting the replica and creating again but it is same. No of documents are same in replica and in the main db. Is there any mistake while creating new replica? If yes please provide solution.

答案1

得分: 4

The size difference is most likely because of the size of the view indexes in the original db. The view indexes in the new replica have not yet been built.

英文:

The size difference is most likely because of the size of the view indexes in the original db. The view indexes in the new replica have not yet been built

答案2

得分: 0

首先:不,这不是一个错误。只要文档计数相同,一切都正常。

Per Henrik Lausten已经提出了一个原因,但这不是唯一的原因。以下是一些可能的原因(为了完整起见,重复Per的原因):

视图索引
它们(默认情况下)仅在使用视图时构建。具有可排序列的视图甚至有多个要构建的索引。它们通常是大小差异最大的原因。您可以在管理客户端中右键单击数据库以检查视图索引的大小,那里有一个用于检查索引的选项。

空白空间
每当删除数据库中的任何内容时,数据库的物理大小不会立即缩小。删除的内容会在数据库中留下“空白空间”,可以通过压缩数据库来删除。新的副本不包含空白空间。可以使用数据库属性中的“已使用百分比”按钮来检查空白空间。

删除
软删除
垃圾箱中的软删除文档通常不会被复制

删除存根
与空白空间有关:为了防止由于复制而导致已删除文档“回来”,Domino在最初清除它们之前将已删除文档的存根保留在数据库中(默认情况下为90天)。这些删除存根很小,但如果在数据库中进行大量删除,它们可能会累积。

磁盘上的结构(ODS)
根据数据库的年龄和服务器上的设置,数据库的磁盘上的结构可能会有所不同。几乎每个版本都会带来自己的ODS

  • Domino 9之前:ODS <= 43(模板ODS 23)
  • Domino 9:ODS 52
  • Domino 10/11:ODS 53
  • Domino 12:ODS 55

每个ODS在存储数据方面的效率都不同,因此对于相同的文档,需要不同数量的空间。

与ODS相关的是数据库内部的附件压缩类型。以前是“哈夫曼”,但在所有最近的版本中,您应该在数据库属性中创建LZ1(选项“为附件使用LZ1压缩”)。
当然,这也会导致磁盘上的不同大小。

内部数据库结构
大小差异的最小因素是功能内部表格。例如,有一个“UNC表格”,用于跟踪数据库内的所有字段及其类型。除非在设计器中进行了大量更改并且有很多字段,否则这不会有很大的差异。UNC表格将为每个副本重建,并且对于新副本来说可能会更小,因为它不包含数据库的完整“历史”。

DAOS
不同的副本可以具有不同的DAOS使用设置。这当然也会影响数据库本身的大小。

英文:

First of all: No, this is not an error. As long as the document count is identical everything is ok.

Per Henrik Lausten already gave one reason for this difference but it is not the only one. Here are some more possible reasons (repeating the one of Per just for completeness):

View indexes
They are (by default) only built when views are used. Views with sortable columns even have more than one index to be built. They are often the reason for the biggest differences in size. You can check the size of view indexes in admin- client with right-click on the database, there is a point to check indexes.

White space
Whenever anything in a database is deleted the physical size of the database does not instantly shrink. The deleted stuff leaves "white space" in the database that can be removed by compacting the database. A new replica does not contain white space. The white space can be checked using the "Percent used" button in the database properties

Deletions
Soft deletions
Soft deleted Documents in the trash can are usually not replicated

Deletion Stubs
Somehow related to white space: In order to prevent deleted documents from "coming back" due to replication Domino keeps stubs of deleted documents for (by default) 90 days in a database before it finally purges them. These deletion stubs are small but can sum up if you do a lot of deletion in a database
On disk structure (ODS)
Depending on how old the database is and how the settings on the server are the databases might have different on disk structures. Almost every version brings its own ODS

  • Prior to Domino 9: ODS <= 43 (Templates ODS 23)
  • Domino 9: ODS 52
  • Domino 10/11: ODS 53
  • Domino 12: ODS 55

Every ODS has different efficiency in storing data and therefor needs different amounts of space for the same documents.

Related to ODS there is the type of compression of attachments within the database. It used to be "Huffman" but in all recent versions you should create LZ1 in the database properties (Option "Use LZ1 Compression for Attachments").
Of course this also causes different sizes on disk.

Internal Database structure
The smallest factor for size differences are internal tables for the functionality. E.g. there is the "UNC-Table" that keeps track about all fields and their types within a database. Unless you do a lot of changes in designer and have a lot of fields this will not be a big difference. The UNC table is rebuilt for every replica and might be smaller for new replicas as it does not contain the complete "history" of the database

DAOS
Different replicas can have different settings for using DAOS. This of course also impacts the size of the database itself.

huangapple
  • 本文由 发表于 2023年5月18日 04:55:20
  • 转载请务必保留本文链接:https://go.coder-hub.com/76276132.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定