TPC-C 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.
  ODP and BenchmarkSQL	ecs.c7.16xlarge	1	64 cores	128 GB

• Three-node tenant specifications

  CREATE RESOURCE UNIT tpcc_unit max_cpu 26, memory_size '100g'
  CREATE RESOURCE POOL tpcc_pool unit = 'tpcc_unit', unit_num = 1, zone_list=('zone1','zone2','zone3');
  CREATE TENANT tpcc_tenant resource_pool_list=('tpcc_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
  OceanBase Database Proxy (ODP)	V4.2.1
  BenchmarkSQL	BenchmarkSQL 5.0
  Java Database Connectivity (JDBC)	MySQL Connector/J 5.1.47
  OS	CentOS Linux release 7.9.2009 (Core)

Test plan

1. Use OceanBase Deployer (obd) to deploy an OceanBase cluster. Deploy ODP and the TPC-C tools on the same server to avoid inadequate stress on the client.

2. 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-C 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 to RANDOM for the tenant.

3. For the detailed test steps, see Run the TPC-C benchmark on OceanBase Database.

Test specifications

warehouses=1000
loadWorkers=40
terminals=800
runMins=5
newOrderWeight=45
paymentWeight=43
orderStatusWeight=4
deliveryWeight=4
stockLevelWeight=4

Results

The following results show the performance information of the OceanBase cluster in the 1-1-1 architecture:

TPC-C Result
Measured tpmC (NewOrders)   : 303653.87
Measured tpmTOTAL           : 674530.08
Transaction Count           : 3395842