https://giteecode.feishu.cn/wiki/JoiMwq7qlizdq1kdZZccYrdUnog



# cat > /etc/clickhouse-server/config.d/max_threads.xml <<EOF
<yandex>
    <profiles>
        <default>
            <max_threads>4</max_threads> <!-- 设为4个线程 -->
        </default>
    </profiles>
</yandex>
EOF


# systemctl stop clickhouse-server
# systemctl start clickhouse-server



# mkdir /usr/lib/systemd/system/clickhouse-server.service.d/
# cat > /usr/lib/systemd/system/clickhouse-server.service.d/cpu-limit.conf<<EOF
[Service]
# 限制该服务使用的CPU时间为最多4.8个核心（480%）
CPUQuota=480%
EOF

# systemctl daemon-reload
# systemctl stop clickhouse-server
# systemctl start clickhouse-server