How Do I Improve the Query Speed of My RDS Database?

The following are some suggestions provided for you to improve the database query speed:

• View the slow query logs to check if there are any slow queries, and view their performance characteristics to locate the cause. For details about how to view RDS for MariaDB logs, see Viewing and Downloading Slow Query Logs.
• View the CPU usage of your DB instance to facilitate troubleshooting. For details, see Viewing Monitoring Metrics.
• Create read replicas to offload read pressure on the primary DB instance.
• Increase the CPU or memory specifications for DB instances with high loads. For details, see Changing a DB Instance Class.
• Add indexes for associated fields in multi-table association queries.
• Specify a field or add a WHERE clause, which will prevent full table scanning triggered by the SELECT statement.