This topic provides guidelines for new users to test the performance of an ApsaraDB RDS for MySQL instance and submit a test report. After you submit a test report, you can receive additional discounts for instance renewal. If your test report is rated excellent, you are offered with substantial incentives from Alibaba Cloud.
Prerequisites
- An ApsaraDB RDS for MySQL instance is created in the ApsaraDB for RDS console. For more information, see A new version is available..
- An ECS instance is created. For more information, see Create an ECS instance.
Background information
ApsaraDB RDS for MySQL test activities.
The following performance metrics are tested:
- Transactions per second (TPS)
The number of transactions that are executed by the RDS instance per second. A transaction is executed only after it is committed.
- Use SysBench to test the performance of online transactional processing (OLTP) for executing a read/write transaction that consists of 18 read and write SQL statements.
- Use SysBench to test the performance of OLTP for executing a read-only transaction that consists of 14 read SQL statements: 10 SQL statements are used to query data based on primary keys and 4 SQL statements are used to query data based on specified ranges.
- Use SysBench to test the performance of OLTP for executing a write-only transaction that consists of four write SQL statements: two UPDATE statements, one DETELE statement, and one INSERT statement.
- Queries per second (QPS)
The number of SQL statements that are executed by the RDS instance per second. These SQL statements include INSERT, SELECT, UPDATE, DETELE, and COMMIT.
SysBench parameters
Parameter | Description |
---|---|
db-driver | The database engine that the RDS instance runs. |
mysql-host | The endpoint used to connect to the RDS instance. |
mysql-port | The port used to connect to the RDS instance. |
mysql-user | The username of the account used to manage the RDS instance. |
mysql-password | The password of the account used to manage the RDS instance. |
mysql-db | The name of the RDS instance |
table_size | The size of tables used for the test. |
tables | The number of tables used for the test. |
events | The number of requests sent for the test. |
time | The time taken for the test. |
threads | The number of threads invoked for the test. |
percentile | The percentage of execution durations that you want to analyze for the test to obtain an average execution duration. The default value is 95%. It allows you to obtain the average time that is required to execute a request for 95% of all the scenarios. |
report-interval | The time interval at which you want to generate a test progress report. The value 0 specifies not to generate test progress reports but only to generate a final test report. |
skip-trx | Specifies whether to skip transactions. Valid values:
|