How to Test Your Hardware with ClickHouse

    1. Go to “commits” page: https://github.com/ClickHouse/ClickHouse/commits/master
    2. Click on the first green check mark or red cross with green “ClickHouse Build Check” and click on the “Details” link near “ClickHouse Build Check”. There is no such link in some commits, for example commits with documentation. In this case, choose the nearest commit having this link.
    3. Copy the link to binary for amd64 or aarch64.
    4. ssh to the server and download it with wget:
    1. wget https://raw.githubusercontent.com/ClickHouse/ClickHouse/master/benchmark/clickhouse/benchmark-new.sh
    2. chmod a+x benchmark-new.sh
    1. Download test data according to the instruction (“hits” table containing 100 million rows).
    1. ./clickhouse server
    1. Check the data: ssh to the server in another terminal
    1. Edit the benchmark-new.sh, change clickhouse-client to and add --max_memory_usage 100000000000 parameter.
    1. mcedit benchmark-new.sh
    1. Send the numbers and the info about your hardware configuration to [email protected]

    All the results are published here: