tencent cloud

Feedback

Test Methods

Last updated: 2023-11-20 17:08:38
This document describes the method of TDSQL-C for MySQL performance test.

Scenario 1: Full Cache

List of table sizes and table quantities in the full cache test scenario:
Specification
Table Size (table_size)
Total Tables (tables)
2-core 16 GB MEM
25000
250
4-core 16 GB MEM
25000
250
2-core 32 GB MEM
25000
250
8-core 32 GB MEM
25000
250
8-core 64 GB MEM
25000
250
16-core 64 GB MEM
25000
250
16-core 96 GB MEM
25000
250
16-core 128 GB MEM
25000
250
32-core 128 GB MEM
25000
250
32-core 256 GB MEM
25000
250
64-core 256 GB MEM
25000
250

Command execution

Note:
Replace XXX in the following commands with the private network address, port number, username, user password, and database name of the tested TDSQL-C for MySQL cluster, as well as the table_size and tables corresponding to the test scenario. Specific parameters are as described below:
-host: Private network address of the tested instance
-port: Port number
-user: Username
- password: Password of the username
-table_size: Data volume in one single table
-tables: Total number of tables
-mysql-db: Database name
1. Write
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
## 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 --events=0 --time=600 --threads=192 --percentile=95 --report-interval=1 oltp_write_only run
## Run the workload

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
## Clear the data
2. Read (POINT SELECT)
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
## 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 --events=0 --time=600 --threads=512 --percentile=95 --range_selects=0 --skip-trx=1 --report-interval=1 oltp_read_only run
## Run the workload

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
## Clear the data
3. Read (RANGE SELECT)
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
## 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 --events=0 --time=600 --threads=512 --percentile=95 --skip-trx=1 --report-interval=1 oltp_read_only run
## Run the workload

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
## Clear the data
4. Read-write (POINT SELECT)
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 run
## 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 --events=0 --time=600 --range_selects=0 --threads=XXX --percentile=95 --report-interval=1 oltp_read_write run
## Run the workload

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
## Clear the data
5. Read-write (RANGE SELECT)
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 run
## 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 --events=0 --time=600 --threads=XXX --percentile=95 --report-interval=1 oltp_read_write run
## Run the workload

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
## Clear the data

Scenario 2: Big Dataset

List of table sizes and table quantities in the big dataset test scenario:
Specification
Table Size (table_size)
Total Tables (tables)
2-core 16 GB MEM
800000
150
4-core 16 GB MEM
800000
300
4-core 32 GB MEM
800000
300
8-core 32 GB MEM
800000
300
8-core 64 GB MEM
800000
450
16-core 64 GB MEM
800000
450
16-core 96 GB MEM
800000
600
16-core 128 GB MEM
5000000
300
32-core 128 GB MEM
5000000
300
32-core 256 GB MEM
5000000
400
64-core 256 GB MEM
6000000
450

Command execution

The commands are the same as those in each full cache test scenario. You only need to replace the table_size and tables in the commands.

Scenario 3: 1 TB Single Table

List of table sizes and table quantities in the 1 TB single table test scenario:
Specification
Table Size (table_size)
Total Tables (tables)
2-core 16 GB MEM
4000000000
1
4-core 16 GB MEM
4000000000
1
4-core 32 GB MEM
4000000000
1
8-core 32 GB MEM
4000000000
1
8-core 64 GB MEM
4000000000
1
16-core 64 GB MEM
4000000000
1
16-core 96 GB MEM
4000000000
1
16-core 128 GB MEM
4000000000
1
32-core 128 GB MEM
4000000000
1
32-core 256 GB MEM
4000000000
1
64-core 256 GB MEM
4000000000
1

Command execution

The commands are the same as those in each full cache test scenario. You only need to replace the table_size and tables in the commands.
Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon