tencent cloud

Test Methods
Download PDF
Last updated:2025-12-25 09:45:59
Test Methods
Last updated: 2025-12-25 09:45:59
Download PDF
This document introduces performance test methods for TDSQL-C for MySQL.

Test Methods

1. Connect and log in to the database via Cloud Virtual Machine (CVM). For the operation method, see Connecting to a Cluster via a Linux CVM Instance Based on the Private or Public Network Address.
2. Run the corresponding command to perform the test. The test commands for different scenarios are as follows.
Read-Only (range select)
Read-Only (point select)
Mixed Read-Write (range select)
Mixed 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 workloads.
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 workloads.
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 workloads.
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 workloads.
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 workloads.
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 commands with the corresponding parameters. The specific parameter descriptions are as follows:
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 user password of the corresponding test instance.
table_size=XXX
Replace XXX with the data volume of a single table.
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 test duration (in seconds).

Test Instance Specifications and Data

1. Full Cache

Specifications
Data Volume of a Single Table (table_size)
Total Number of Tables (tables)
2 cores and 4 GB
25000
250
4 cores and 8 GB
25000
250
8 cores and 16 GB
25000
250
8 cores and 32 GB
25000
250
8 cores and 64 GB
25000
250
16 cores and 64 GB
25000
250
16 cores and 96 GB
25000
250
16 cores and 128 GB
25000
250
24 cores and 144 GB
25000
250
32 cores and 128 GB
25000
250
32 cores and 256 GB
25000
250
64 cores and 256 GB
25000
250
64 cores and 512 GB
25000
250
88 cores and 710 GB
25000
250

2. Large Data Sets

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

Feedback