最大。尺寸宽行？ [英] Max. size of wide rows?

问题描述

理论上，Cassandra允许在一排很宽的行中有20亿列。

我听说在现实中高达50.000 cols / 50.000-100.000 cols / 100 MB可以，但需要一些调整;并且每行不应超过100.000 / 100 MB列。原因是这将给堆施加压力。

这是否有道理？

解决方案

单个分区中的单元格（行数x列）的最大数量为20亿。

此外，单个列值不能大于2GB，但在实践中，单个数字MB是更合理的限制，因为没有blob值的流式传输或随机访问。 p>

大于100Mb的分区可能会对堆造成巨大压力。

Theoretically, Cassandra allows up to 2 billion columns in a wide row.

I have heard that in reality up to 50.000 cols/50 MB are fine; 50.000-100.000 cols/100 MB are OK but require some tuning; and that one should never go above 100.000/100 MB columns per row. The reason being that this will put pressure on the heap.

Is there some truth to this?

解决方案

In Cassandra, the maximum number of cells (rows x columns) in a single partition is 2 billion.

Additionally, a single column value may not be larger than 2GB, but in practice, "single digits of MB" is a more reasonable limit, since there is no streaming or random access of blob values.

Partitions greater than 100Mb can cause significant pressure on the heap.

这篇关于最大。尺寸宽行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！