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
mysqlslap vs,
"MariaDB 10.5.2 - Clients: 4",
Higher Results Are Better
"noload optane 16g 1:1:1",10204.081632653,10204.081632653,10000
"noload dram 512g",10204.081632653,10101.01010101,10204.081632653
"noload optane 1.5tb 2:2:2",10309.278350516,10204.081632653,10101.01010101
"90 load optane 16g 1:1:1",9803.9215686275,9523.8095238095,9708.7378640777
"load over 90 optane 16g 1:1:1",9803.9215686275,9708.7378640777,9900.9900990099
"load over 90 dram 512g",10204.081632653,10204.081632653,10309.278350516
"load over 90 dram 512g retry 2",10101.01010101,9900.9900990099,9708.7378640777
"load over 90 optane 32g 2:2:2",9900.9900990099,9900.9900990099,9803.9215686275
"MariaDB 10.5.2 - Clients: 16",
Higher Results Are Better
"noload optane 16g 1:1:1",6802.7210884354,6666.6666666667,6896.5517241379
"noload dram 512g",6578.9473684211,6849.3150684932,6944.4444444445,6756.7567567568
"noload optane 1.5tb 2:2:2",6493.5064935065,6578.9473684211,6578.9473684211
"90 load optane 16g 1:1:1",6451.6129032258,6369.4267515924,6535.9477124183
"load over 90 optane 16g 1:1:1",6410.2564102564,6369.4267515924,6622.5165562914
"load over 90 dram 512g",6756.7567567568,6666.6666666667,6993.006993007
"load over 90 dram 512g retry 2",6756.7567567568,6756.7567567568,6666.6666666667
"load over 90 optane 32g 2:2:2",6944.4444444445,6622.5165562914,6756.7567567568
"MariaDB 10.5.2 - Clients: 1",
Higher Results Are Better
"noload optane 16g 1:1:1",12048.192771084,11904.761904762,11904.761904762
"noload dram 512g",12048.192771084,12195.12195122,12048.192771084
"noload optane 1.5tb 2:2:2",11904.761904762,11627.906976744,11235.95505618,12048.192771084,11627.906976744,12195.12195122,11627.906976744,11764.705882353,11904.761904762
"90 load optane 16g 1:1:1",11764.705882353,11627.906976744,11764.705882353
"load over 90 optane 16g 1:1:1",11627.906976744,12048.192771084,12048.192771084
"load over 90 dram 512g",12048.192771084,12195.12195122,12195.12195122
"load over 90 dram 512g retry 2",12048.192771084,11904.761904762,12048.192771084
"load over 90 optane 32g 2:2:2",11494.252873563,12195.12195122,11904.761904762,12195.12195122,12195.12195122,12048.192771084
"MariaDB 10.5.2 - Clients: 64",
Higher Results Are Better
"noload optane 16g 1:1:1",1285.3470437018,1288.6597938144,1288.6597938144
"noload dram 512g",1293.6610608021,1295.3367875648,1298.7012987013
"noload optane 1.5tb 2:2:2",1265.8227848101,1269.0355329949,1267.4271229404
"90 load optane 16g 1:1:1",1261.0340479193,1264.2225031606,1262.6262626263
"load over 90 optane 16g 1:1:1",1259.4458438287,1267.4271229404,1253.1328320802
"load over 90 dram 512g",1282.0512820513,1291.9896640827,1278.7723785166
"load over 90 dram 512g retry 2",1287.0012870013,1291.9896640827,1290.3225806452
"load over 90 optane 32g 2:2:2",1267.4271229404,1265.8227848101,1272.2646310433
"MariaDB 10.5.2 - Clients: 32",
Higher Results Are Better
"noload optane 16g 1:1:1",2898.5507246377,2941.1764705882,2941.1764705882
"noload dram 512g",2941.1764705882,2932.5513196481,2898.5507246377
"noload optane 1.5tb 2:2:2",2865.329512894,2857.1428571429,2898.5507246377
"90 load optane 16g 1:1:1",2941.1764705882,2923.9766081871,2906.976744186
"load over 90 optane 16g 1:1:1",2873.5632183908,2881.8443804035,2890.1734104046
"load over 90 dram 512g",2932.5513196481,2932.5513196481,2949.8525073746
"load over 90 dram 512g retry 2",2949.8525073746,2967.3590504451,2949.8525073746
"load over 90 optane 32g 2:2:2",2941.1764705882,2941.1764705882,2898.5507246377
"MariaDB 10.5.2 - Clients: 8",
Higher Results Are Better
"noload optane 16g 1:1:1",9009.009009009,9259.2592592593,9174.3119266055
"noload dram 512g",9174.3119266055,8928.5714285714,9090.9090909091
"noload optane 1.5tb 2:2:2",9259.2592592593,9174.3119266055,9009.009009009
"90 load optane 16g 1:1:1",9090.9090909091,9259.2592592593,9090.9090909091
"load over 90 optane 16g 1:1:1",8928.5714285714,8928.5714285714,9174.3119266055
"load over 90 dram 512g",8928.5714285714,9009.009009009,9174.3119266055
"load over 90 dram 512g retry 2",9259.2592592593,8928.5714285714,8849.5575221239
"load over 90 optane 32g 2:2:2",9090.9090909091,8928.5714285714,8849.5575221239
"MariaDB 10.5.2 - Clients: 256",
Higher Results Are Better
"noload optane 16g 1:1:1",458.92611289582,460.1932811781,461.46746654361
"noload dram 512g",460.1932811781,462.96296296296,462.53469010176
"noload optane 1.5tb 2:2:2",457.03839122486,457.03839122486,457.24737082762
"90 load optane 16g 1:1:1",451.46726862303,454.13260672116,452.28403437359
"load over 90 optane 16g 1:1:1",453.30915684497,453.30915684497,451.46726862303
"load over 90 dram 512g retry 2",456.62100456621,459.98160073597,457.45654162855
"MariaDB 10.5.2 - Clients: 128",
Higher Results Are Better
"noload optane 16g 1:1:1",549.45054945055,552.4861878453,552.18111540585
"noload dram 512g",550.35773252614,553.70985603544,553.70985603544
"noload optane 1.5tb 2:2:2",542.888165038,545.5537370431,546.44808743169
"90 load optane 16g 1:1:1",543.77379010332,542.888165038,542.0054200542
"load over 90 optane 16g 1:1:1",544.36581382689,545.5537370431,541.71180931744
"load over 90 dram 512g retry 2",548.54635216676,549.14881933004,549.7526113249
"load over 90 optane 32g 2:2:2",540.83288263926,542.888165038,544.06964091404
"MariaDB 10.5.2 - Clients: 512",
Higher Results Are Better
"noload optane 16g 1:1:1",457.24737082762,459.77011494253,458.92611289582
"noload dram 512g",457.24737082762,459.55882352941,461.68051708218
"noload optane 1.5tb 2:2:2",454.13260672116,456.20437956204,456.20437956204
"90 load optane 16g 1:1:1",451.6711833785,454.54545454546,453.72050816697
"load over 90 optane 16g 1:1:1",448.83303411131,450.65344749887,453.30915684497
"load over 90 dram 512g retry 2",457.24737082762,458.29514207149,459.55882352941