clickhouse threadripper amd 3990X

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/2206283-NE-CLICKHOUS93.

clickhouse threadripper amd 3990XProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionAMD Ryzen Threadripper 3990X 64-Core - AMD Radeon RXAMD Ryzen Threadripper 3990X 64-Core @ 2.90GHz (64 Cores / 128 Threads)Gigabyte TRX40 AORUS PRO WIFI (F4p BIOS)AMD Starship/Matisse128GBSamsung SSD 970 EVO Plus 500GBAMD Radeon RX 5700 8GB (1750/875MHz)AMD Navi 10 HDMI AudioDELL P2415QIntel I211 + Intel Wi-Fi 6 AX200Fedora Linux 365.18.5-200.fc36.x86_64 (x86_64)GNOME Shell 42.2X Server + Wayland4.6 Mesa 22.1.2 (LLVM 14.0.0 DRM 3.46)GCC 12.1.1 20220507btrfs3840x2160OpenBenchmarking.org- Transparent Huge Pages: madvise- DEBUGINFOD_URLS=https://debuginfod.fedoraproject.org/- Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0x8301039- 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 amd 3990Xclickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cacheclickhouse: 100M Rows Web Analytics Dataset, Second Runclickhouse: 100M Rows Web Analytics Dataset, Third RunAMD Ryzen Threadripper 3990X 64-Core - AMD Radeon RX254.61261.00267.06OpenBenchmarking.org

ClickHouse

100M Rows Web Analytics Dataset, First Run / Cold Cache

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, First Run / Cold CacheAMD Ryzen Threadripper 3990X 64-Core - AMD Radeon RX60120180240300SE +/- 2.43, N = 15254.61MIN: 18.51 / MAX: 200001. ClickHouse server version 22.7.1.687 (official build).

ClickHouse

100M Rows Web Analytics Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, Second RunAMD Ryzen Threadripper 3990X 64-Core - AMD Radeon RX60120180240300SE +/- 1.58, N = 15261.00MIN: 18.58 / MAX: 200001. ClickHouse server version 22.7.1.687 (official build).

ClickHouse

100M Rows Web Analytics Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse100M Rows Web Analytics Dataset, Third RunAMD Ryzen Threadripper 3990X 64-Core - AMD Radeon RX60120180240300SE +/- 1.84, N = 15267.06MIN: 18.36 / MAX: 200001. ClickHouse server version 22.7.1.687 (official build).


Phoronix Test Suite v10.8.5