Esta página aún no está disponible en su idioma local. Estamos trabajando arduamente para agregar más versiones de idiomas. Gracias por tu apoyo.

On this page

Show all

Help Center/ Relational Database Service/ User Guide/ Working with RDS for MySQL/ Performance 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 2024-07-18 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 review their performance characteristics (if any) to locate the cause. For details, see .
  • View the CPU usage of your RDS DB instance to facilitate troubleshooting. For details, see .
  • 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