Sysbench benchmark report of OceanBase Database

Test environment (Alibaba Cloud ECS)

• Hardware configuration

• Tenant specifications

CREATE RESOURCE UNIT sysbench_unit max_cpu 26, memory_size '70g'
CREATE RESOURCE POOL sysbench_pool unit = 'sysbench_unit', unit_num = 1, zone_list=('zone1','zone2','zone3');
CREATE TENANT sysbench_tenant resource_pool_list=('sysbench_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

1. Use OceanBase Deployer (OBD) to deploy an OceanBase cluster. Deploy ODP on a separate server.

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 Sysbench 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, which indicates that the leader of the new table partitions is randomly assigned to one of the three servers.

3. Launch the Sysbench client, and run the point_select, read_write, read_only, and write_only tests.

4. Set the --time parameter to 60s for each round of test. The number of threads can be 32, 64, 128, 256, 512, or 1024.

Test specifications

--mysql-db=test
--table_size=1000000
--tables=30
--threads=32/64/128/256/512/1024
--report-interval=10
--time=60
--db-ps-mode=disable
--rand-type=uniform

Results

Point Select performance

Read Only performance

Write Only performance

Read/Write performance