1
2
3
4
5
6
7
8

export CONTAINER_CLI=nerdctl
export IMAGE=clickhouse/clickhouse-server:24
export CLICKHOUSE_INSTANCE_NAME=clickhouse
export CH_DATA=/data/ops/clickhouse/$CLICKHOUSE_INSTANCE_NAME
mkdir -p $CH_DATA/data $CH_DATA/log
export CLICKHOUSE_PORT=9000
export CLICKHOUSE_USER=default
export CLICKHOUSE_PASSWORD=xxxxxx

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

$CONTAINER_CLI run -d \
  --name $CLICKHOUSE_INSTANCE_NAME \
  --restart always \
  --network host \
  --ulimit memlock=-1 \
  --ulimit stack=67108864 \
  --ulimit nofile=1048576:1048576 \
  --memory-swappiness=0 \
  --cap-add=SYS_NICE \
  --cap-add=SYS_RESOURCE \
  -v $CH_DATA/data:/var/lib/clickhouse \
  -v $CH_DATA/log:/var/log/clickhouse-server \
  -e CLICKHOUSE_USER=$CLICKHOUSE_USER \
  -e CLICKHOUSE_PASSWORD=$CLICKHOUSE_PASSWORD \
  -e CLICKHOUSE_PORT=$CLICKHOUSE_PORT \
  $IMAGE

1

$CONTAINER_CLI exec -it $CLICKHOUSE_INSTANCE_NAME clickhouse-client --host 127.0.0.1 --port $CLICKHOUSE_PORT

1
2
3
4
5
6

echo "ClickHouse:
Instance Name:$CLICKHOUSE_INSTANCE_NAME
IP:$(hostname -I | awk '{print $1}')
Port:$CLICKHOUSE_PORT
User:$CLICKHOUSE_USER
Password:$CLICKHOUSE_PASSWORD" | column -t -s ':'

1

curl -O https://builds.clickhouse.com/master/amd64/clickhouse -O ./clickhouse && chmod +x ./clickhouse

1
2
3
4
5
6

./clickhouse benchmark \
    --host 127.0.0.1 \
    --port $CLICKHOUSE_PORT \
    --concurrency 10 \
    --iterations 1000000 \
    --query "SELECT 1"