tencent cloud

Test Method
Download PDF
Last updated: 2025-12-10 14:30:53
Test Method
Last updated: 2025-12-10 14:30:53
Download PDF
This document describes how to conduct performance testing for TDSQL-C for MySQL.

Testing Method

1. Connect to and log in to the database via CVM. The operation method can refer to using private network or public network addresses through Linux CVM to connect to the cluster.
2. Run the command to perform testing. The test commands for different scenarios are as follows.
Read-Only (range select)
Read-Only (point select)
Hybrid Read/Write (range select)
Hybrid Read/Write (point select)
Write-Only
a. Prepare data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only prepare

b. Run workload.
sysbench --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --threads=XXX --tables=XXX --table_size=XXX --time=XXX --report_interval=1 --skip_trx=off --rand-type=uniform --range_selects=on --db-ps-mode=disable oltp_read_only run

c. Clean up data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only cleanup
a. Prepare data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only prepare

b. Run workload.
sysbench --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --threads=XXX --tables=XXX --table_size=XXX --time=XXX --report_interval=1 --skip_trx=off --rand-type=uniform --range_selects=off --db-ps-mode=disable oltp_read_only run

c. Clean up data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only cleanup
a. Prepare data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write prepare

b. Run workload.
sysbench --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --threads=XXX --tables=XXX --table_size=XXX --time=XXX --report_interval=1 --skip_trx=off --range_selects=on --rand-type=uniform --db-ps-mode=disable oltp_read_write run

c. Clean up data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write cleanup
a. Prepare data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write prepare

b. Run workload.
sysbench --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --threads=XXX --tables=XXX --table_size=XXX --time=XXX --report_interval=1 --skip_trx=off --range_selects=off --rand-type=uniform --db-ps-mode=disable oltp_read_write run

c. Clean up data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write cleanup
a. Prepare data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_write_only prepare

b. Run workload.
sysbench --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --threads=XXX --tables=XXX --table_size=XXX --time=XXX --report_interval=1 --skip_trx=off --rand-type=uniform  --db-ps-mode=disable oltp_write_only run

c. Clean up data.
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_write_only cleanup
Replace XXX in the above command with corresponding parameters, as detailed below:
Parameter
Description
host=XXX
Replace XXX with the private network address of the corresponding test instance.
port=XXX
Replace XXX with the port number of the corresponding test instance.
user=XXX
Replace XXX with the username of the corresponding test instance.
password=XXX
Replace XXX with the username and password of the corresponding test instance.
table_size=XXX
Replace XXX with the single-table data volume.
tables=XXX
Replace XXX with the total number of tables.
mysql-db=XXX
Replace XXX with the database name.
threads=XXX
Replace XXX with the number of concurrent threads.
time=XXX
Replace XXX with the total duration of the test run (in seconds).

Testing Instance Specifications and Data

1. Full Caching

Specification
Single-Table Data Volume (table_size)
Total Number of Tables (Tables)
2-core 4 GB
25000
250
4-core 8 GB
25000
250
8-core 16 GB
25000
250
8-core 32 GB
25000
250
8-core 64 GB
25000
250
16-core 64 GB
25000
250
16-core 96 GB
25000
250
16-core 128 GB
25000
250
24-core 144 GB
25000
250
32-core 128 GB
25000
250
32-core 256 GB
25000
250
64-core 256 GB
25000
250
64-core 512 GB
25000
250
88-core 710 GB
25000
250

2. Large Data Set

Specification
Single-Table Data Volume (table_size)
Total Number of Tables (Tables)
2-core 4 GB
800000
100
4-core 8 GB
800000
100
8-core 16 GB
800000
300
8-core 32 GB
800000
300
8-core 64 GB
800000
450
16-core 64 GB
800000
450
16-core 96 GB
800000
600
16-core 128 GB
800000
600
24-core 144 GB
5000000
300
32-core 128 GB
5000000
300
32-core 256 GB
5000000
400
64-core 256 GB
5000000
400
64-core 512 GB
6000000
450
88-core 710 GB
7000000
450
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback