dram-0611-mysql-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. under load 90: 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 under load 90 optane 1st: 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 + 32 GB + 32 GB + 32 GB + 32 GB + 129408 MB + 129408 MB + 32 GB + 32 GB + 32 GB + 32 GB + 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 under load 90 optane 2-2-2 1st: 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 no load: 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 undr load 98 optane: 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 + 32 GB + 32 GB + 32 GB + 32 GB + 129408 MB + 129408 MB + 32 GB + 32 GB + 32 GB + 32 GB + 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 under load 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 under load 90 .................. 11766 |====================================== under load 90 optane 1st ....... 11719 |====================================== under load 90 optane 2-2-2 1st . 11996 |======================================= no load ........................ 12097 |======================================= undr load 98 optane ............ 11539 |===================================== under load 90 optane 16g 1:1:1 . 11584 |===================================== MariaDB 10.5.2 Clients: 4 Queries Per Second > Higher Is Better under load 90 .................. 10034 |====================================== under load 90 optane 1st ....... 9805 |===================================== under load 90 optane 2-2-2 1st . 9869 |====================================== no load ........................ 10239 |======================================= undr load 98 optane ............ 9869 |====================================== under load 90 optane 16g 1:1:1 . 9901 |====================================== MariaDB 10.5.2 Clients: 8 Queries Per Second > Higher Is Better under load 90 .................. 8955 |======================================= under load 90 optane 1st ....... 9136 |======================================== under load 90 optane 2-2-2 1st . 8930 |======================================= no load ........................ 9092 |======================================== undr load 98 optane ............ 9175 |======================================== under load 90 optane 16g 1:1:1 . 9203 |======================================== MariaDB 10.5.2 Clients: 16 Queries Per Second > Higher Is Better under load 90 .................. 6727 |====================================== under load 90 optane 1st ....... 6698 |====================================== under load 90 optane 2-2-2 1st . 7077 |======================================== no load ........................ 6819 |======================================= undr load 98 optane ............ 6752 |====================================== under load 90 optane 16g 1:1:1 . 6638 |====================================== MariaDB 10.5.2 Clients: 32 Queries Per Second > Higher Is Better under load 90 .................. 2885 |======================================= under load 90 optane 1st ....... 2874 |======================================= under load 90 optane 2-2-2 1st . 2868 |======================================= no load ........................ 2941 |======================================== undr load 98 optane ............ 2885 |======================================= under load 90 optane 16g 1:1:1 . 2868 |======================================= MariaDB 10.5.2 Clients: 64 Queries Per Second > Higher Is Better under load 90 .................. 1272 |======================================= under load 90 optane 1st ....... 1262 |======================================= under load 90 optane 2-2-2 1st . 1271 |======================================= no load ........................ 1294 |======================================== undr load 98 optane ............ 1274 |======================================= under load 90 optane 16g 1:1:1 . 1265 |======================================= MariaDB 10.5.2 Clients: 128 Queries Per Second > Higher Is Better under load 90 .................. 550 |========================================= under load 90 optane 1st ....... 540 |======================================== under load 90 optane 2-2-2 1st . 540 |======================================== no load ........................ 556 |========================================= undr load 98 optane ............ 542 |======================================== under load 90 optane 16g 1:1:1 . 544 |======================================== MariaDB 10.5.2 Clients: 256 Queries Per Second > Higher Is Better under load 90 .................. 456 |========================================= under load 90 optane 1st ....... 449 |======================================== under load 90 optane 2-2-2 1st . 455 |======================================== no load ........................ 461 |========================================= undr load 98 optane ............ 454 |======================================== under load 90 optane 16g 1:1:1 . 454 |======================================== MariaDB 10.5.2 Clients: 512 Queries Per Second > Higher Is Better under load 90 .................. 456 |========================================= under load 90 optane 1st ....... 453 |======================================== under load 90 optane 2-2-2 1st . 450 |======================================== no load ........................ 461 |========================================= undr load 98 optane ............ 452 |======================================== under load 90 optane 16g 1:1:1 . 452 |========================================