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&grs&sor.

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 Patchpgbench: Buffer Test - Heavy Contention - Read Onlypgbench: Buffer Test - Normal Load - Read Onlymysqlslap: 256pgbench: Buffer Test - Heavy Contention - Read Writepgbench: Buffer Test - Normal Load - Read Writemysqlslap: 128mysqlslap: 64mysqlslap: 32mysqlslap: 16mysqlslap: 1v5.8v5.9 Gitv5.9 Git + patch647703.636911642894.41941429212155.53272712089.6135073003694454801548638088.732465631611.32342629112103.54394411774.2509763033954875351806634934.325959634814.93067129512881.67390912586.8858773891316174417402947OpenBenchmarking.org

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: Normal Load - Mode: Read Only

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 12.0Scaling: Buffer Test - Test: Normal Load - Mode: Read Onlyv5.8v5.9 Git + patchv5.9 Git140K280K420K560K700KSE +/- 2460.68, N = 3SE +/- 1179.80, N = 3SE +/- 2231.15, N = 3642894.42634814.93631611.321. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

MariaDB

Clients: 256

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

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.9 Git + patchv5.8v5.9 Git3K6K9K12K15KSE +/- 263.42, N = 15SE +/- 233.01, N = 15SE +/- 462.97, N = 1512881.6712155.5312103.541. (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.9 Git + patchv5.8v5.9 Git3K6K9K12K15KSE +/- 233.56, N = 15SE +/- 217.38, N = 15SE +/- 196.30, N = 1512586.8912089.6111774.251. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpq -lpthread -lrt -lcrypt -ldl -lm

MariaDB

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.5.2Clients: 128v5.9 Git + patchv5.9 Gitv5.880160240320400SE +/- 53.69, N = 9SE +/- 3.60, N = 3SE +/- 2.89, N = 33893033001. (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.9 Git + patchv5.9 Gitv5.830060090012001500SE +/- 4.71, N = 3SE +/- 9.06, N = 9SE +/- 4.47, N = 913163953691. (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.9 Git + patchv5.9 Gitv5.8400800120016002000SE +/- 3.66, N = 3SE +/- 20.86, N = 9SE +/- 11.52, N = 617444874451. (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.9 Git + patchv5.9 Gitv5.8400800120016002000SE +/- 16.99, N = 3SE +/- 32.02, N = 9SE +/- 10.65, N = 917405354801. (CXX) g++ options: -pie -fPIC -fstack-protector -O2 -lpthread -lbz2 -laio -lnuma -lcrypt -lz -lm -lssl -lcrypto -ldl

MariaDB

Clients: 1

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

Phoronix Test Suite v10.8.4