tencent cloud

Sysbench Test
Download PDF
Last updated: 2025-07-22 16:15:09
Sysbench Test
Last updated: 2025-07-22 16:15:09
Download PDF

Test Overview

The Sysbench test report of the TDStore engine is provided as a performance comparison benchmark for different versions.

Test Environment

Hardware Environment

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

Software Version

Node Type
Software Version
HyperNode
v20.0.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 OLTP scenario tests, 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 Result

Point Query Scenario


Thread Count
TPS
QPS
P95 Latency (ms)
32
38,529.83
38,529.83
1.08
64
70,432.26
70,432.26
1.16
128
142,401.56
142,401.56
1.14
256
257,455
257,455
1.3
512
303,421.66
303,421.66
1.96
1,024
333,089.14
333,089.14
12.08

Read-Only Scenario


Thread Count
TPS
QPS
P95 Latency (ms)
32
3,718.16
59,490.55
10.27
64
6,969.88
111,518
11.04
128
12,574.08
201,185.25
12.3
256
14,006.38
224,102.12
39.65
512
14,882.04
238,112.62
65.65
1,024
15,286.33
244,581.30
118.92

Index Update


Thread Count
TPS
QPS
P95 Latency (ms)
32
8,505.21
8,505.21
5.67
64
15,562.77
15,562.77
6.09
128
29,050.14
29,050.14
6.55
256
51,415.89
51,415.89
7.56
512
64,561.69
64,561.69
19.65
1,024
72,160.95
72,160.95
44.98

Non-index Update


Thread Count
TPS
QPS
P95 Latency (ms)
32
9,088.07
9,088.07
5.67
64
17,736.05
17,736.05
5.57
128
32,157.99
32,157.99
6.21
256
55,961.77
55,961.77
7.04
512
85,495.51
85,495.51
11.24
1,024
96,605.66
96,605.66
25.74

Write-Only Scenario


Thread Count
TPS
QPS
P95 Latency (ms)
32
3,366.87
20,201.25
13.46
64
6,410.02
38,460.15
13.95
128
11,800.35
70,802.10
15
256
17,188.05
103,128.33
25.28
512
18,600.43
111,602.61
56.84
1,024
20,536.86
123,221.14
89.16

Mixed Read-Write


Thread Count
TPS
QPS
P95 Latency (ms)
32
1,793.43
35,868.67
22.28
64
3,392.70
67,854.01
23.52
128
5,684.63
113,692.69
29.19
256
6,610.58
132,211.69
63.32
512
7,066.07
141,321.40
106.75
1,024
7,363.82
147,276.35
231.53
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback