AMD Ryzen 7 PRO 5850U testing with a HP 8A78 (F.04 BIOS) and AMD Cezanne 512MB on Pop 22.04 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 2206251-NE-CLICKHOUS91 clickhouse hp dev one - Phoronix Test Suite clickhouse hp dev one AMD Ryzen 7 PRO 5850U testing with a HP 8A78 (F.04 BIOS) and AMD Cezanne 512MB on Pop 22.04 via the Phoronix Test Suite.
HTML result view exported from: https://openbenchmarking.org/result/2206251-NE-CLICKHOUS91&grt&rdt&rro .
clickhouse hp dev one Processor Motherboard Chipset Memory Disk Graphics Audio Network OS Kernel Desktop Display Server OpenGL Vulkan Compiler File-System Screen Resolution A B C D E AMD Ryzen 7 PRO 5850U @ 4.51GHz (8 Cores / 16 Threads) HP 8A78 (F.04 BIOS) AMD Renoir/Cezanne 16GB 1024GB SK hynix PC711 HFS001TDE9X073N AMD Cezanne 512MB (2000/400MHz) AMD Renoir Radeon HD Audio Realtek RTL8822CE 802.11ac PCIe Pop 22.04 5.18.4-xanmod1 (x86_64) GNOME Shell 42.1 X Server 1.21.1.3 4.6 Mesa 22.0.1 (LLVM 13.0.1 DRM 3.46) 1.2.204 GCC 11.2.0 ext4 1920x1080 OpenBenchmarking.org Kernel Details - Transparent Huge Pages: madvise Processor Details - Scaling Governor: amd-pstate schedutil (Boost: Enabled) - CPU Microcode: 0xa50000c Security Details - 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 hp dev one clickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cache clickhouse: 100M Rows Web Analytics Dataset, Second Run clickhouse: 100M Rows Web Analytics Dataset, Third Run A B C D E 101.17 110.23 112.88 101.44 115.25 115.38 102.58 113.44 113.70 102.39 114.66 116.09 100.96 114.51 112.03 OpenBenchmarking.org
ClickHouse 100M Rows Web Analytics Dataset, First Run / Cold Cache OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, First Run / Cold Cache E D C B A 20 40 60 80 100 SE +/- 1.25, N = 2 SE +/- 0.43, N = 2 SE +/- 0.77, N = 3 SE +/- 0.13, N = 2 SE +/- 1.37, N = 2 100.96 102.39 102.58 101.44 101.17 MIN: 7.57 / MAX: 15000 MIN: 7.58 / MAX: 15000 MIN: 7.63 / MAX: 15000 MIN: 7.64 / MAX: 15000 MIN: 7.62 / MAX: 15000 1. ClickHouse server version 22.7.1.687 (official build).
ClickHouse 100M Rows Web Analytics Dataset, Second Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, Second Run E D C B A 30 60 90 120 150 SE +/- 0.17, N = 2 SE +/- 1.77, N = 2 SE +/- 2.51, N = 3 SE +/- 0.62, N = 2 SE +/- 0.47, N = 2 114.51 114.66 113.44 115.25 110.23 MIN: 7.6 / MAX: 12000 MIN: 7.71 / MAX: 15000 MIN: 7.72 / MAX: 15000 MIN: 7.73 / MAX: 15000 MIN: 7.57 / MAX: 10000 1. ClickHouse server version 22.7.1.687 (official build).
ClickHouse 100M Rows Web Analytics Dataset, Third Run OpenBenchmarking.org Queries Per Minute, Geo Mean, More Is Better ClickHouse 100M Rows Web Analytics Dataset, Third Run E D C B A 30 60 90 120 150 SE +/- 1.59, N = 2 SE +/- 0.25, N = 2 SE +/- 0.62, N = 3 SE +/- 1.47, N = 2 SE +/- 0.82, N = 2 112.03 116.09 113.70 115.38 112.88 MIN: 7.58 / MAX: 15000 MIN: 7.73 / MAX: 15000 MIN: 7.68 / MAX: 15000 MIN: 7.64 / MAX: 15000 MIN: 7.67 / MAX: 15000 1. ClickHouse server version 22.7.1.687 (official build).
Phoronix Test Suite v10.8.4