This topic describes the scenarios that are used to test the performance of an ApsaraDB RDS for MySQL instance.
Table schema
CREATE TABLE `sbtest100` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`k` int(11) NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_100` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=25001 DEFAULT CHARSET=utf8
OLTP with read/write operations
SQL type | Ratio | SQL statement |
point_selects | 10 |
|
simple_ranges | 1 |
|
sum_ranges | 1 |
|
order_ranges | 1 |
|
distinct_ranges | 1 |
|
index_updates | 1 |
|
non_index_updates | 1 |
|
deletes | 1 |
|
inserts_ignore | 1 |
|