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