TPC-DS test report of OceanBase Database

This topic details the TPC-DS test environment, methods, and results.

Test environment

The tests use Alibaba Cloud ECS as the deployment platform.

• Hardware configuration

  Service type	ECS type	Number of instances	CPU cores	Memory
  OceanBase Database	ecs.r8i.8xlarge	3	32	256 GB Each server includes a 400 GB log disk and a 1200 GB data disk (PL1 performance tier)
  TPC-H	ecs.r8i.8xlarge	1	32	256 GBs

• Software version

  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 sets the default workload type. For production, choose a workload type that fits your cluster.

Test methods

• This test needs four machines: one for both TPC-DS and OceanBase Deployer (obd) to generate client load, and three for the OceanBase cluster (deployed through obd in a 1:1:1 configuration).

• After deployment, create a new tenant and user for running the TPC-DS test (sys is the built-in system tenant for managing the cluster; do not use it directly for testing). Set the tenant's primary_zone to RANDOM.

• Test data size: 100 GB.

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

Test results

The TPC-DS benchmark covers both 100 GB and 1 TB datasets, including cold run and hot run scenarios. All tests use 96 concurrent threads.