如何使用 ClickHouse 测试您的硬件

你可以在任何服务器上运行基本的 ClickHouse 性能测试，而无需安装 ClickHouse 软件包。

自动运行

你可以使用一个简单脚本来运行基准测试。

  1. 下载脚本

    1. wget https://raw.githubusercontent.com/ClickHouse/ClickBench/main/hardware/hardware.sh

  2. 运行脚本

    1. chmod a+x ./hardware.sh
    2. ./hardware.sh

  3. 复制输出的信息并将它发送给 feedback@clickhouse.com

所有的结果都在这里公布： https://clickhouse.com/benchmark/hardware/

人工运行

或者，你可以按照以下步骤实施基准测试。

  1. # For amd64:
  2. wget https://builds.clickhouse.com/master/amd64/clickhouse
  3. # For aarch64:
  4. wget https://builds.clickhouse.com/master/aarch64/clickhouse
  5. # For powerpc64le:
  6. wget https://builds.clickhouse.com/master/powerpc64le/clickhouse
  7. # For freebsd:
  8. wget https://builds.clickhouse.com/master/freebsd/clickhouse
  9. # For freebsd-aarch64:
  10. wget https://builds.clickhouse.com/master/freebsd-aarch64/clickhouse
  11. # For freebsd-powerpc64le:
  12. wget https://builds.clickhouse.com/master/freebsd-powerpc64le/clickhouse
  13. # For macos:
  14. wget https://builds.clickhouse.com/master/macos/clickhouse
  15. # For macos-aarch64:
  16. wget https://builds.clickhouse.com/master/macos-aarch64/clickhouse
  17. # Then do:
  18. chmod a+x clickhouse

  1. 下载基准文件

    1. wget https://raw.githubusercontent.com/ClickHouse/ClickHouse/master/benchmark/hardware/benchmark-new.sh
    2. chmod a+x benchmark-new.sh
    3. wget https://raw.githubusercontent.com/ClickHouse/ClickHouse/master/benchmark/hardware/queries.sql

  2. 根据 Yandex.Metrica 数据集 中的说明下载测试数据（“ hits ” 数据表包含 1 亿行记录）。

    1. wget https://datasets.clickhouse.com/hits/partitions/hits_100m_obfuscated_v1.tar.xz
    2. tar xvf hits_100m_obfuscated_v1.tar.xz -C .
    3. mv hits_100m_obfuscated_v1/* .

  3. 运行服务器：

    1. ./clickhouse server

  4. 检查数据：在另一个终端中通过 ssh 登陆服务器

    1. ./clickhouse client --query "SELECT count() FROM hits_100m_obfuscated"
    2. 100000000

  5. 运行基准测试：

    1. ./benchmark-new.sh hits_100m_obfuscated

  6. 将有关硬件配置的型号和信息发送到 clickhouse-feedback@yandex-team.com

所有结果都在这里公布：https://clickhouse.com/benchmark/hardware/