The following table describes information about the environments used for this performance test.

Note You need to apply for the basic test environments from Alibaba Cloud.
Service Instance type Architecture vCPUs Memory Storage Version
AnalyticDB for MySQL analyticdb.c8.xlarge.n1 Two C8 groups (three nodes per group) 48 (8 vCPUs per node) 384 GB (64 GB per node) 400 GB per standard SSD AnalyticDB for MySQL V3.0
MySQL mysql.x8.13large.2c One node 52 384 GB 400 GB per standard SSD MySQL 8.0
Presto
  • Master nodes: ecs.g6.6xlarge
  • Worker nodes: ecs.se1ne.2xlarge
  • One master node
  • Six worker nodes
  • Master nodes: 24
  • Worker nodes: 48 (8 vCPUs per node)
  • Master nodes: 96 GB
  • Worker nodes: 384 GB (64 GB per node)
  • Master nodes: 120 GB per standard SSD
  • Worker nodes: four SSDs of 80 GB each
  • HDFS: 2.8.5
  • YARN: 2.8.5
  • Presto: 0.228
Apache Spark
  • Master nodes: ecs.g5.6xlarge
  • Worker nodes: ecs.se1ne.2xlarge
  • One master node
  • Six worker nodes
  • Master nodes: 24
  • Worker nodes: 48 (8 vCPUs per node)
  • Master nodes: 96 GB
  • Worker nodes: 384 GB (64 GB per node)
  • Master nodes: 120 GB per standard SSD
  • Worker nodes: one standard SSD of 120 GB
  • HDFS: 2.8.5
  • YARN: 2.8.5
  • Presto: 2.4.3
Impala
  • Master nodes: ecs.g6.6xlarge
  • Worker nodes: ecs.se1ne.2xlarge
  • One master node
  • Six worker nodes
  • Master nodes: 24
  • Worker nodes: 48 (8 vCPUs per node)
  • Master nodes: 96 GB
  • Worker nodes: 384 GB (64 GB per node)
  • Master nodes: 120 GB per standard SSD
  • Worker nodes: four SSDs of 80 GB each
  • HDFS: 2.8.5
  • YARN: 2.8.5
  • Presto: 2.12.2