Help Center/
Relational Database Service/
User Guide/
Working with RDS for MariaDB/
Performance Tuning/
How Do I Improve the Query Speed of My RDS Database?
Updated on 2023-09-26 GMT+08:00
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.
Parent topic: Performance Tuning
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot