============== Limits

This document provides hard and soft limits in ScyllaDB.

Cluster and Node Limits

.. list-table:: :widths: 50 50 :header-rows: 1

• • Component
  • Limit
• • Nodes per cluster
  • Low hundreds
• • Node size
  • 256 vcpu

See :ref:Hardware Requirements for storage and memory requirements and limits.

CQL Limits

.. list-table:: :widths: 50 50 :header-rows: 1

• • Component
  • Limit
• • Keyspaces per cluster
  • Thousands (tested with 1000)
• • Tables per keyspace
  • Low thousands (tested with 5000)
• • Tables per cluster (including indexes)
  • Thousands
• • Tables with CDC enabled
  • No limit. CDC can be enabled for all tables in a cluster.
• • Materialized views and secondary indexes per table
  • Low tens
• • Columns per table
  • Hundreds
• • Columns per cluster
  • Tens of thousands
• • Partition size
  • Gigabytes
• • Rows per partition
  • No limit

• • Row size

  • Latency-related soft limit:

    Hundreds of kilobytes (good latency) or megabytes (mediocre latency)

• • Key length
  • 65533
• • Keyspace / Table / View / Index name length
  • 192 characters
• • Query parameters in a query
  • 65535 (2^16-1)
• • Statements in a batch
  • 65535 (2^16-1)
• • Fields in a tuple
  • 32768 (2^15) (just a few fields, such as 2-10, are recommended)
• • Collection (List)
  • ~2 billion (2^31)
• • Collection (Set)
  • ~2 billion (2^31)
• • Collection (Map)
  • Number of keys: 65535 (2^16-1)
• • Blob size
  • 2 GB ( less than 1 MB is recommended)
• • Dimension of a vector
  • 16000 (according to OpenSearch limitations)