Sysbench test report of OceanBase Database

This topic details the Sysbench test environment, methods, and results.

Test environment

The tests use Alibaba Cloud ECS as the deployment platform.

• Hardware configuration

  Service type	ECS type	Number of instances	CPU cores	Memory
  OceanBase Database	ecs.r8i.8xlarge	3	32	256 GB Each has a 100 GB system disk, plus two 600 GB cloud disks for clog and data (PL1 performance)
  Sysbench	ecs.c7.4xlarge	1	16	32 GB
  OceanBase Database Proxy (ODP)	ecs.c7.16xlarge	1	32	128 GB

• Software versions

  Service type	Software version
  OceanBase Database	Enterprise Edition: OceanBase 4.3.5.0 Community Edition: OceanBase_CE 4.3.5.0
  ODP	OceanBase 4.3.1
  Sysbench	1.0.20
  OS	CentOS Linux release 7.9.2009 (Core)

• Tenant specifications

  obd cluster tenant create obperf -n tpcc_tenant --max-cpu=28 --memory-size=180G -–zone-list=zone1,zone2,zone3 -–primary-zone=RANDOM  --locality=F@zone1,F@zone2,F@zone3 --charset=utf8 -s 'ob_tcp_invited_nodes="%"' --optimize=htap
  

  Note

  In this example, --optimize=htap sets the default workload type. For production, choose a workload type that fits your cluster.

Test methods

• The test needs five machines: one for both Sysbench and OceanBase Deployer (obd), one for ODP, and three for the OceanBase cluster (deployed via obd in a 1:1:1 configuration). After deployment, create a dedicated tenant and user for Sysbench tests. The sys tenant is reserved for cluster management and is not used for testing. Set the tenant's primary_zone to RANDOM, so table partition leaders can be distributed randomly across the three servers.

• Import 30 tables into the database, with each table containing 1 million rows of data.

• Start the Sysbench client and four types of tests: point_select, read_write, read_only, and write_only.

• Run each test for 60 seconds (--time=60) with thread counts of 32, 64, 128, 256, 512, and 1024.

For more information about the test steps, see Run the Sysbench benchmark test with OceanBase Database.

Test specifications

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

Test results

These Sysbench tests cover express_oltp, complex_oltp, olap, and htap scenarios, with thread counts of 32, 64, 128, 256, 512, and 1024.

Point Select performance

Read Only performance

Write Only performance

Read Write performance