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&grt .
MySQL Threadripper Processor Motherboard Chipset Memory Disk Graphics Audio Monitor Network OS Kernel Desktop Display Server Display Driver OpenGL Compiler File-System Screen Resolution AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon AMD Ryzen Threadripper 3970X 32-Core @ 3.70GHz (32 Cores / 64 Threads) ASUS ROG ZENITH II EXTREME (0601 BIOS) AMD Starship/Matisse 64512MB 3841GB Micron_9300_MTFDHAL3T8TDP MSI AMD Radeon RX 470/480/570/570X/580/580X/590 8GB (1366/2000MHz) AMD Ellesmere HDMI Audio ASUS VP28U Aquantia AQC107 NBase-T/IEEE + Intel I211 + Intel Device 2723 Ubuntu 19.10 5.4.0-nvme-hwmon (x86_64) GNOME Shell 3.34.1 X Server 1.20.5 modesetting 1.20.5 4.5 Mesa 19.2.1 (LLVM 9.0.0) GCC 9.2.1 20191008 ext4 3840x2160 OpenBenchmarking.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 Threadripper mysqlslap: 32 mysqlslap: 64 mysqlslap: 128 mysqlslap: 256 AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon 3650 1247 486 396 OpenBenchmarking.org
MariaDB Clients: 32 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 32 AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon 800 1600 2400 3200 4000 SE +/- 13.27, N = 3 3650 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lbz2 -laio -lz -lm -lcrypt -lssl -lcrypto -ldl
MariaDB Clients: 64 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 64 AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon 300 600 900 1200 1500 SE +/- 1.04, N = 3 1247 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lbz2 -laio -lz -lm -lcrypt -lssl -lcrypto -ldl
MariaDB Clients: 128 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 128 AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon 110 220 330 440 550 SE +/- 0.32, N = 3 486 1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -lbz2 -laio -lz -lm -lcrypt -lssl -lcrypto -ldl
MariaDB Clients: 256 OpenBenchmarking.org Queries Per Second, More Is Better MariaDB 10.3.8 Clients: 256 AMD Ryzen Threadripper 3970X 32-Core - MSI AMD Radeon 90 180 270 360 450 SE +/- 0.32, N = 3 396 1. (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