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 |=========================================