TPC-H benchmark report of OceanBase Database

Test environment (Alibaba Cloud ECS)

• Three-node hardware configurations

  Service type	ECS type	Number of instances	Number of CPU cores	Memory
  OceanBase Database	ecs.g7.8xlarge	3	32 cores	128 GB Each server has a built-in 300 GB system disk and two attached 400 GB cloud disks as the clog disk and data disk respectively. The disk performance level is PL1.
  TPC-H	ecs.g7.8xlarge	1	32 cores	128 GB

• Three-node tenant specifications

  CREATE RESOURCE UNIT tpch_unit max_cpu 26, memory_size '100g'
  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	OceanBase Database Enterprise Edition V4.2.2.0 OceanBase Database Community Edition V4.2.2.0
  TPC-H	V3.0.0
  OS	CentOS Linux release 7.9.2009 (Core)

Test plan

• Use OceanBase Deployer (obd) to deploy an OceanBase cluster. Deploy the TPC-H client on a server for stress testing. You do not need to deploy OceanBase Database Proxy (ODP). Directly connect to a server during the test.

• Deploy the OceanBase cluster in the 1-1-1 architecture, where the cluster has three zones and each zone has one OBServer node. After successful deployment, create the tenant and users required for running the TPC-H benchmark. The sys tenant is a built-in system tenant for managing the cluster. Do not use the sys tenant to run the benchmark. Set the value of the primary_zone parameter to RANDOM for the tenant.

• Size of the test dataset: 100 GB.

• For the detailed test steps, see Run the TPC-H benchmark on OceanBase Database.

Results