MySQL User Test
Intel Optane benchmarks for a future article.


EXT4 Samsung 970 EVO 500GB: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: ext4, Screen Resolution: 3840x2160

EXT4 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: ext4, Screen Resolution: 3840x2160

XFS 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: xfs, Screen Resolution: 3840x2160

Btrfs 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: btrfs, Screen Resolution: 3840x2160

F2FS 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: f2fs, Screen Resolution: 3840x2160

EXT4 RAID0 Dual 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: ext4, Screen Resolution: 3840x2160

XFS RAID0 Dual 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: Samsung SSD 970 EVO 500GB + 2 x 280GB INTEL SSDPED1D280GA, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: xfs, Screen Resolution: 3840x2160

F2FS RAID0 Dual 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: f2fs, Screen Resolution: 3840x2160

EXT4 RAID1 Dual 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: ext4, Screen Resolution: 3840x2160

XFS RAID1 Dual 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: xfs, Screen Resolution: 3840x2160

F2FS RAID1 Dual 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: f2fs, Screen Resolution: 3840x2160

Btrfs RAID0 Dual 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: btrfs, Screen Resolution: 3840x2160

Btrfs RAID1 Dual 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: 2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GB, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: btrfs, Screen Resolution: 3840x2160

ZFS 900p: 

	Processor: AMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads), Motherboard: ASUS ROG ZENITH EXTREME (1701 BIOS), Chipset: AMD 17h, Memory: 32768MB, Disk: Samsung SSD 970 EVO 500GB + 2 x 280GB INTEL SSDPED1D280GA, Graphics: AMD Radeon RX 64 8GB (1590/800MHz), Audio: Realtek ALC1220, Monitor: ASUS VP28U, Network: Intel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11ad

	OS: Ubuntu 19.04, Kernel: 5.2.0-999-generic (x86_64) 20190605, Desktop: GNOME Shell 3.32.0, Display Server: X Server 1.20.4, Display Driver: amdgpu 19.0.1, OpenGL: 4.5 Mesa 19.0.2 (LLVM 8.0.0), Compiler: GCC 8.3.0, File-System: zfs, Screen Resolution: 3840x2160


MariaDB 10.3.8
Clients: 1
Queries Per Second > Higher Is Better
EXT4 Samsung 970 EVO 500GB . 304   |=
EXT4 900p .................. 12605 |=========================================
XFS 900p ................... 11195 |====================================
Btrfs 900p ................. 884   |===
F2FS 900p .................. 13276 |===========================================
EXT4 RAID0 Dual 900p ....... 11407 |=====================================
XFS RAID0 Dual 900p ........ 12017 |=======================================
F2FS RAID0 Dual 900p ....... 12553 |=========================================
EXT4 RAID1 Dual 900p ....... 11114 |====================================
XFS RAID1 Dual 900p ........ 10276 |=================================
F2FS RAID1 Dual 900p ....... 12450 |========================================
Btrfs RAID0 Dual 900p ...... 802   |===
Btrfs RAID1 Dual 900p ...... 878   |===
ZFS 900p ................... 5556  |==================


MariaDB 10.3.8
Clients: 16
Queries Per Second > Higher Is Better
EXT4 Samsung 970 EVO 500GB . 130  |=
EXT4 900p .................. 4992 |===========================================
XFS 900p ................... 5010 |===========================================
Btrfs 900p ................. 442  |====
F2FS 900p .................. 5164 |============================================
EXT4 RAID0 Dual 900p ....... 5034 |===========================================
XFS RAID0 Dual 900p ........ 4911 |==========================================
F2FS RAID0 Dual 900p ....... 5119 |============================================
EXT4 RAID1 Dual 900p ....... 4935 |==========================================
XFS RAID1 Dual 900p ........ 5068 |===========================================
F2FS RAID1 Dual 900p ....... 5042 |===========================================
Btrfs RAID0 Dual 900p ...... 264  |==
Btrfs RAID1 Dual 900p ...... 328  |===
ZFS 900p ................... 2849 |========================