RDS for MySQL
RDS for MySQL
RDS for MySQL
Document
What's new
Announcement
Product introduction
Product billing
Billing method
Kernel functions
Feature
Stability
Performance
Quick start
User guide
Managing instances
Changing an instance configuration
Upgrading kernel versions
Managing tags
Managing disaster instances
Managing blue-green deployment
Migrating data
Managing connections
Database proxy
Connecting to an instance
Managing connection endpoints
Diagnosing connections
Managing connection pool modes
Managing access addresses and ports
Managing databases
Account and access authorization
Backup recovery
Backup data
Data recovery
Service availability
Managing logs
Managing data security
Managing allowlists
Configuring SSL encryption
Managing parameters
Monitoring and alerts
Task center
Operation and maintenance events
Backups of deleted instances
Managing cross-regional backups
API reference
V2（2022-01-01）
Global management
Managing instances
Managing connections
Managing accounts
Managing databases
Security encryption
Backup and recovery
Managing parameters
Managing tasks
Event management
Managing logs
Resource plan management
Appendix
SDK reference
Developer tools
Best practice
Performance document
Troubleshooting
- Documentation
RDS for MySQLPerformance documentTest methodsTest methods
Copy page
Download PDFTest methods
Test methods
Copy pageDownload PDFTest methods
This topic describes the test scenarios and methods used to stress test RDS for MySQL.
Test scenario
This test includes the following two scenarios:
- In-memory: Suitable for small data volumes. All data can be loaded into the Buffer Pool, and data access primarily hits the memory cache.
- I/O-bound: Suitable for large data volumes. Only frequently accessed data is loaded into the Buffer Pool for read and write operations. Disk read/write and Buffer Pool updates occur during pressure testing.
Test steps
- Replace the following parameters with the actual values of your MySQL instance:
- mysql-db: database.
- mysql-host: connection address.
- mysql-port: database port.
- mysql-user: database account.
- mysql-password: database account password.
- Replace the following parameters with actual values based on the test scenario:
- table_size: the number of rows in the test table.
- tables: the number of test tables.
- time: test time.
- threads: the number of concurrent threads.
- Importing data
- nohup sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --time=XXX --threads=XXX oltp_read_write prepare
- Run test
- nohup sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --time=XXX --threads=XXX oltp_read_write run
- Clear data
- nohup sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --time=XXX --threads=XXX oltp_read_write cleanup
-
Last updated: 2026.07.31 18:44:25
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
