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

Questions tagged with Performance Insights

Amazon RDS Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action.

Content language: English

Select up to 5 tags to filter
Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

70 results
I have been struggling with the following issue. When using MySQL 8.0.32+ (maybe previous versions as well) and enabling performance insights in RDS, my instances start leaking memory. It is very obvi...
0
answers
1
votes
552
views
asked a year ago
I have an RDS that has Performance insights enabled. I can view the performance from the console. Is there a way to download the various metrics from the Dimensions Tab? I am specifically interested i...
1
answers
0
votes
568
views
asked a year ago
I need to fetch the Top sql statements from RDS performance insights based on Avg latency(ms)/call and send it as pdf. While checking the documentation, got the metric https://docs.aws.amazon.com/Ama...
1
answers
1
votes
1.1K
views
asked a year ago
**Background**: We have a kinesis Firehose configured to send to encrypted S3, it is converting from JSON to Parquet. The source is Direct PUT. The Buffer hints are set with 64MiB and interval of...
1
answers
0
votes
1.2K
views
asked a year ago
I am currently facing an issue where my TOP SQL stats are displayed as "-" for all my queries. I am using an Aurora Mysql 8.0.mysql_aurora.3.04.0 database. After further investigation I came to the c...
0
answers
0
votes
147
views
asked a year ago
I can see "Other 1075 mysqld threads" using 74% CPU of the RDS MySQL instance (v8.0.33) under "Operating system process list" in "Monitoring" tab and also in Performance Insights Metrics Dashboard und...
1
answers
0
votes
1.8K
views
profile picture
asked a year ago
I want to enable Performance Insight in the my 'DB Cluster' which consist of following specifications **Current capacity**: 1 capacity unit, **Role**: Serverless, **Engine**: Aurora MySQL, **Engine ve...
2
answers
0
votes
909
views
asked a year ago
Hello, On one of my RDS clusters, i got the recommendation to turn on performance insights. When I tried to modify the database with Aurora Mysql 2.06 engine with instance type db.r4.xx , I am not get...
3
answers
0
votes
411
views
profile picture
asked a year ago
Dears, I'm following the following documentation to be able to retrieve the Performance Insights metrics for Calls/sec and Rows examined/call Source: https://boto3.amazonaws.com/v1/documentation/api/...
3
answers
0
votes
501
views
asked a year ago
We are using AWS RDS `Performance Insights` and trying to understand which host was responsible for `DB load`, when viewing dashboard `'Slice By Waits'`, tried to check `"Top hosts"` under Dimensions ...
1
answers
0
votes
165
views
asked a year ago
Last week I've noticed a sudden spike in the ReadIOPS activity across all our RDS instances. It happened in two batches, actually, but it affected all of them: ![Enter image description here](/media/...
0
answers
0
votes
157
views
asked a year ago
Hi, I am trying to get performance insights through AWS CLI. When I access the performance insights with my user through AWS console then it is working fine and all graphs and other data is showing, b...
7
answers
1
votes
2.1K
views
asked a year ago