By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

RDS Performance Insights doesn't display all top SQL stats

0

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 Enter image description here

Read-only replica Enter image description here

I have trierd disable and enable Performance Insights and reboot instance, no luck so far.

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServicePerformance InsightsMonitoringMySQL
Language
English
rePost-User-0468397
asked a year ago227 views
1 Answer
1

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.

AWS
Dheeraj Kumar
answered 10 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content