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	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 '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	Enterprise Edition: V4.2.2.0 Community Edition: V4.2.2.0_CE
  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 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 used for managing the cluster. Do not use the sys tenant to run the benchmark. Set primary_zone to RANDOM for the tenant.

• Data size: 100 GB.

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

Results