MySQL Threadripper

AMD Ryzen Threadripper 3970X 32-Core testing with a ASUS ROG ZENITH II EXTREME (0601 BIOS) and MSI AMD Radeon RX 470/480/570/570X/580/580X/590 8GB on Ubuntu 19.10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/1912047-HU-MYSQLTHRE28.

MySQL ThreadripperProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionAMD Ryzen Threadripper 3970X 32-Core - MSI AMD RadeonAMD Ryzen Threadripper 3970X 32-Core @ 3.70GHz (32 Cores / 64 Threads)ASUS ROG ZENITH II EXTREME (0601 BIOS)AMD Starship/Matisse64512MB3841GB Micron_9300_MTFDHAL3T8TDPMSI AMD Radeon RX 470/480/570/570X/580/580X/590 8GB (1366/2000MHz)AMD Ellesmere HDMI AudioASUS VP28UAquantia AQC107 NBase-T/IEEE + Intel I211 + Intel Device 2723Ubuntu 19.105.4.0-nvme-hwmon (x86_64)GNOME Shell 3.34.1X Server 1.20.5modesetting 1.20.54.5 Mesa 19.2.1 (LLVM 9.0.0)GCC 9.2.1 20191008ext43840x2160OpenBenchmarking.org- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --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-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 - Scaling Governor: acpi-cpufreq ondemand - CPU Microcode: 0x8301025- 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 + tsx_async_abort: Not affected

MySQL Threadrippermysqlslap: 32mysqlslap: 64mysqlslap: 128mysqlslap: 256AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon36501247486396OpenBenchmarking.org

MariaDB

Clients: 32

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 32AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon8001600240032004000SE +/- 13.27, N = 336501. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lbz2 -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 64

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 64AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon30060090012001500SE +/- 1.04, N = 312471. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lbz2 -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 128

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 128AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon110220330440550SE +/- 0.32, N = 34861. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lbz2 -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

MariaDB

Clients: 256

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 256AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon90180270360450SE +/- 0.32, N = 33961. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lbz2 -laio -lz -lm -lcrypt -lssl -lcrypto -ldl

Phoronix Test Suite v10.8.4