Release Notes and Announcements

Release Notes

Product Announcements

Beginner's Guide

Product Introduction

Overview

Strengths

Use Cases

Architecture

Product Specifications

Instance Types

Product Feature List

Database Versions

Regions and AZs

Common Concepts

Use Limits

Suggestions on Usage Specifications

Kernel Features

Kernel Overview

Kernel Version Release Notes

Optimized Kernel Version

Functionality Features

Performance Features

Security Features

Stability Feature

Analysis Engine Features

Inspection and Repair of Kernel Issues

Purchase Guide

Billing Overview

Product Pricing

Creating Cluster

Specification Adjustment Description

Renewal

Payment Overdue

Refund

Change from Pay-as-You-Go to Yearly/Monthly Subscription

Change from Pay-as-You-Go to Serverless Billing

Value-Added Services Billing Overview

Viewing Billing Statements

Getting Started

Database Audit

Overview

Viewing Audit Instance List

Enabling Audit Service

Viewing Audit Logs

Log Shipping

Post-Event Alarm Configuration

Modifying Audit Rule

Modifying Audit Service

Disabling Audit Service

Audit Rule Template

Viewing Audit Task

Authorizing Sub-User to Use Database Audit

Serverless Service

Serverless Introduction

Creating and Managing a Serverless Cluster

Elastic Scaling Management Tool

Serverless Resource Pack

Multi-AZ Deployment

Configuration Change

FAQs

Serverless Cost Estimator

Operation Guide

Operation Overview

Switching Cluster Page View in Console

Database Connection

Instance Management

Configuration Adjustment

Instance Mode Management

Cluster Management

Scaling Instance

Database Proxy

Account Management

Database Management

Database Management Tool

Parameter Configuration

Multi-AZ Deployment

Backup and Restoration

Operation Log

Data Migration

Parallel Query

Columnar Storage Index (CSI)

Analysis Engine

Database Security and Encryption

Monitoring and Alarms

Basic SQL Operations

Connecting to TDSQL-C for MySQL Through SCF

Tag

Practical Tutorial

Classified Protection Practice for Database Audit of TDSQL-C for MySQL

Upgrading Database Version from MySQL 5.7 to 8.0 Through DTS

Usage Instructions for TDSQL-C MySQL

New Version of Console

Implementing Multiple RO Groups with Multiple Database Proxy Connection Addresses

Strengths of Database Proxy

Selecting Billing Mode for Storage Space

Creating Remote Disaster Recovery by DTS

Creating VPC for Cluster

Data Rollback

Solution to High CPU Utilization

How to Authorize Sub-Users to View Monitoring Data

White Paper

Security White Paper

Performance White Paper

Troubleshooting

Connection Issues

Performance Issues

API Documentation

History

Introduction

API Category

Making API Requests

Instance APIs

Multi-Availability Zone APIs

Other APIs

Audit APIs

Database Proxy APIs

Backup and Recovery APIs

Parameter Management APIs

Billing APIs

serverless APIs

Resource Package APIs

Account APIs

Performance Analysis APIs

Data Types

Error Codes

FAQs

Basic Concepts

Purchase and Billing

Compatibility and Format

Connection and Network

Features

Console Operations

Database and Table

Performance and Log

Database Audit

Between TDSQL-C for MySQL and TencentDB for MySQL

Service Agreement

Service Level Agreement

TDSQL-C Policy

Data Privacy and Security Agreement

General References

Standards and Certifications

Glossary

Test Methods

PDF

Focus Mode

Font Size

Last updated: 2025-12-25 09:45:59

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

Help and Support

Was this page helpful?

You can also Contact sales or Submit a Ticket for help.

Help us improve! Rate your documentation experience in 5 mins.

Feedback

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).

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

tencent cloud

TDSQL-C for MySQL

Test Methods

Test Methods

Test Instance Specifications and Data

1. Full Cache

2. Large Data Sets

Help and Support