tencent cloud

Sysbench Test
Download PDF
Last updated:2026-02-10 10:54:57
Sysbench Test
Last updated: 2026-02-10 10:54:57
Download PDF

Test Overview

Provide the Sysbench test report for TDSQL Boundless as a performance benchmark for comparing different versions.

Testing Environment

Hardware Environment

Node Type
Node Specifications
Number of Nodes
Peer node
16-Core CPU/32 GB of Memory/Enhanced SSD 300 GB
3
Management nodes
4Core CPU/8GB Memory
3

Software Version

Node Type
Software Version
HyperNode
v21.1.0
Sysbench
sysbench 1.1.0

Parameter Configuration

set persist audit_log_policy = "NONE";
set persist max_prepared_stmt_count = 1000000;
set persist temptable_max_mmap = 214748364800

Testing Plan

Preparing Test Data

Initialize 32 tables, each with 10 million records.
sysbench oltp_common \\
    --threads=256 \\ 
    --mysql-host=xxxx \\
    --mysql-port=xxxx \\
    --mysql-user=root \\
    --mysql-password=password \\
    --mysql-db=sbtest \\
    --auto_inc=off \\
    --mysql-ignore-errors='all' \\
    prepare --tables=32 --table-size=10000000

Executing a Test

Run the following commands to perform point queries, read-only, index updates, non-index updates, write-only, and mixed read-write tests of OLTP scenarios, respectively.
sysbench ${testname} \\
    --threads=${threads} \\ 
    --time=600 \\
    --report-interval=1 \\
    --mysql-host=xxxx \\
    --mysql-port=xxxx \\
    --mysql-user=root \\
    --mysql-password=password \\
    --mysql-db=sbtest \\
    --auto_inc=off \\
    --mysql-ignore-errors='all' \\
    run --tables=32 --table-size=10000000

Test Results

Scenario for Point Queries


Number of threads
TPS
QPS
P95 Latency (ms)
32
63,870.61
63,870.61
0.67
64
124,293.48
124,293.48
0.7
128
233,065.89
233,065.89
0.77
256
277,157.89
277,157.89
1.08
512
324,700.49
324,700.49
2.03
1,024
333,819.06
333,819.06
7.56

Read-Only Scenario


Number of threads
TPS
QPS
P95 Latency (ms)
32
3,481.81
55,709.04
10.65
64
6,800.25
108,803.95
11.04
128
11,693.45
187,095.18
17.32
256
13,178.44
210,855.07
45.79
512
13,987.80
223,804.85
69.29
1,024
14,449.45
231,191.20
127.81

Index Update


Number of threads
TPS
QPS
P95 Latency (ms)
32
9,275
9,275
5.18
64
18,048.65
18,048.65
5.18
128
32,899.21
32,899.21
5.77
256
55,578.21
55,578.21
6.91
512
65,156.78
65,156.78
23.52
1,024
70,492.40
70,492.40
45.79

Non-index Update


Number of threads
TPS
QPS
P95 Latency (ms)
32
10,729.89
10,729.89
4.49
64
20,241.39
20,241.39
4.65
128
37,119.18
37,119.18
5
256
66,748.11
66,748.11
5.57
512
87,509.79
87,509.79
12.52
1,024
97,252.26
97,252.26
28.67

Write-Only Scenario


Number of threads
TPS
QPS
P95 Latency (ms)
32
3,562.66
21,375.98
12.3
64
6,870.39
41,222.34
12.75
128
12,263.72
73,582.31
14.21
256
16,277.74
97,666.46
34.33
512
17,998.16
107,988.96
59.99
1,024
19,041.88
114,251.31
94.1

Mixed Read-Write


Number of threads
TPS
QPS
P95 Latency (ms)
32
1,787.96
35,759.18
21.89
64
3,450.20
69,003.98
22.69
128
5,642.77
112,855.34
33.12
256
6,504.50
130,090.04
61.08
512
6,991
139,820.09
110.66
1,024
7,238.39
144,767.76
235.74
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback