TPC-DS benchmark report

Test environment (Alibaba Cloud ECS)

• Three-node hardware configurations

  Service type	ECS type	Number of instances	Number of CPU cores	Memory
  OceanBase Database	ecs.r6.8xlarge	3	32	256 GB. Each OBServer node has a system disk of 300 GB, a log disk of 400 GB, and a data disk of 2 TB. The disk performance level is PL1.
  TPC-DS	ecs.r6.8xlarge	1	32	256 GB

• Three-node tenant specifications

  CREATE RESOURCE UNIT tpch_unit max_cpu 30, memory_size '180g'
  CREATE RESOURCE POOL tpch_pool unit = 'tpch_unit', unit_num = 1, zone_list=('zone1','zone2','zone3');
  CREATE TENANT tpch_mysql resource_pool_list=('tpch_pool'),  zone_list('zone1', 'zone2', 'zone3'), primary_zone=RANDOM, locality='F@zone1,F@zone2,F@zone3' set variables ob_compatibility_mode='mysql', ob_tcp_invited_nodes='%';
  

• Software versions

  Service type	Software version
  OceanBase Database	Enterprise Edition: V4.3.3 Community Edition: V4.3.3_CE
  TPC-DS	V3.0.0
  Operating system	CentOS Linux release 7.9.2009 (Core)

Test plan

• Deploy an OceanBase cluster using OceanBase Deployer (obd). Deploy the TPC-DS client on a server for stress testing. There is no need to deploy the OceanBase Database Proxy (ODP). You can connect directly to a server during the test.

• The 3-node cluster is deployed with a 1:1:1 configuration. After deployment, create the tenants and users needed for the TPC-DS test. The sys tenant is a built-in system tenant for cluster management and do not use it to perform the test. Set the tenant's primary_zone to RANDOM.

• Data size: 100 GB.

• For detailed testing procedures, see TPC-DS benchmark.

Results