Reducing Memory Consumption of Clickhouse DB
TLDR Mano inquired about decreasing Clickhouse DB's memory usage. Srikanth proposed reducing max_threads, but warned that it might slow down the queries.
Powered by Struct AI
1
2
3mo
Aug 28, 2023 (3 months ago)
Mano
Mano
07:23 AM#support, the clickhouse DB consumes more than 29 GB space for 7 days. is it any possible to reduce the memory consumption?
1
Srikanth
Srikanth
01:04 PMHow much data does it need to process? You could lower the
max_threads to reduce the memory but it slows down the queries.
SigNoz Community
Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI
Indexed 1023 threads (61% resolved)
Similar Threads
Resolving S3 Configuration Error on Clickhouse Cluster
sudhanshu reported an error during S3 move configuration on Clickhouse. vishal-signoz suggested increasing memory in Clickhouse. After sudhanshu did this, issue was resolved.
28
3w
Solved
SigNoz crashing in k8s due to ClickHouse OOM
Travis reported SigNoz crashing in k8s due to ClickHouse OOM. The team suggested increasing resources for ClickHouse, and other troubleshooting steps, but the issue remains unresolved.
77
8mo
Clickhouse Memory/CPU Recommendations for k8s
Prim asked for clickhouse memory/CPU recommendations for k8s. Alexei and Pranay provided suggestions and usage information, sharing their experiences.
7
9mo
Solved