TPC-H benchmark report of OceanBase Database

Test environment (Alibaba Cloud ECS)

• Three-node hardware configuration

• 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

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