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.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2206299-NE-CLICKHOUS90
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
EPYC 75F3 2P
June 29 2022
  19 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):

EPYC 75F3 2P

Processor: 2 x AMD EPYC 75F3 32-Core @ 2.95GHz (64 Cores / 128 Threads), Motherboard: ASRockRack ROME2D16-2T (P3.30 BIOS), Chipset: AMD Starship/Matisse, Memory: 128GB, Disk: 1000GB Western Digital WD_BLACK SN850 1TB, Graphics: ASPEED, Audio: AMD Starship/Matisse, Monitor: VE228, Network: 2 x Intel 10G X550T

OS: Ubuntu 21.10, Kernel: 5.19.0-rc2-phx-mglru-v12 (x86_64), Desktop: GNOME Shell 40.5, Display Server: X Server, Vulkan: 1.1.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa001114
Security Notes: 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 EPYCOpenBenchmarking.orgPhoronix Test Suite2 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.0ext41920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerVulkanCompilerFile-SystemScreen ResolutionClickhouse AMD EPYC BenchmarksSystem Logs- 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

ClickHouse is an open-source, high performance OLAP data management system. This test profile uses ClickHouse's standard benchmark recommendations per https://clickhouse.com/docs/en/operations/performance-test/ with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all queries performed. Learn more via the OpenBenchmarking.org test page.

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).

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).

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).

EPYC 75F3 2P

Processor: 2 x AMD EPYC 75F3 32-Core @ 2.95GHz (64 Cores / 128 Threads), Motherboard: ASRockRack ROME2D16-2T (P3.30 BIOS), Chipset: AMD Starship/Matisse, Memory: 128GB, Disk: 1000GB Western Digital WD_BLACK SN850 1TB, Graphics: ASPEED, Audio: AMD Starship/Matisse, Monitor: VE228, Network: 2 x Intel 10G X550T

OS: Ubuntu 21.10, Kernel: 5.19.0-rc2-phx-mglru-v12 (x86_64), Desktop: GNOME Shell 40.5, Display Server: X Server, Vulkan: 1.1.182, Compiler: GCC 11.2.0, File-System: ext4, Screen Resolution: 1920x1080

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa001114
Security Notes: 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

Testing initiated at 29 June 2022 12:12 by user phoronix.