clickhouse SQL 错误 [210] [08000]: Connection refused: connect, server ClickHouseNode(addr=http:172.21.12.181:8123, db=SISLEY_DW)@1855130633

数据量大的查询导致connection refused。

clickhouselog： /var/log/clickhouse-server/

 

 

 

 

Setting max_server_memory_usage was set to 28.09 GiB (31.22 GiB available * 0.90 max_server_memory_usage_to_ram_ratio)

服务器配置如下；

 

 

CK建议最低内存128G。