IO EXT4 Patch

AMD Ryzen Threadripper 3960X 24-Core testing with a MSI Creator TRX40 (MS-7C59) v1.0 (1.12N1 BIOS) and Sapphire AMD Radeon RX 5500/5500M / Pro 5500M 4GB on Ubuntu 20.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2009125-FI-IOEXT4PAT07.

IO EXT4 PatchProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen Resolutionv5.8v5.9 Gitv5.9 Git + patchAMD Ryzen Threadripper 3960X 24-Core @ 3.80GHz (24 Cores / 48 Threads)MSI Creator TRX40 (MS-7C59) v1.0 (1.12N1 BIOS)AMD Starship/Matisse32GB1000GB Sabrent Rocket 4.0 1TBSapphire AMD Radeon RX 5500/5500M / Pro 5500M 4GB (1895/875MHz)AMD Navi 10 HDMI AudioASUS MG28UAquantia AQC107 NBase-T/IEEE + Intel I211 + Intel Wi-Fi 6 AX200Ubuntu 20.045.8.0-050800-generic (x86_64)GNOME Shell 3.36.4X Server 1.20.8modesetting 1.20.84.6 Mesa 20.0.8 (LLVM 10.0.0)GCC 9.3.0ext43840x2160Sapphire AMD Radeon RX 5500/5500M / Pro 5500M 4GB (1900/875MHz)5.9.0-050900rc4daily20200911-generic (x86_64) 202009105.9.0-rc4-ext4-patch (x86_64) 20200911OpenBenchmarking.orgCompiler Details- --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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none,hsa --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=auto --with-tune=generic --without-cuda-driver -v Processor Details- Scaling Governor: acpi-cpufreq ondemand - CPU Microcode: 0x8301025Security Details- itlb_multihit: Not affected + 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: conditional RSB filling + srbds: Not affected + tsx_async_abort: Not affected

IO EXT4 Patchmysqlslap: 1mysqlslap: 16mysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256pgbench: Buffer Test - Normal Load - Read Onlypgbench: Buffer Test - Normal Load - Read Writepgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Buffer Test - Heavy Contention - Read Writev5.8v5.9 Gitv5.9 Git + patch1548480445369300292642894.41941412089.613507647703.63691112155.5327271806535487395303291631611.32342611774.250976638088.73246512103.5439442947174017441316389295634814.93067112586.885877634934.32595912881.673909OpenBenchmarking.org

MariaDB

Clients: 1

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 1v5.8v5.9 Gitv5.9 Git + patch6001200180024003000SE +/- 95.33, N = 12SE +/- 161.92, N = 12SE +/- 2.89, N = 31548180629471. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lbz2 -laio -lnuma -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 16

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 16v5.8v5.9 Gitv5.9 Git + patch400800120016002000SE +/- 10.65, N = 9SE +/- 32.02, N = 9SE +/- 16.99, N = 348053517401. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lbz2 -laio -lnuma -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 32v5.8v5.9 Gitv5.9 Git + patch400800120016002000SE +/- 11.52, N = 6SE +/- 20.86, N = 9SE +/- 3.66, N = 344548717441. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lbz2 -laio -lnuma -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 64v5.8v5.9 Gitv5.9 Git + patch30060090012001500SE +/- 4.47, N = 9SE +/- 9.06, N = 9SE +/- 4.71, N = 336939513161. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lbz2 -laio -lnuma -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 128v5.8v5.9 Gitv5.9 Git + patch80160240320400SE +/- 2.89, N = 3SE +/- 3.60, N = 3SE +/- 53.69, N = 93003033891. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lbz2 -laio -lnuma -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 256

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 256v5.8v5.9 Gitv5.9 Git + patch60120180240300SE +/- 0.42, N = 3SE +/- 1.69, N = 3SE +/- 3.17, N = 32922912951. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lbz2 -laio -lnuma -lcrypt -lz -lm -lssl -lcrypto -ldl

PostgreSQL pgbench

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

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlyv5.8v5.9 Gitv5.9 Git + patch140K280K420K560K700KSE +/- 2460.68, N = 3SE +/- 2231.15, N = 3SE +/- 1179.80, N = 3642894.42631611.32634814.931. (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 12.0Scaling: Buffer Test - Test: Normal Load - Mode: Read Writev5.8v5.9 Gitv5.9 Git + patch3K6K9K12K15KSE +/- 217.38, N = 15SE +/- 196.30, N = 15SE +/- 233.56, N = 1512089.6111774.2512586.891. (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 12.0Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Onlyv5.8v5.9 Gitv5.9 Git + patch140K280K420K560K700KSE +/- 1995.85, N = 3SE +/- 1320.17, N = 3SE +/- 1719.62, N = 3647703.64638088.73634934.331. (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 12.0Scaling: Buffer Test - Test: Heavy Contention - Mode: Read Writev5.8v5.9 Gitv5.9 Git + patch3K6K9K12K15KSE +/- 233.01, N = 15SE +/- 462.97, N = 15SE +/- 263.42, N = 1512155.5312103.5412881.671. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

Phoronix Test Suite v10.8.4