OceanBase Database TPC-DS test report

This topic describes the test environment, test plan, and detailed test data results of the TPC-DS test.

Test environment

The following example uses Alibaba Cloud ECS instances as the deployment environment.

• Hardware configuration

  Service type	ECS type	Number of instances	CPU cores	Memory
  OceanBase Database	ecs.r8i.8xlarge	3	32C	256G Each instance has a 400GB log disk and a 1200GB data disk, with a performance level of PL1
  ODP	ecs.r8i.8xlarge	1	32c	256G

• Software versions

  Service type	Software version
  OceanBase Database	Enterprise Edition: OceanBase 4.3.5.0 Community Edition: OceanBase_CE 4.3.5.0
  TPC-DS	V3.0.0
  OS	CentOS Linux release 7.9.2009 (Core)

• Tenant specifications

  obd cluster tenant create obperf -n tpcds_tenant --max-cpu=28 --memory-size=180G --zone-list=zone1,zone2,zone3 --primary-zone=RANDOM  --locality=F@zone1,F@zone2,F@zone3 --charset=utf8 -s 'ob_tcp_invited_nodes="%"' --optimize=htap
  

  Note

  In this example, --optimize=htap is the default load type. In a production environment, select the appropriate load type based on the actual cluster type.

Test plan

• This test requires four instances. TPC-DS and ODP are deployed on one instance, which serves as the client pressure instance. To deploy an OceanBase cluster using ODP, you need three instances. The OceanBase cluster is scaled out in a 1:1:1 manner.

• After the deployment is completed, create a tenant and user for running the TPC-DS test. Do not use the sys tenant for the test. The sys tenant is an internal system tenant for managing the cluster. Set the primary_zone of the tenant to RANDOM.

• Test data volume: 100 GB.

• For more information about the test steps, see Run the TPC-DS benchmark on OceanBase Database.

Test results

In this TPC-DS test, cold run and hot run scenarios were tested with data volumes of 100 GB and 1 TB, respectively. All tests were conducted under a concurrency level of 96.