databases-ryzen-9-5950x

AMD Ryzen 9 5950X 16-Core testing with a ASUS ROG CROSSHAIR VIII HERO (WI-FI) (4006 BIOS) and AMD Radeon RX 6700/6700 XT / 6800M on Ubuntu 22.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2208199-PTS-DATABASE41&rdt&grs.

databases-ryzen-9-5950x ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionAAABCAMD Ryzen 9 5950X 16-Core @ 3.40GHz (16 Cores / 32 Threads)ASUS ROG CROSSHAIR VIII HERO (WI-FI) (4006 BIOS)AMD Starship/Matisse32GB1000GB Sabrent Rocket 4.0 PlusAMD Radeon RX 6700/6700 XT / 6800M (2880/1124MHz)AMD Navi 21 HDMI AudioASUS MG28URealtek RTL8125 2.5GbE + Intel I211 + Intel Wi-Fi 6 AX200Ubuntu 22.045.15.0-46-generic (x86_64)GNOME Shell 42.2X Server 1.21.1.3 + Wayland4.6 Mesa 22.0.1 (LLVM 13.0.1 DRM 3.42)1.3.204GCC 11.2.0ext43840x2160OpenBenchmarking.orgKernel Details- Transparent Huge Pages: madviseCompiler Details- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-cet --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-serialization=2 --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-11-gBFGDP/gcc-11-11.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-11-gBFGDP/gcc-11-11.2.0/debian/tmp-gcn/usr --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v Processor Details- Scaling Governor: acpi-cpufreq schedutil (Boost: Enabled) - CPU Microcode: 0xa201016 Security Details- itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Not affected + retbleed: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + 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

databases-ryzen-9-5950x redis: LPOP - 500redis: LPOP - 50redis: GET - 50redis: GET - 500redis: SET - 500redis: GET - 1000clickhouse: 100M Rows Web Analytics Dataset, First Run / Cold Cachememtier-benchmark: Redis - 100 - 1:10redis: SADD - 1000redis: LPUSH - 500redis: LPUSH - 1000memtier-benchmark: Redis - 50 - 1:1memtier-benchmark: Redis - 100 - 1:1redis: LPOP - 1000memtier-benchmark: Redis - 100 - 5:1redis: SADD - 500redis: SADD - 50memtier-benchmark: Redis - 50 - 1:5memtier-benchmark: Redis - 50 - 5:1clickhouse: 100M Rows Web Analytics Dataset, Third Runmemtier-benchmark: Redis - 100 - 1:5dragonflydb: 50 - 5:1clickhouse: 100M Rows Web Analytics Dataset, Second Runmemtier-benchmark: Redis - 50 - 1:10dragonflydb: 200 - 1:1dragonflydb: 50 - 1:5dragonflydb: 200 - 1:5redis: SET - 1000dragonflydb: 200 - 5:1dragonflydb: 50 - 1:1redis: LPUSH - 50redis: SET - 50AAABC3895846.673807839.333724000.533226788.022606814.922855264.75188.153090774.752239775.932179467.332996694.033004229.40196.323674898.75194.703692396.294046276.173916925.462625813.083544444.903784770.292177365.352477250.402136790.52194544.53199413.753330506.7526017742868400194.162584928.6628376862109831.52330500.752401981.752150513.7921280602253389.5431431293037508.252508871.822125471.33198.982454493.053691129.84198.642480132.273672848.964029664.683898686.8326453313515962.973767115.141908181.1224730882080430.252251582.52939632.52827145.52251988.53229451.25194.642351366.22294352922878472297830.52442857.852279522.612241926.252139029.143080200.52940018.52440927.742200876.25195.752381286.413583380.17198.482504152.193687491.344069312.43929914.652627028.53520664.133766456.38239181525814911967919.38227152932144143181528.252575374.53016645.25175.5722742512516980.122936827.52214388.752172629.52282986.772279343.3121792692230043.743091054.2530476962422235.492184699192.342402414.313664149.37198.512469793.323722843.124076314.023934765.652623587.253533311.183760554.452149189.752692563OpenBenchmarking.org

Redis

Test: LPOP - Parallel Connections: 500

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 500AAABC800K1600K2400K3200K4000KSE +/- 12295.78, N = 33895846.672136790.502080430.251967919.381. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: LPOP - Parallel Connections: 50

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 50AAABC800K1600K2400K3200K4000KSE +/- 33891.79, N = 153807839.332194544.502251582.502271529.001. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: GET - Parallel Connections: 50

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 50AAABC800K1600K2400K3200K4000KSE +/- 37516.89, N = 153724000.533199413.752939632.503214414.001. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: GET - Parallel Connections: 500

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 500AAABC700K1400K2100K2800K3500KSE +/- 43636.66, N = 153226788.023330506.752827145.503181528.251. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: SET - Parallel Connections: 500

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 500AAABC600K1200K1800K2400K3000KSE +/- 24853.06, N = 32606814.922601774.002251988.502575374.501. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: GET - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: GET - Parallel Connections: 1000AAABC700K1400K2100K2800K3500KSE +/- 31174.07, N = 32855264.752868400.003229451.253016645.251. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

ClickHouse

100M Rows Web Analytics Dataset, First Run / Cold Cache

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, First Run / Cold CacheAAABC4080120160200SE +/- 1.48, N = 15188.15194.16194.64175.57MIN: 9.27 / MAX: 30000MIN: 9.34 / MAX: 30000MIN: 9.46 / MAX: 30000MIN: 9.43 / MAX: 60001. ClickHouse server version 22.5.4.19 (official build).

memtier_benchmark

Protocol: Redis - Clients: 100 - Set To Get Ratio: 1:10

OpenBenchmarking.orgOps/sec, More Is Bettermemtier_benchmark 1.4Protocol: Redis - Clients: 100 - Set To Get Ratio: 1:10AABC600K1200K1800K2400K3000K2584928.662351366.222516980.121. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Redis

Test: SADD - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 1000AAABC700K1400K2100K2800K3500KSE +/- 1454.97, N = 33090774.752837686.002943529.002936827.501. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: LPUSH - Parallel Connections: 500

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 500AAABC500K1000K1500K2000K2500KSE +/- 27735.13, N = 152239775.932109831.502287847.002214388.751. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: LPUSH - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 1000AABC500K1000K1500K2000K2500K2330500.752297830.502172629.501. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

memtier_benchmark

Protocol: Redis - Clients: 50 - Set To Get Ratio: 1:1

OpenBenchmarking.orgOps/sec, More Is Bettermemtier_benchmark 1.4Protocol: Redis - Clients: 50 - Set To Get Ratio: 1:1AABC500K1000K1500K2000K2500K2401981.752442857.852282986.771. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

memtier_benchmark

Protocol: Redis - Clients: 100 - Set To Get Ratio: 1:1

OpenBenchmarking.orgOps/sec, More Is Bettermemtier_benchmark 1.4Protocol: Redis - Clients: 100 - Set To Get Ratio: 1:1AABC500K1000K1500K2000K2500K2150513.792279522.612279343.311. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Redis

Test: LPOP - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPOP - Parallel Connections: 1000AAABC500K1000K1500K2000K2500KSE +/- 10851.74, N = 32179467.332128060.002241926.252179269.001. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

memtier_benchmark

Protocol: Redis - Clients: 100 - Set To Get Ratio: 5:1

OpenBenchmarking.orgOps/sec, More Is Bettermemtier_benchmark 1.4Protocol: Redis - Clients: 100 - Set To Get Ratio: 5:1AABC500K1000K1500K2000K2500K2253389.542139029.142230043.741. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Redis

Test: SADD - Parallel Connections: 500

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 500AAABC700K1400K2100K2800K3500KSE +/- 34116.99, N = 152996694.033143129.003080200.503091054.251. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: SADD - Parallel Connections: 50

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SADD - Parallel Connections: 50AAABC700K1400K2100K2800K3500KSE +/- 20175.86, N = 133004229.403037508.252940018.503047696.001. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

memtier_benchmark

Protocol: Redis - Clients: 50 - Set To Get Ratio: 1:5

OpenBenchmarking.orgOps/sec, More Is Bettermemtier_benchmark 1.4Protocol: Redis - Clients: 50 - Set To Get Ratio: 1:5AABC500K1000K1500K2000K2500K2508871.822440927.742422235.491. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

memtier_benchmark

Protocol: Redis - Clients: 50 - Set To Get Ratio: 5:1

OpenBenchmarking.orgOps/sec, More Is Bettermemtier_benchmark 1.4Protocol: Redis - Clients: 50 - Set To Get Ratio: 5:1AABC500K1000K1500K2000K2500K2125471.332200876.252184699.001. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

ClickHouse

100M Rows Web Analytics Dataset, Third Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, Third RunAAABC4080120160200SE +/- 0.86, N = 15196.32198.98195.75192.34MIN: 9.16 / MAX: 30000MIN: 9.31 / MAX: 30000MIN: 9.41 / MAX: 20000MIN: 9.33 / MAX: 120001. ClickHouse server version 22.5.4.19 (official build).

memtier_benchmark

Protocol: Redis - Clients: 100 - Set To Get Ratio: 1:5

OpenBenchmarking.orgOps/sec, More Is Bettermemtier_benchmark 1.4Protocol: Redis - Clients: 100 - Set To Get Ratio: 1:5AABC500K1000K1500K2000K2500K2454493.052381286.412402414.311. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Dragonflydb

Clients: 50 - Set To Get Ratio: 5:1

OpenBenchmarking.orgOps/sec, More Is BetterDragonflydb 0.6Clients: 50 - Set To Get Ratio: 5:1AAABC800K1600K2400K3200K4000KSE +/- 4795.36, N = 33674898.753691129.843583380.173664149.371. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

ClickHouse

100M Rows Web Analytics Dataset, Second Run

OpenBenchmarking.orgQueries Per Minute, Geo Mean, More Is BetterClickHouse 22.5.4.19100M Rows Web Analytics Dataset, Second RunAAABC4080120160200SE +/- 1.55, N = 15194.70198.64198.48198.51MIN: 9.3 / MAX: 30000MIN: 9.36 / MAX: 20000MIN: 9.49 / MAX: 20000MIN: 9.45 / MAX: 300001. ClickHouse server version 22.5.4.19 (official build).

memtier_benchmark

Protocol: Redis - Clients: 50 - Set To Get Ratio: 1:10

OpenBenchmarking.orgOps/sec, More Is Bettermemtier_benchmark 1.4Protocol: Redis - Clients: 50 - Set To Get Ratio: 1:10AABC500K1000K1500K2000K2500K2480132.272504152.192469793.321. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Dragonflydb

Clients: 200 - Set To Get Ratio: 1:1

OpenBenchmarking.orgOps/sec, More Is BetterDragonflydb 0.6Clients: 200 - Set To Get Ratio: 1:1AAABC800K1600K2400K3200K4000KSE +/- 17999.80, N = 33692396.293672848.963687491.343722843.121. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Dragonflydb

Clients: 50 - Set To Get Ratio: 1:5

OpenBenchmarking.orgOps/sec, More Is BetterDragonflydb 0.6Clients: 50 - Set To Get Ratio: 1:5AAABC900K1800K2700K3600K4500KSE +/- 19130.93, N = 34046276.174029664.684069312.404076314.021. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Dragonflydb

Clients: 200 - Set To Get Ratio: 1:5

OpenBenchmarking.orgOps/sec, More Is BetterDragonflydb 0.6Clients: 200 - Set To Get Ratio: 1:5AAABC800K1600K2400K3200K4000KSE +/- 22009.02, N = 33916925.463898686.833929914.653934765.651. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Redis

Test: SET - Parallel Connections: 1000

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 1000AAABC600K1200K1800K2400K3000KSE +/- 20067.91, N = 32625813.082645331.002627028.502623587.251. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Dragonflydb

Clients: 200 - Set To Get Ratio: 5:1

OpenBenchmarking.orgOps/sec, More Is BetterDragonflydb 0.6Clients: 200 - Set To Get Ratio: 5:1AAABC800K1600K2400K3200K4000KSE +/- 9764.78, N = 33544444.903515962.973520664.133533311.181. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Dragonflydb

Clients: 50 - Set To Get Ratio: 1:1

OpenBenchmarking.orgOps/sec, More Is BetterDragonflydb 0.6Clients: 50 - Set To Get Ratio: 1:1AAABC800K1600K2400K3200K4000KSE +/- 8422.04, N = 33784770.293767115.143766456.383760554.451. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Redis

Test: LPUSH - Parallel Connections: 50

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: LPUSH - Parallel Connections: 50AAABC500K1000K1500K2000K2500KSE +/- 46604.91, N = 152177365.351908181.122391815.002149189.751. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Redis

Test: SET - Parallel Connections: 50

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 7.0.4Test: SET - Parallel Connections: 50AAABC600K1200K1800K2400K3000KSE +/- 72560.54, N = 132477250.402473088.002581491.002692563.001. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Phoronix Test Suite v10.8.5