Clickhouse For CentOs
Using JDK 11 as well as enabling G1 garbage collector is recommended. Comparing to JDK 8, the performance of handling jobs under multi-threads will be improved more than 30%.
curl -O "https://packages.clickhouse.com/tgz/stable/clickhouse-common-static-22.2.3.5.tgz"
curl -O "https://packages.clickhouse.com/tgz/stable/clickhouse-server-22.2.3.5.tgz"
curl -O "https://packages.clickhouse.com/tgz/stable/clickhouse-client-22.2.3.5.tgz"

# untar the file and execute the shell
tar -xzvf "clickhouse-common-static-22.2.3.5.tgz"
# generate the binary file
sudo "clickhouse-common-static-22.2.3.5/install/doinst.sh"
tar -xzvf "clickhouse-server-22.2.3.5.tgz"
# create clickhouse-server soft link and install the default config serice
# the initial password is [email protected] you can config whether remote access is allowed
sudo "clickhouse-server-22.2.3.5/install/doinst.sh"
# start the service
sudo /etc/init.d/clickhouse-server start
tar -xzvf "clickhouse-client-22.2.3.5.tgz"
# create clickhouse-client soft link and install the client config files
sudo "clickhouse-client-22.2.3.5/install/doinst.sh"
We will need to limit the clickhouse service If the client server has a memory less than 32GB.
In
/etc/clickhouse-server/config.xml
set max_server_memory_usage_to_ram_ratio
to 0.125 so that 32G*0.125 will be 4G
Update
/etc/clickhouse-server/users.xml
and set max_memory_usage
to 4000000000, max_bytes_before_external_group_by
to 2000000000. You may need to create max_bytes_before_external_group_by
if it isn't present.
Restart the Clickhouse service:
sudo /etc/init.d/clickhouse-server restart
With this config, the Simple mode will use 22G memory and the Rugular mode will be in 18G memory.
# Update sqlservice.sh, set the heapsize as 18G
elif (( $memory < 32*1024*1024 ));
then
heapsize="18g"
If mistakenly set to another password, you will need:
- 1.delete
/etc/clickhouse-server/users.d/default-password.xml
- 2.
- 3.restart Clickhouse,
sudo /etc/init.d/clickhouse-server restart
cd /wings/sqlflow/backend
sh bin/init_regular.sh
If you got

Then you might need to check for your OS version and the Clickhouse is not properly installed. Check Ubuntu/Debian/RHEL Installation.
If your clickhouse is properly installed but you still got errors, please check
/var/log/clickhouse-sever
for error logs.cd /wings/sqlflow/backend
sh bin/backend.sh
Last modified 22d ago