clickhouse threadripper AMD Ryzen Threadripper 3990X 64-Core testing with a Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS) and AMD Radeon RX 5700 8GB on Fedora Linux 36 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2206250-NE-CLICKHOUS88&grt&sor .
clickhouse threadripper Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server OpenGL Compiler File-System Screen Resolution A B C D AMD Ryzen Threadripper 3990X 64-Core @ 2.90GHz (64 Cores / 128 Threads) Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS) AMD Starship/Matisse 128GB Samsung SSD 970 EVO Plus 500GB AMD Radeon RX 5700 8GB (1750/875MHz) AMD Navi 10 HDMI Audio DELL P2415Q Intel I211 + Intel Wi-Fi 6 AX200 Fedora Linux 36 5.18.5-200.fc36.x86_64 (x86_64) GNOME Shell 42.2 X Server + Wayland 4.6 Mesa 22.1.2 (LLVM 14.0.0 DRM 3.46) GCC 12.1.1 20220507 btrfs 3840x2160 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Environment Details - DEBUGINFOD_URLS=https://debuginfod.fedoraproject.org/ Processor Details - Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0x8301039 Security Details - SELinux + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: 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 Retpolines IBPB: conditional STIBP: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected
clickhouse threadripper 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 258.97 264.65 270.37 264.51 270.59 271.72 259.69 267.91 265.88 257.66 260.08 266.89 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 B C A D 60 120 180 240 300 SE +/- 2.66, N = 3 SE +/- 0.73, N = 3 SE +/- 2.18, N = 3 SE +/- 4.25, N = 12 264.51 259.69 258.97 257.66 MIN: 18.73 / MAX: 20000 MIN: 18.52 / MAX: 15000 MIN: 18.76 / MAX: 12000 MIN: 18.66 / MAX: 20000 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 B C A D 60 120 180 240 300 SE +/- 1.36, N = 3 SE +/- 2.15, N = 3 SE +/- 3.69, N = 3 SE +/- 2.30, N = 12 270.59 267.91 264.65 260.08 MIN: 18.7 / MAX: 20000 MIN: 18.58 / MAX: 20000 MIN: 18.83 / MAX: 20000 MIN: 18.32 / MAX: 20000 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 60 120 180 240 300 SE +/- 4.13, N = 3 SE +/- 7.80, N = 3 SE +/- 2.00, N = 12 SE +/- 4.45, N = 3 271.72 270.37 266.89 265.88 MIN: 19.34 / MAX: 20000 MIN: 18.84 / MAX: 20000 MIN: 18.09 / MAX: 20000 MIN: 18.77 / MAX: 20000 1. ClickHouse server version 22.7.1.687 (official build).
Phoronix Test Suite v10.8.5