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.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2301114-NE-TR3990XCL88 tr 3990x clickhouse - Phoronix Test Suite 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&grw .
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