On this page

Show all

Help Center/ Relational Database Service/ User Guide/ Working with RDS for MariaDB/ Parameter Tuning/ How Do I Improve the Query Speed of My RDS Database?

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

Updated on 2023-12-28 GMT+08:00

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.
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback