Clickhouse AMD EPYC

2 x AMD EPYC 75F3 32-Core testing with a ASRockRack ROME2D16-2T (P3.30 BIOS) and ASPEED on Ubuntu 21.10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2206299-NE-CLICKHOUS90&grt.

Clickhouse AMD EPYCProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerVulkanCompilerFile-SystemScreen ResolutionEPYC 75F3 2P2 x AMD EPYC 75F3 32-Core @ 2.95GHz (64 Cores / 128 Threads)ASRockRack ROME2D16-2T (P3.30 BIOS)AMD Starship/Matisse128GB1000GB Western Digital WD_BLACK SN850 1TBASPEEDAMD Starship/MatisseVE2282 x Intel 10G X550TUbuntu 21.105.19.0-rc2-phx-mglru-v12 (x86_64)GNOME Shell 40.5X Server1.1.182GCC 11.2.0ext41920x1080OpenBenchmarking.org- Transparent Huge Pages: madvise- Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa001114 - itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: 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 IBRS_FW STIBP: always-on RSB filling + srbds: Not affected + tsx_async_abort: Not affected

Clickhouse AMD EPYCclickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cacheclickhouse: 100M Rows Web Analytics Dataset, Second Runclickhouse: 100M Rows Web Analytics Dataset, Third RunEPYC 75F3 2P364.62376.41377.16OpenBenchmarking.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 CacheEPYC 75F3 2P80160240320400SE +/- 3.03, N = 9364.62MIN: 37.01 / 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 RunEPYC 75F3 2P80160240320400SE +/- 2.44, N = 9376.41MIN: 55.3 / 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 RunEPYC 75F3 2P80160240320400SE +/- 2.91, N = 9377.16MIN: 55.87 / MAX: 200001. ClickHouse server version 22.7.1.687 (official build).

Phoronix Test Suite v10.8.5