Stress Testing Scenario
Two types of queries can be used to perform stress testing. You can determine the type of stress testing based on your data amount.
• Cache-based queries: Suitable for scenarios with a small amount of data. You can store the full amount of data in the buffer pool for access. The default size of the buffer pool is 50%-70% of the instance memory specification.
• Disk I/O-based queries: Suitable for scenarios with a large amount of data. You can store only the most frequently used data in the buffer pool for access. During the stress testing, data is read from or written to disks, and the buffer pool is updated.
Stress Testing Indicators
The stress testing indicators include TPS and QPS.
The IOPS supported by RDS for MySQL depends on the IO performance of the EVS. For details, see Product Specifications in EVS Product Introduction. Reference link: EVS-Product Specifications.
Region
Due to the differences in the underlying technical architecture of different regions, the test data of RDS for MySQL varies depending on the region. According to the region, it is divided into the following two types of A/B test results for reference. Region A includes all Type I resource pools (Shanghai 7 is used as an example), and Region B includes Type II resource pools (East China 1 is used as an example). For specific resource pool information, see Product Introduction-Overview of Product Features.