How to reduse clickhouse memory usage?

[yurchenkosv]

In our setup, we have several nodes with ~8Gb RAM. Clickhouse eats all of memory and not give it back. So clickhouse memory usage grows in expluatation period. And when it's more than node can give, node crashes with OutOfMemory error. Is there some option to reduse memory usage of clickhouse service

[rafagonc]

In the clickhouse-config config map you can configure your database to limit the maximum RAM usage in users.xml yandex -> profiles -> default -> max_memory usage. I am using 1GB RAM only for clickhouse also on limits of the deployment, it may restart sometimes but without these limits the clickhouse deployment eats all node memory.