clickhouse ryzen laptop

AMD Ryzen 5 5500U testing with a NB01 NL5xNU (1.07.11RTR1 BIOS) and AMD Lucienne 512MB on Fedora Linux 36 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2206250-NE-CLICKHOUS24.

clickhouse ryzen laptopProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerOpenGLCompilerFile-SystemScreen ResolutionABCAMD Ryzen 5 5500U @ 2.10GHz (6 Cores / 12 Threads)NB01 NL5xNU (1.07.11RTR1 BIOS)AMD Renoir/Cezanne16GBSamsung SSD 970 EVO Plus 500GBAMD Lucienne 512MB (1800/400MHz)AMD Renoir Radeon HD AudioRealtek RTL8111/8168/8411 + Intel Wi-Fi 6 AX200Fedora Linux 365.17.5-300.fc36.x86_64 (x86_64)GNOME Shell 42.2X Server + Wayland4.6 Mesa 22.1.2 (LLVM 14.0.0 DRM 3.44)GCC 12.1.1 20220507btrfs1920x1080OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseEnvironment Details- DEBUGINFOD_URLS=https://debuginfod.fedoraproject.org/Processor Details- Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0x8608103 Security Details- SELinux + 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: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

clickhouse ryzen laptopclickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cacheclickhouse: 100M Rows Web Analytics Dataset, Second Runclickhouse: 100M Rows Web Analytics Dataset, Third RunABC75.5084.8784.9973.8186.0481.7976.0384.7182.70OpenBenchmarking.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 CacheABC20406080100SE +/- 0.74, N = 12SE +/- 0.11, N = 3SE +/- 0.70, N = 1275.5073.8176.03MIN: 5.44 / MAX: 15000MIN: 5.71 / MAX: 5454.55MIN: 5.52 / MAX: 150001. 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 RunABC20406080100SE +/- 0.74, N = 12SE +/- 1.74, N = 3SE +/- 0.81, N = 1284.8786.0484.71MIN: 5.78 / MAX: 15000MIN: 6.42 / MAX: 8571.43MIN: 5.46 / MAX: 150001. 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 RunABC20406080100SE +/- 0.72, N = 12SE +/- 2.70, N = 3SE +/- 0.77, N = 1284.9981.7982.70MIN: 5.94 / MAX: 15000MIN: 6.18 / MAX: 12000MIN: 6.09 / MAX: 150001. ClickHouse server version 22.7.1.687 (official build).

Phoronix Test Suite v10.8.4