Quotas and limits in Managed Service for ClickHouse®
Managed Service for ClickHouse® has the following limits:
- Quotas are organizational constraints that can be changed by support on request.
- Limits are technical constraints of the Yandex Cloud architecture. You cannot change the limits.
If you need more resources, you can increase your quotas in one of the following ways:
- Make a request to increase your quotas.
- Contact support and specify which quotas you want increased and by how much.
To have your request processed, you must have the quota-manager.requestOperator role or higher, e.g., editor or admin.
You can manage your quotas with Cloud Quota Manager.
Quotas
|
Type of limit |
Value |
|
Number of clusters per cloud |
16 |
|
Total number of CPU cores for all database hosts per cloud |
64 |
|
Total virtual memory for all database hosts per cloud |
512 GB |
|
Total storage capacity for all clusters per cloud |
4,096 GB |
|
Number of GPUs |
0 |
Limits
|
Type of limit |
Minimum value |
Maximum value |
|
Host class |
b1.medium (2 × 50% vCPUs, Intel Broadwell, 4 GB RAM) |
m4a-c224-m1792 (224 vCPU AMD Zen 4, 1,792 GB RAM) |
|
Number of ClickHouse® hosts per non-sharded cluster when using a network HDD or SSD storage or an ultra high-speed network SSD storage with three replicas |
1 |
7 |
|
Number of ClickHouse® hosts per non-sharded cluster when using a non-replicated SSD storage |
3 |
7 |
|
Number of ClickHouse® hosts per non-sharded cluster when using a local SSD storage |
2 |
7 |
|
Number of shards per sharded cluster |
1 |
100 |
|
Number of hosts per shard when using a network HDD or SSD storage or an ultra high-speed network SSD storage with three replicas |
1 |
7 |
|
Number of hosts per shard when using a non-replicated SSD storage |
3 |
7 |
|
Number of hosts per shard when using a local SSD storage |
2 |
7 |
|
Total number of hosts per cluster |
1 |
355 (50 shards × 7 hosts + 5 ZooKeeper hosts) |
|
Amount of data per host when using a network HDD or SSD storage (for Intel Broadwell and Intel Cascade Lake) |
10 GB |
4096 GB |
|
Amount of data per host when using a network HDD or SSD storage (for Intel Ice Lake) |
10 GB |
8192 GB |
|
Amount of data per host when using a non-replicated SSD storage or an ultra high-speed network SSD storage with three replicas |
93 GB |
16,368 GB |
|
Amount of data per host when using a local SSD storage (for Intel Broadwell) |
10 GB |
4096 GB |
|
Amount of data per host when using a local SSD storage (for Intel Cascade Lake and Intel Ice Lake) |
10 GB |
6,144 GB |
|
Number of databases per cluster |
1 |
1000 |
Limits on the maximum number of objects
The limits on the maximum number of objects per cluster have two threshold values:
-
Soft limit: When reached, the
system.warningssystem table will display a warning. -
Hard limit: When reached, creating new objects of this type will end with an error message.
Note
The hard limit threshold only works in ClickHouse® 25.2 and higher.
|
Type of limit |
Soft limit |
Hard limit |
|
Number of databases |
500 |
1,000 |
|
Number of tables |
5,000 |
10,000 |
|
Number of views |
5,000 |
10,000 |
|
Number of external dictionaries |
500 |
1,000 |
All limits are implemented based on the ClickHouse® server settings. You cannot change them.
ClickHouse® is a registered trademark of ClickHouse, Inc.