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.