How Do I Improve the Query Speed of My RDS for MySQL Instance?

The following are some suggestions:

• View the slow query logs to check if there are any slow queries, and review their performance characteristics (if any) to locate the cause. For details about how to view RDS for MySQL logs, see Viewing and Downloading Slow Query Logs.
• View the CPU usage of your RDS DB instance to facilitate troubleshooting. For details, see Configuring Displayed Metrics.
• Create read replicas to offload read pressure on the primary DB instance. For details, see Introduction to Read Replicas.
• Enable read/write splitting after read replicas are created. RDS routes write requests to the primary instance and read requests to read replicas by user-defined weights through a read/write splitting address.
• Increase the CPU or memory specifications for DB instances with high load. For details, see Changing a DB Instance Class. To temporarily reduce the load, you can kill sessions. For details, see Managing Real-Time Sessions.
• Add indexes for associated fields in multi-table join queries.
• Specify required columns or add WHERE conditions. Avoid using SELECT*, which can trigger a full table scan.