Whether you're taking your first steps with Kubernetes or you're an experienced practitioner looking to sharpen your skills, our Amazon EKS workshop series delivers practical, real-world experience that moves you forward. Learn directly from AWS solutions architects and EKS specialists through hands-on sessions designed to build your confidence with Kubernetes. Register now and start building with Amazon EKS!
RDS Performance Insights doesn't display all top SQL stats
We have an issue with Performance Insights for one of our RDS instances. We have two mysql 5.7.38, db.m5.xlarge instances. Both DB uses the same parameter group, security groups and the monitoring role. One instance is a primary, and the second is a read-only replica. We enabled Performance Insights and Enhanced monitoring on both of them.
Unfortunately, only the read-only replica shows full stats for top SQL queries.
Primary DB
Read-only replica
I have trierd disable and enable Performance Insights and reboot instance, no luck so far.
- Newest
- Most votes
- Most comments
This is because the query distribution differs for Primary and read only replica. Primary serves as the Writer endpoint and can also server read requests. Read replica only handles the read queries, your application is sending all Select requests to read replica thats the reason you see all the Select queries in the stats.
Relevant content
- asked 3 years ago
