Questions tagged with Performance Insights
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.
> the --group-identifier is `db.sql.id`. In this example, `my-sql-id `represents a SQL ID retrieved by invoking pi `get-resource-metrics` or `pi describe-dimension-keys`
when I try using...
0
answers
0
votes
139
views
asked 2 years agolg...
Does enabling performance insights on a running mysql rds require restart of the rds instance? After enabling it, will it cause any performance issues?
1
answers
0
votes
830
views
asked 2 years agolg...
According to this: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.UsingDashboard.SQLTextSize.html#view-download-text
I should see a way to download the query in question. But...
1
answers
0
votes
1538
views
asked 2 years agolg...
Currently, I've noticed there is no real option to view full MySQL statements in Performance Insights.
Download option gives file with the same truncated statement even though the UI shows "To view...
3
answers
0
votes
404
views
asked 2 years agolg...
I am using AWS RDS Performance Insights and am trying to establish who and what is generating DB load, when viewing 'Slice By User' I see the expected username of the DB connection cross-referenced...
1
answers
0
votes
3160
views
asked 2 years agolg...
The purpose is to delete an old database (Size: db.m5.xlarge; DB Engine: 8.0.16 Version).
First, we tried to disable Delete Protection, but it shows an error message as below:
*****
*We're sorry,...
1
answers
0
votes
3057
views
asked 2 years agolg...
Hello.
I was having CPU usage issues where the CPU would reach over 50%. So I upgraded from a db.t4g.medium to a db.r6g.xlarge. Now, all is good and running smooth.
But one thing intrigues me: Why...
1
answers
0
votes
415
views
asked 2 years agolg...
Hello Team,
MySQL RDS instance has been restarted on its own and now online.
Would like to know why it was restarted and root cause and fix to not repeat.
Only I see from CloudWatch is below...
2
answers
0
votes
764
views
asked 2 years agolg...
Hi.
we have the Mysql database with Saas in AWS and I need to know how I do an alert that after a 1minute alarm to me from email with the deadlock?
Accepted AnswerPerformance Insights
1
answers
0
votes
242
views
asked 3 years agolg...
Query Plans in Performance Insights was announced on July 2, 2020, at https://aws.amazon.com/about-aws/whats-new/2020/07/amazon-rds-performance-insights-supports-query-plan-capture/.
It said:...
1
answers
0
votes
795
views
asked 4 years agolg...
A query for
`select datname, pid, usename, application_name, client_addr, client_hostname, wait_event_type, wait_event, query, backend_type from pg_stat_activity where state = 'active'`
is running...
1
answers
0
votes
555
views
asked 4 years agolg...
Hello,
We have an db.t3.large RDS instance running Postgres 11.4. We have enabled performance insights but when we go to view the page for our database, we only see the bar chart at the bottom...
Accepted AnswerPerformance Insights
1
answers
0
votes
393
views
asked 5 years agolg...