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&gru.

tr 3990x clickhouseProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionabcdAMD 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 AX200Ubuntu 22.106.1.0-rc8-phx-mglru (x86_64)GNOME Shell 43.0X Server 1.21.1.4 + Wayland4.6 Mesa 22.2.1 (LLVM 15.0.2 DRM 3.49)1.3.224GCC 12.2.0 + LLVM 15.0.2ext43840x2160OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseProcessor Details- Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0x8301055Security 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 clickhouseclickhouse: 100M Rows Hits Dataset, First Run / Cold Cacheclickhouse: 100M Rows Hits Dataset, Second Runclickhouse: 100M Rows Hits Dataset, Third Runabcd176.57189.11191.68183.68190.45191.56183.72192.59189.84180.13189.81187.47OpenBenchmarking.org

ClickHouse

100M Rows Hits Dataset, First Run / Cold Cache

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, First Run / Cold Cacheabcd4080120160200SE +/- 0.92, N = 3SE +/- 0.74, N = 3SE +/- 2.44, N = 3SE +/- 1.15, N = 3176.57183.68183.72180.13MIN: 11.54 / MAX: 2500MIN: 12.85 / MAX: 3000MIN: 12.9 / MAX: 2857.14MIN: 12.74 / MAX: 2857.14

ClickHouse

100M Rows Hits Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Second Runabcd4080120160200SE +/- 2.11, N = 3SE +/- 2.31, N = 3SE +/- 1.06, N = 3SE +/- 2.10, N = 3189.11190.45192.59189.81MIN: 16.74 / MAX: 3157.89MIN: 19.24 / MAX: 3000MIN: 18.85 / MAX: 2857.14MIN: 18.57 / MAX: 2500

ClickHouse

100M Rows Hits Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.12.3.5100M Rows Hits Dataset, Third Runabcd4080120160200SE +/- 1.78, N = 3SE +/- 3.24, N = 3SE +/- 0.53, N = 3SE +/- 1.55, N = 3191.68191.56189.84187.47MIN: 15.53 / MAX: 2727.27MIN: 16.25 / MAX: 3000MIN: 18.39 / MAX: 3157.89MIN: 15.48 / MAX: 2400


Phoronix Test Suite v10.8.4