Intel Core i3-12100 testing with a ASRock B660M-HDV (6.02 BIOS) and Intel ADL-S GT1 16GB on Ubuntu 22.04 via the Phoronix Test Suite.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2206254-NE-CLICKHOUS01 clickhouse 2100 - Phoronix Test Suite clickhouse 2100 Intel Core i3-12100 testing with a ASRock B660M-HDV (6.02 BIOS) and Intel ADL-S GT1 16GB on Ubuntu 22.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2206254-NE-CLICKHOUS01&sor&grs&export=pdf .
clickhouse 2100 Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution A B C D Intel Core i3-12100 @ 5.50GHz (4 Cores / 8 Threads) ASRock B660M-HDV (6.02 BIOS) Intel Device 7aa7 16GB 512GB Sabrent Intel ADL-S GT1 16GB (1400MHz) Realtek ALC897 DELL S2409W Intel Ubuntu 22.04 5.18.0-051800-generic (x86_64) GNOME Shell 42.1 X Server 1.20.14 + Wayland 4.6 Mesa 22.0.1 1.2.204 GCC 11.2.0 ext4 1920x1080 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Processor Details - Scaling Governor: intel_pstate powersave (EPP: balance_performance) - CPU Microcode: 0x1f - Thermald 2.4.9 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Enhanced IBRS IBPB: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected
clickhouse 2100 clickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cache clickhouse: 100M Rows Web Analytics Dataset, Second Run clickhouse: 100M Rows Web Analytics Dataset, Third Run A B C D 85.69 94.86 96.97 87.83 97.65 97.41 88.44 96.86 95.60 89.68 99.03 95.85 OpenBenchmarking.org
ClickHouse 100M Rows Web Analytics Dataset, First Run / Cold Cache OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, First Run / Cold Cache D C B A 20 40 60 80 100 SE +/- 0.95, N = 4 SE +/- 0.98, N = 5 SE +/- 0.46, N = 3 SE +/- 0.36, N = 3 89.68 88.44 87.83 85.69 MIN: 6.88 / MAX: 15000 MIN: 6.79 / MAX: 20000 MIN: 7.25 / MAX: 15000 MIN: 6.99 / MAX: 15000 1. ClickHouse server version 22.7.1.687 (official build).
ClickHouse 100M Rows Web Analytics Dataset, Second Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, Second Run D B C A 20 40 60 80 100 SE +/- 1.72, N = 4 SE +/- 1.09, N = 3 SE +/- 1.35, N = 5 SE +/- 1.51, N = 3 99.03 97.65 96.86 94.86 MIN: 7.87 / MAX: 30000 MIN: 7.76 / MAX: 20000 MIN: 7.73 / MAX: 30000 MIN: 7.71 / MAX: 30000 1. ClickHouse server version 22.7.1.687 (official build).
ClickHouse 100M Rows Web Analytics Dataset, Third Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, Third Run B A D C 20 40 60 80 100 SE +/- 0.82, N = 3 SE +/- 0.93, N = 3 SE +/- 1.04, N = 4 SE +/- 0.98, N = 5 97.41 96.97 95.85 95.60 MIN: 8.11 / MAX: 20000 MIN: 8.05 / MAX: 30000 MIN: 7.68 / MAX: 30000 MIN: 7.68 / MAX: 20000 1. ClickHouse server version 22.7.1.687 (official build).
Phoronix Test Suite v10.8.4