- Newest
- Most votes
- Most comments
Hello.
i have change my Database instance type to db.t3.medium but stiill use to have more upto 99% usage when the website is slow.
I suspect that when the database instance has low specs and heavy queries are executed, the CPU usage rate increases, leading to timeout errors.
Is your database instance using RDS?
If you are using RDS, you can use a feature called Performance Insights, so enable it and try to find queries that are taking a long time to process.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.Overview.Engines.html
Please i am looking for the best way to know what eexactly and why the website laoding slow so i can know what to do next.
There may be problems other than the database, so I recommend checking the application log and checking for errors.
Relevant content
- AWS OFFICIALUpdated 5 months ago

i change the RDS instance to Multi AZ so i am still looking if it will continue the issue
Can i get the queries that are using more CPU in the performance insignts?