我可以在给定的Cassandra集群中创建多少个表的最大数量？有限制吗？ [英] How many Max number of tables I can create in a given Cassandra cluster ? Is there a limit?

问题描述

让我们说我有6个节点群集，这些群集具有m4.2xl（〜8CPU 32GB RAM）
-我可以在键空间中创建多少个最大表？给定键空间的最大表数是否有限制？

Lets say I'm having 6 node cluster having m4.2xl (~ 8CPU 32GB RAM) - How many max tables I can create across keyspaces? and Is there a limit on max tables for a given Keyspace?

高度赞赏您的回答！

推荐答案

可能会降低性能当集群中的表太多时。对于每个表，无论是否有人写入，都需要分配一个额外的内存等。从DataStax文档中：

There could be performance degradation when you have too many tables in the cluster. For every table you need to allocate an additional memory, etc. independent if anybody writes into it or not. From DataStax documentation:

表阈值还与JVM堆和字节数有关。每个表使用大约1 MB的内存。对于要处理的每个表，JVM Heap中都有一个内存表表示形式。具有大数据模型的表会增加内存压力。每个键空间还导致JVM内存中的额外开销。因此，拥有大量键空间也可能会降低表格阈值。

The table thresholds have additional dependencies on JVM Heap and the byte count. Each table uses approximately 1 MB of memory. For each table being acted on, there is a memtable representation in JVM Heap. Tables with large data models increase pressure on memory. Each keyspace also causes additional overhead in JVM memory; therefore having lots of keyspaces may also reduce the table threshold.

DataStax建议不要超过500，尽管我已经看到更多，但它需要对表参数进行额外的调整。

DataStax recommends not to have more than 500, although I have seen more, but it required an additional tuning of table parameters.

这篇关于我可以在给定的Cassandra集群中创建多少个表的最大数量？有限制吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！