tr 3990x clickhouse AMD Ryzen Threadripper 3990X 64-Core testing with a Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS) and AMD Radeon RX 5700 8GB on Ubuntu 22.10 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2301114-NE-TR3990XCL88&sor .
tr 3990x clickhouse 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 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 Ubuntu 22.10 6.1.0-rc8-phx-mglru (x86_64) GNOME Shell 43.0 X Server 1.21.1.4 + Wayland 4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49) 1.3.224 GCC 12.2.0 + LLVM 15.0.2 ext4 3840x2160 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Processor Details - Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0x8301055 Security Details - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Mitigation of untrained return thunk; SMT enabled with STIBP protection + 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: always-on RSB filling PBRSB-eIBRS: Not affected + srbds: Not affected + tsx_async_abort: Not affected
tr 3990x clickhouse clickhouse: 100M Rows Hits Dataset, First Run / Cold Cache clickhouse: 100M Rows Hits Dataset, Second Run clickhouse: 100M Rows Hits Dataset, Third Run a b c d 176.57 189.11 191.68 183.68 190.45 191.56 183.72 192.59 189.84 180.13 189.81 187.47 OpenBenchmarking.org
ClickHouse 100M Rows Hits Dataset, First Run / Cold Cache OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, First Run / Cold Cache c b d a 40 80 120 160 200 SE +/- 2.44, N = 3 SE +/- 0.74, N = 3 SE +/- 1.15, N = 3 SE +/- 0.92, N = 3 183.72 183.68 180.13 176.57 MIN: 12.9 / MAX: 2857.14 MIN: 12.85 / MAX: 3000 MIN: 12.74 / MAX: 2857.14 MIN: 11.54 / MAX: 2500
ClickHouse 100M Rows Hits Dataset, Second Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, Second Run c b d a 40 80 120 160 200 SE +/- 1.06, N = 3 SE +/- 2.31, N = 3 SE +/- 2.10, N = 3 SE +/- 2.11, N = 3 192.59 190.45 189.81 189.11 MIN: 18.85 / MAX: 2857.14 MIN: 19.24 / MAX: 3000 MIN: 18.57 / MAX: 2500 MIN: 16.74 / MAX: 3157.89
ClickHouse 100M Rows Hits Dataset, Third Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 22.12.3.5 100M Rows Hits Dataset, Third Run a b c d 40 80 120 160 200 SE +/- 1.78, N = 3 SE +/- 3.24, N = 3 SE +/- 0.53, N = 3 SE +/- 1.55, N = 3 191.68 191.56 189.84 187.47 MIN: 15.53 / MAX: 2727.27 MIN: 16.25 / MAX: 3000 MIN: 18.39 / MAX: 3157.89 MIN: 15.48 / MAX: 2400
Phoronix Test Suite v10.8.5