Sysbench benchmark report of OceanBase Database

Test environment (Alibaba Cloud ECS)

• 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.
  Sysbench	ecs.c7.4xlarge	1	16	32 GB
  ODP	ecs.c7.16xlarge	1	64	128 GB

• 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

  Service type	Software version
  OceanBase Database	Enterprise Edition: V4.2.1.0 Community Edition: V4.2.1.0_CE
  ODP	V4.2.1
  Sysbench	1.0.20
  OS	CentOS Linux release 7.9.2009 (Core)

Test plan

1. Deploy an OceanBase cluster using OceanBase Deployer (obd), and deploy ODP on an independent server.

2. Deploy the cluster with a 1:1:1 configuration. After deployment, create the tenants and users needed for the Sysbench 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, which indicates that the leader of new table partitions is randomly assigned to one of the three servers.

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

4. Set --time 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

Test result

Point Select performance

Read Only performance

Write Only performance

Read/Write performance