本文介绍AnalyticDB MySQL、Presto、Spark的性能测试结果。

查询执行时间以秒(s)为单位。

测试样本 AnalyticDB MySQL Presto 执行时间增加倍数 Spark 执行时间增加倍数
tpch_sql1 24.1 36.28 0.505394191 62.97 1.612863071
tpch_sql2 1.3 12.25 8.423076923 36.03 26.71538462
tpch_sql3 7.1 19.8 1.788732394 39.12 4.509859155
tpch_sql4 13.7 13.21 -0.035766423 24.14 0.762043796
tpch_sql5 16.3 29.9 0.834355828 116.27 6.133128834
tpch_sql6 0.7 11.61 15.58571429 10.6 14.14285714
tpch_sql7 6.6 57.75 7.75 99.97 14.1469697
tpch_sql8 16.2 31.06 0.917283951 78.8 3.864197531
tpch_sql9 34 48.15 0.416176471 144.65 3.254411765
tpch_sql10 5.5 23.25 3.227272727 52.49 8.543636364
tpch_sql11 2.2 11.11 4.05 36.51 15.59545455
tpch_sql12 3.5 14.79 3.225714286 21.64 5.182857143
tpch_sql13 11.3 15.07 0.333628319 37.1 2.283185841
tpch_sql14 1.3 10.62 7.169230769 19.69 14.14615385
tpch_sql15 2.9 21.68 6.475862069 23.77 7.196551724
tpch_sql16 2.3 6.55 1.847826087 80.7 34.08695652
tpch_sql17 5.4 55.85 9.342592593 116.86 20.64074074
tpch_sql18 67.5 58.41 -0.134666667 89.67 0.328444444
tpch_sql19 3 19.92 5.64 21.89 6.296666667
tpch_sql20 9.4 22.13 1.354255319 37.59 2.99893617
tpch_sql21 22.5 88.81 2.947111111 68.42 2.040888889
tpch_sql22 4 6.4 0.6 25.05 5.2625
总时长(s) 260.8 614.6 1.356595092 1243.93 3.769670245
ADB测试结果