SingleStore Managed Service

Cluster-Level Limits

Item

Max Spec (enforced)

Max Spec (recommended)

Comments

Number of hosts in a cluster

None

Workloads that generate significant network traffic between hosts should be limited to clusters with smaller number of hosts.

Number of nodes in a cluster (includes leaves and aggregators)

None

Workloads that generate significant network traffic between nodes should be limited to clusters with smaller number of nodes.

Number of databases in a cluster

None

Each database requires memory for transaction buffer and more databases implies greater demand on available memory.

Concurrent queries in a cluster

None

Each aggregator will only actually execute a limited number of queries at once (defined by max_connection_threads, default 192). Beyond that concurrency, queries will be queued up.

Simultaneous client connections

100,000 per aggregator

For more information, read about max_connectionsNon-Sync Variables List