TPC-H benchmark report of OceanBase Database

Test environment (Alibaba Cloud ECS)

• Three-node hardware configurations

  Service type	ECS type	Instances	CPU cores	Memory
  OceanBase Database	ecs.g7.8xlarge	3	32	128 GB Each server has a system disk of 300 GB. Additionally, two cloud disks (400 GB) are mounted, one serving as the clog disk, and the other as the data disk. The performance level is PL1.
  TPC-H	ecs.g7.8xlarge	1	32	128 GB

• Three-node tenant specifications

  CREATE RESOURCE UNIT tpch_unit max_cpu 26, memory_size '70g'
  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 version

  Service type	Software version
  OceanBase Database	Enterprise Edition: V4.2.1.0 Community Edition: V4.2.1.0_CE
  TPC-H	V3.0.0
  Operating system	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. There is no need to deploy the OceanBase Database Proxy (ODP). You can connect directly to a server during the test.

• Deploy the cluster with a 1:1:1 configuration. After deployment, create the tenants and users needed for the TPC-H 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 the detailed test steps, see Run the TPC-H benchmark on OceanBase Database.

Test result