mysqlslap vs

2 x Intel Xeon Gold 5220R testing with a HPE ProLiant DL360 Gen10 (U32 BIOS) and Matrox MGA G200eH3 on Ubuntu 18.04 via the Phoronix Test Suite.

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2106162-IB-2106162IB23

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

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):

mysqlslap vs 2 x Intel Xeon Gold 5220R testing with a HPE ProLiant DL360 Gen10 (U32 BIOS) and Matrox MGA G200eH3 on Ubuntu 18.04 via the Phoronix Test Suite. noload optane 16g 1:1:1: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 129408 MB + 16384 MB + 16384 MB + 16384 MB + 16384 MB + 129408 MB + 129408 MB + 16384 MB + 16384 MB + 16384 MB + 16384 MB + 129408 MB DDR4-2666MT/s, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 noload dram 512g: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 16 x 32 GB DDR4-2666MT/s HPE, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 noload optane 1.5tb 2:2:2: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB DDR4-2666MT/s, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 90 load optane 16g 1:1:1: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 129408 MB + 16384 MB + 16384 MB + 16384 MB + 16384 MB + 129408 MB + 129408 MB + 16384 MB + 16384 MB + 16384 MB + 16384 MB + 129408 MB DDR4-2666MT/s, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 load over 90 optane 16g 1:1:1: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 129408 MB + 16384 MB + 16384 MB + 16384 MB + 16384 MB + 129408 MB + 129408 MB + 16384 MB + 16384 MB + 16384 MB + 16384 MB + 129408 MB DDR4-2666MT/s, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 load over 90 dram 512g: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 16 x 32 GB DDR4-2666MT/s HPE, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 load over 90 dram 512g retry: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 16 x 32 GB DDR4-2666MT/s HPE, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 load over 90 dram 512g retry 2: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 16 x 32 GB DDR4-2666MT/s HPE, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 load over 90 optane 32g 2:2:2: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB DDR4-2666MT/s, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 load over 90 optane 32g 2:2:2 retry: Processor: 2 x Intel Xeon Gold 5220R (48 Cores / 96 Threads), Motherboard: HPE ProLiant DL360 Gen10 (U32 BIOS), Chipset: Intel Sky Lake-E DMI3 Registers, Memory: 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 129408 MB + 32 GB + 129408 MB + 32 GB + 129408 MB + 32 GB DDR4-2666MT/s, Disk: 3201GB MO003200KWVUV, Graphics: Matrox MGA G200eH3, Network: 2 x Intel 10G X550T OS: Ubuntu 18.04, Kernel: 4.15.0-140-generic (x86_64), Compiler: GCC 7.5.0, File-System: ext4, Screen Resolution: 1024x768 MariaDB 10.5.2 Clients: 1 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 11953 |====================================== noload dram 512g ............... 12097 |======================================= noload optane 1.5tb 2:2:2 ...... 11771 |====================================== 90 load optane 16g 1:1:1 ....... 11719 |====================================== load over 90 optane 16g 1:1:1 .. 11908 |====================================== load over 90 dram 512g ......... 12146 |======================================= load over 90 dram 512g retry 2 . 12000 |======================================= load over 90 optane 32g 2:2:2 .. 12005 |======================================= MariaDB 10.5.2 Clients: 4 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 10136 |======================================= noload dram 512g ............... 10170 |======================================= noload optane 1.5tb 2:2:2 ...... 10205 |======================================= 90 load optane 16g 1:1:1 ....... 9679 |===================================== load over 90 optane 16g 1:1:1 .. 9805 |===================================== load over 90 dram 512g ......... 10239 |======================================= load over 90 dram 512g retry 2 . 9904 |====================================== load over 90 optane 32g 2:2:2 .. 9869 |====================================== MariaDB 10.5.2 Clients: 8 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 9148 |======================================== noload dram 512g ............... 9065 |======================================== noload optane 1.5tb 2:2:2 ...... 9148 |======================================== 90 load optane 16g 1:1:1 ....... 9147 |======================================== load over 90 optane 16g 1:1:1 .. 9010 |======================================= load over 90 dram 512g ......... 9037 |======================================== load over 90 dram 512g retry 2 . 9012 |======================================= load over 90 optane 32g 2:2:2 .. 8956 |======================================= MariaDB 10.5.2 Clients: 16 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 6789 |======================================== noload dram 512g ............... 6782 |======================================== noload optane 1.5tb 2:2:2 ...... 6550 |======================================= 90 load optane 16g 1:1:1 ....... 6452 |====================================== load over 90 optane 16g 1:1:1 .. 6467 |====================================== load over 90 dram 512g ......... 6805 |======================================== load over 90 dram 512g retry 2 . 6727 |======================================== load over 90 optane 32g 2:2:2 .. 6775 |======================================== MariaDB 10.5.2 Clients: 32 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 2927 |======================================== noload dram 512g ............... 2924 |======================================== noload optane 1.5tb 2:2:2 ...... 2874 |======================================= 90 load optane 16g 1:1:1 ....... 2924 |======================================== load over 90 optane 16g 1:1:1 .. 2882 |======================================= load over 90 dram 512g ......... 2938 |======================================== load over 90 dram 512g retry 2 . 2956 |======================================== load over 90 optane 32g 2:2:2 .. 2927 |======================================== MariaDB 10.5.2 Clients: 64 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 1288 |======================================== noload dram 512g ............... 1296 |======================================== noload optane 1.5tb 2:2:2 ...... 1267 |======================================= 90 load optane 16g 1:1:1 ....... 1263 |======================================= load over 90 optane 16g 1:1:1 .. 1260 |======================================= load over 90 dram 512g ......... 1284 |======================================== load over 90 dram 512g retry 2 . 1290 |======================================== load over 90 optane 32g 2:2:2 .. 1269 |======================================= MariaDB 10.5.2 Clients: 128 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 551 |========================================= noload dram 512g ............... 553 |========================================= noload optane 1.5tb 2:2:2 ...... 545 |======================================== 90 load optane 16g 1:1:1 ....... 543 |======================================== load over 90 optane 16g 1:1:1 .. 544 |======================================== load over 90 dram 512g retry 2 . 549 |========================================= load over 90 optane 32g 2:2:2 .. 543 |======================================== MariaDB 10.5.2 Clients: 256 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 460 |========================================= noload dram 512g ............... 462 |========================================= noload optane 1.5tb 2:2:2 ...... 457 |========================================= 90 load optane 16g 1:1:1 ....... 453 |======================================== load over 90 optane 16g 1:1:1 .. 453 |======================================== load over 90 dram 512g retry 2 . 458 |========================================= MariaDB 10.5.2 Clients: 512 Queries Per Second > Higher Is Better noload optane 16g 1:1:1 ........ 459 |========================================= noload dram 512g ............... 459 |========================================= noload optane 1.5tb 2:2:2 ...... 456 |========================================= 90 load optane 16g 1:1:1 ....... 453 |======================================== load over 90 optane 16g 1:1:1 .. 451 |======================================== load over 90 dram 512g retry 2 . 458 |=========================================