Dell PowerEdge R6415 IO Tests

AMD EPYC 7451 24-Core testing with a Dell 07YXFK (1.9.2 BIOS) and llvmpipe 252GB on Ubuntu 18.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/1908222-HV-DELLPOWER67.

Dell PowerEdge R6415 IO TestsProcessorMotherboardChipsetMemoryDiskGraphicsMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionPERC H730P MiniAMD EPYC 7451 24-Core (24 Cores / 48 Threads)Dell 07YXFK (1.9.2 BIOS)AMD 17h258048MB7677GB PERC H730P Mini + 32GB IDSDM + 8GB USB 2.0 FDllvmpipe 252GBHP L2208w2 x Broadcom NetXtreme BCM5720 PCIeUbuntu 18.045.0.0-25-generic (x86_64)KDE Plasma 5.12.8X Server 1.20.4modesetting 1.20.43.3 Mesa 19.0.2 (LLVM 8.0 128 bits)GCC 7.4.0ext41680x1050OpenBenchmarking.org- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --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-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib --with-tune=generic --without-cuda-driver -v - MQ-DEADLINE / errors=remount-ro,relatime,rw- l1tf: Not affected + mds: Not affected + meltdown: 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 Full AMD retpoline IBPB: conditional STIBP: disabled RSB filling

Dell PowerEdge R6415 IO Testssqlite: Timed SQLite Insertionsmysqlslap: 1mysqlslap: 4mysqlslap: 8mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256pgbench: On-Disk - Normal Load - Read Onlypgbench: On-Disk - Normal Load - Read Writepgbench: On-Disk - Single Thread - Read Onlypgbench: Mostly RAM - Normal Load - Read Onlypgbench: On-Disk - Single Thread - Read Writepgbench: Buffer Test - Normal Load - Read Onlypgbench: Mostly RAM - Normal Load - Read Writepgbench: Buffer Test - Normal Load - Read Writepgbench: Mostly RAM - Single Thread - Read Onlypgbench: On-Disk - Heavy Contention - Read Onlypgbench: Buffer Test - Single Thread - Read Onlypgbench: Mostly RAM - Single Thread - Read Writepgbench: On-Disk - Heavy Contention - Read Writepgbench: Buffer Test - Single Thread - Read Writepgbench: Mostly RAM - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Mostly RAM - Heavy Contention - Read Writepgbench: Buffer Test - Heavy Contention - Read WritePERC H730P Mini3.069494696259883938175171729523495989.3414039.842086.26149219.93922.20319470.9818983.2229519.133462.6694474.1812429.021194.1515387.121783.52147234.56323224.0419354.8327687.82OpenBenchmarking.org

SQLite

Timed SQLite Insertions

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.22Timed SQLite InsertionsPERC H730P Mini0.68851.3772.06552.7543.4425SE +/- 0.01, N = 33.061. (CC) gcc options: -O2 -lz -ldl -lpthread

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 1PERC H730P Mini2K4K6K8K10KSE +/- 60.47, N = 394941. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 4

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 4PERC H730P Mini15003000450060007500SE +/- 70.66, N = 369621. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 8

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 8PERC H730P Mini13002600390052006500SE +/- 20.70, N = 359881. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 16

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 16PERC H730P Mini8001600240032004000SE +/- 40.79, N = 339381. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 32PERC H730P Mini400800120016002000SE +/- 4.70, N = 317511. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 64PERC H730P Mini150300450600750SE +/- 0.95, N = 37171. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 128PERC H730P Mini60120180240300SE +/- 0.50, N = 32951. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 256

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 256PERC H730P Mini50100150200250SE +/- 0.59, N = 32341. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read OnlyPERC H730P Mini20K40K60K80K100KSE +/- 200.37, N = 395989.341. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Normal Load - Mode: Read WritePERC H730P Mini3K6K9K12K15KSE +/- 651.93, N = 314039.841. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Single Thread - Mode: Read OnlyPERC H730P Mini400800120016002000SE +/- 26.42, N = 32086.261. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read OnlyPERC H730P Mini30K60K90K120K150KSE +/- 1508.79, N = 3149219.931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Single Thread - Mode: Read WritePERC H730P Mini2004006008001000SE +/- 7.73, N = 3922.201. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read OnlyPERC H730P Mini70K140K210K280K350KSE +/- 485.30, N = 3319470.981. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Normal Load - Mode: Read WritePERC H730P Mini4K8K12K16K20KSE +/- 534.98, N = 318983.221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Normal Load - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Normal Load - Mode: Read WritePERC H730P Mini6K12K18K24K30KSE +/- 14.66, N = 329519.131. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read OnlyPERC H730P Mini7001400210028003500SE +/- 23.58, N = 33462.661. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read OnlyPERC H730P Mini20K40K60K80K100KSE +/- 133.91, N = 394474.181. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read OnlyPERC H730P Mini3K6K9K12K15KSE +/- 152.37, N = 312429.021. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Single Thread - Mode: Read WritePERC H730P Mini30060090012001500SE +/- 2.25, N = 31194.151. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: On-Disk - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: On-Disk - Test: Heavy Contention - Mode: Read WritePERC H730P Mini3K6K9K12K15KSE +/- 223.91, N = 315387.121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Single Thread - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Single Thread - Mode: Read WritePERC H730P Mini400800120016002000SE +/- 6.37, N = 31783.521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read OnlyPERC H730P Mini30K60K90K120K150KSE +/- 1349.10, N = 3147234.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read OnlyPERC H730P Mini70K140K210K280K350KSE +/- 1486.44, N = 3323224.041. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Mostly RAM - Test: Heavy Contention - Mode: Read WritePERC H730P Mini4K8K12K16K20KSE +/- 103.07, N = 319354.831. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

PostgreSQL pgbench

Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Write

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 10.3Scaling: Buffer Test - Test: Heavy Contention - Mode: Read WritePERC H730P Mini6K12K18K24K30KSE +/- 111.42, N = 327687.821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4