MySQL User Test

Intel Optane benchmarks for a future article.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 1906196-HV-MYSQLUSER58
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Hide
Result
Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
EXT4 Samsung 970 EVO 500GB
June 06 2019
  2 Hours, 4 Minutes
EXT4 900p
June 13 2019
  4 Minutes
XFS 900p
June 13 2019
  4 Minutes
Btrfs 900p
June 14 2019
  1 Hour, 54 Minutes
F2FS 900p
June 14 2019
  3 Minutes
EXT4 RAID0 Dual 900p
June 14 2019
  4 Minutes
XFS RAID0 Dual 900p
June 15 2019
  4 Minutes
F2FS RAID0 Dual 900p
June 15 2019
  5 Minutes
EXT4 RAID1 Dual 900p
June 16 2019
  4 Minutes
XFS RAID1 Dual 900p
June 16 2019
  4 Minutes
F2FS RAID1 Dual 900p
June 16 2019
  4 Minutes
Btrfs RAID0 Dual 900p
June 17 2019
  2 Hours, 54 Minutes
Btrfs RAID1 Dual 900p
June 18 2019
  2 Hours, 16 Minutes
ZFS 900p
June 18 2019
  7 Minutes
Invert Hiding All Results Option
  42 Minutes

Only show results where is faster than
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


MySQL User TestProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionEXT4 Samsung 970 EVO 500GBEXT4 900pXFS 900pBtrfs 900pF2FS 900pEXT4 RAID0 Dual 900pXFS RAID0 Dual 900pF2FS RAID0 Dual 900pEXT4 RAID1 Dual 900pXFS RAID1 Dual 900pF2FS RAID1 Dual 900pBtrfs RAID0 Dual 900pBtrfs RAID1 Dual 900pZFS 900pAMD Ryzen Threadripper 2990WX 32-Core @ 3.00GHz (32 Cores / 64 Threads)ASUS ROG ZENITH EXTREME (1701 BIOS)AMD 17h32768MBSamsung SSD 970 EVO 500GBAMD Radeon RX 64 8GB (1590/800MHz)Realtek ALC1220ASUS VP28UIntel I211 + Qualcomm Atheros QCA6174 802.11ac + Wilocity Wil6200 802.11adUbuntu 19.045.2.0-999-generic (x86_64) 20190605GNOME Shell 3.32.0X Server 1.20.4amdgpu 19.0.14.5 Mesa 19.0.2 (LLVM 8.0.0)GCC 8.3.0ext43840x2160280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GBxfsbtrfsf2fs2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GBext4Samsung SSD 970 EVO 500GB + 2 x 280GB INTEL SSDPED1D280GAxfs2 x 280GB INTEL SSDPED1D280GA + Samsung SSD 970 EVO 500GBf2fsext4xfsf2fsbtrfsSamsung SSD 970 EVO 500GB + 2 x 280GB INTEL SSDPED1D280GAzfsOpenBenchmarking.orgCompiler Details- --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++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none --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 --with-tune=generic --without-cuda-driver -vProcessor Details- Scaling Governor: acpi-cpufreq ondemandSecurity Details- l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Mitigation of Full AMD retpoline IBPB: conditional STIBP: disabled RSB filling

MariaDB

This is a MariaDB MySQL database server benchmark making use of mysqlslap. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 1EXT4 Samsung 970 EVO 500GBEXT4 900pXFS 900pBtrfs 900pF2FS 900pEXT4 RAID0 Dual 900pXFS RAID0 Dual 900pF2FS RAID0 Dual 900pEXT4 RAID1 Dual 900pXFS RAID1 Dual 900pF2FS RAID1 Dual 900pBtrfs RAID0 Dual 900pBtrfs RAID1 Dual 900pZFS 900p3K6K9K12K15KSE +/- 3.89, N = 3SE +/- 52.74, N = 3SE +/- 84.18, N = 3SE +/- 95.97, N = 9SE +/- 118.54, N = 3SE +/- 43.54, N = 3SE +/- 147.58, N = 4SE +/- 52.74, N = 3SE +/- 122.13, N = 3SE +/- 92.66, N = 3SE +/- 104.18, N = 3SE +/- 79.78, N = 9SE +/- 107.12, N = 6SE +/- 17.82, N = 33041260511195884132761140712017125531111410276124508028785556-lnuma-lnuma-lnuma-lnuma-lnuma-lnuma-lnuma1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lpcre -lcrypt -lssl -lcrypto -ldl
OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 1EXT4 Samsung 970 EVO 500GBEXT4 900pXFS 900pBtrfs 900pF2FS 900pEXT4 RAID0 Dual 900pXFS RAID0 Dual 900pF2FS RAID0 Dual 900pEXT4 RAID1 Dual 900pXFS RAID1 Dual 900pF2FS RAID1 Dual 900pBtrfs RAID0 Dual 900pBtrfs RAID1 Dual 900pZFS 900p2K4K6K8K10KMin: 296.03 / Avg: 303.62 / Max: 308.93Min: 12500 / Avg: 12605.49 / Max: 12658.23Min: 11111.11 / Avg: 11195.29 / Max: 11363.64Min: 606.8 / Avg: 884.01 / Max: 1394.7Min: 13157.89 / Avg: 13276.43 / Max: 13513.51Min: 11363.64 / Avg: 11407.18 / Max: 11494.25Min: 11627.91 / Avg: 12017.49 / Max: 12345.68Min: 12500 / Avg: 12552.74 / Max: 12658.23Min: 10869.57 / Avg: 11113.83 / Max: 11235.96Min: 10101.01 / Avg: 10275.65 / Max: 10416.67Min: 12345.68 / Avg: 12449.86 / Max: 12658.23Min: 576.37 / Avg: 801.87 / Max: 1122.33Min: 618.81 / Avg: 878.4 / Max: 1175.09Min: 5524.86 / Avg: 5555.67 / Max: 5586.591. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lpcre -lcrypt -lssl -lcrypto -ldl

OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 16EXT4 Samsung 970 EVO 500GBEXT4 900pXFS 900pBtrfs 900pF2FS 900pEXT4 RAID0 Dual 900pXFS RAID0 Dual 900pF2FS RAID0 Dual 900pEXT4 RAID1 Dual 900pXFS RAID1 Dual 900pF2FS RAID1 Dual 900pBtrfs RAID0 Dual 900pBtrfs RAID1 Dual 900pZFS 900p11002200330044005500SE +/- 0.80, N = 3SE +/- 30.08, N = 3SE +/- 58.27, N = 3SE +/- 12.33, N = 8SE +/- 8.90, N = 3SE +/- 36.91, N = 3SE +/- 42.33, N = 3SE +/- 8.72, N = 3SE +/- 35.47, N = 3SE +/- 22.59, N = 3SE +/- 8.46, N = 3SE +/- 6.81, N = 9SE +/- 5.01, N = 9SE +/- 12.44, N = 31304992501044251645034491151194935506850422643282849-lnuma-lnuma-lnuma-lnuma-lnuma-lnuma-lnuma1. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lpcre -lcrypt -lssl -lcrypto -ldl
OpenBenchmarking.orgQueries Per Second, More Is BetterMariaDB 10.3.8Clients: 16EXT4 Samsung 970 EVO 500GBEXT4 900pXFS 900pBtrfs 900pF2FS 900pEXT4 RAID0 Dual 900pXFS RAID0 Dual 900pF2FS RAID0 Dual 900pEXT4 RAID1 Dual 900pXFS RAID1 Dual 900pF2FS RAID1 Dual 900pBtrfs RAID0 Dual 900pBtrfs RAID1 Dual 900pZFS 900p9001800270036004500Min: 128.87 / Avg: 130.25 / Max: 131.65Min: 4950.5 / Avg: 4992.04 / Max: 5050.51Min: 4901.96 / Avg: 5009.71 / Max: 5102.04Min: 386.25 / Avg: 442.06 / Max: 506.33Min: 5154.64 / Avg: 5163.54 / Max: 5181.35Min: 4975.12 / Avg: 5034.1 / Max: 5102.04Min: 4830.92 / Avg: 4910.72 / Max: 4975.12Min: 5102.04 / Avg: 5119.48 / Max: 5128.21Min: 4878.05 / Avg: 4934.72 / Max: 5000Min: 5025.13 / Avg: 5067.77 / Max: 5102.04Min: 5025.13 / Avg: 5042.05 / Max: 5050.51Min: 242.78 / Avg: 263.94 / Max: 313.38Min: 293 / Avg: 327.73 / Max: 340.6Min: 2832.86 / Avg: 2849.11 / Max: 2873.561. (CXX) g++ options: -pie -fPIC -fstack-protector -fno-rtti -O2 -lpthread -laio -lz -lm -lpcre -lcrypt -lssl -lcrypto -ldl