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
1mo
Aug 28, 2023 (1 month 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?
1Srikanth
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 825 threads (61% resolved)
Similar Threads
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
6mo
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.
4 7
7mo
Solved
Services UI Goes Blank Due to Retention Issue with S3 Bucket
oluchi reports issue with services UI going blank after a while. Conversation explores possible reasons, such as S3 connection problems and disk space, but no resolution is reached.
4 46
4mo