Clickhouse doesn't respect cpu and memory limits

[diafour]

Relevant issues: https://github.com/yandex/ClickHouse/issues/2261 https://github.com/yandex/ClickHouse/issues/1531

Clickhouse do not respect limits for cpu and memory and gets restarted by Kubernetes constantly.

Workaround 1: use the whole node for clickhouse — fix cpu and memory problems

Workaround 2: to limit the memory use these settings: max_memory_usage_for_all_queries use_uncompressed_cache merge_tree_max_rows_to_use_cache

There is no settings for number of cpu cores until https://github.com/yandex/ClickHouse/issues/2261 is fixed.

Need a note about these settings usage in README, NOTES.txt and values.yaml.

[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.