Skip to main content
The 2024 Developer Survey results are live! See the results

Questions tagged [amazon-rds]

Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Filter by
Sorted by
Tagged with
0 votes
0 answers
6 views

Failed to prune sessions: no pg_hba.conf entry for host, although connection works fine

I am using an AWS RDS Postgres database and Typeorm to connect to the database. I have also configured the RDS database to require a SSL connection. I pass the CA certificate to the database like this:...
BarbuDorel's user avatar
1 vote
1 answer
27 views

Decrease high response time when reading large table in MySQL

I have a table with around 80~ million rows called parts. I have a simple query like this SELECT line_code, part_number, compressed_part_number, ...[Others columns] FROM parts WHERE (@partNumber = ...
fluid undefined's user avatar
0 votes
1 answer
30 views

How to run a query against AWS RDS "locally"?

Our company has an RDS instance of a Postgres database in AWS. I don't have much experience with AWS. I'd like to run a very lengthy query against the database (VACUUM FULL) that may take many hours ...
Vladimir Baranov's user avatar
0 votes
2 answers
46 views

How to down size the storage of AWS RDS MySQL instance?

I have an RDS MySQL instance db.m5.4xlarge with 8.3TB of data, and I want to shrink it to 4TB to save costs because it actually has 4TB of data. What are the viable options? I've tried several methods,...
user26127523's user avatar
0 votes
0 answers
23 views

Intermittent AWS RDS Connection Spikes Causing Production DB Outages

I'm new to AWS, and we're using a db.r7g.2xlarge instance running MySQL with default configurations. Typically, CPU usage and database connections are normal until "something" causes the DB ...
Mohamed Akram's user avatar
0 votes
1 answer
33 views

AWS RDS taking snapshots outside the backup window

I administer an AWS RDS SQL Server instance, with a backup window of 22:00-22:30 UTC and a retention period of 35 days. I have noticed some peculiarities: There are 55 automatic snapshots currently ...
Christian Hayter's user avatar
0 votes
0 answers
15 views

I have created a blue green deployment for my AWS RDS MySQL Database as I need to update the version. But I can't connect to the green instance?

I have an old MySQL database on AWS RDS that I need to upgrade to a newer version. I have created a blue green deployment, in order to test out the upgraded version of MySQL before switching over. But ...
Jesper's user avatar
  • 1
0 votes
0 answers
25 views

When to provision higher iops or throughput on gp3

We have an AWS PostgreSQL RDS instance. Not a lot of users, high loads in the overnight batch jobs. Current instance type is m6g.large (2CPU 8GiB RAM) with 1300 GB Storage on gp3 SSD with 12000 IOPS ...
Bart Jonk's user avatar
  • 317
0 votes
1 answer
59 views

high cpu spikes on postgresql (rds)

I have a PG 15(.5) RDS instance, which is experiencing intermittent random(?) periods of high cpu; that do not seem to, afaict, correlate with an obvious cause: Here is one example. The queries being ...
grahamrhay's user avatar
0 votes
0 answers
18 views

Accessing RDS transaction logs

Greetings to everyone from a newcomer to this forum! There is an RDS MySQL 5.7 database the transaction logs of which I would like to inspect: more specifically, upon attempting to add foreign keys to ...
ΑΘΩ's user avatar
  • 101
1 vote
1 answer
55 views

ORACLE: RDS On AWS

This may be a lack of understanding as I am a MSSQL DBA more than Oracle. We are running Oracle on RDS in Amazon. Engine Version 19.0.0.0.ru-2020-10.rur-2020-10.r1 I dropped an old _backup table but ...
Stockburn's user avatar
  • 431
0 votes
1 answer
69 views

Can not create logon trigger on AWS RDS sql server instance

In order to audit logins I've used before a server level trigger catching the LOGON and saving it to a table, there are endless examples to do this. But trying to do the same on and AWS RDS sqlserver ...
Yaroslav's user avatar
  • 2,828
0 votes
0 answers
10 views

RDS too many connections from Magento

Hi I am facing an abnormal issue with RDS. Some times the sessions increases rapidly and eventually i need to restart the database. May be it is causing due to a lock on any table. I still curious ...
Abdul Rafay's user avatar
1 vote
2 answers
121 views

Unable to enable Performance Insights on Amazon RDS db.t3.small instance

I recently upgraded my Amazon RDS instance from db.t2.micro to db.t3.small. After the upgrade, I also activated the performance_schema parameter in the associated parameter group because I've read ...
Igor's user avatar
  • 113
0 votes
0 answers
17 views

how to use Amazon SCT to connection to an Amazon RDS database?

Apparently, Amazon SCT can be used to compare two schemas for differences. We have several RDS Postgres databases, using Native postres authentication. SCT has the option to connect to an RDS database ...
John Little's user avatar
0 votes
1 answer
28 views

How to enable pg_stat_user_indexes on postgres on Amazon RDS

We want to check if we have unused indexes in our postgres 15.5 RDS instances. Currently, we did "CREATE EXTENSION IF NOT EXISTS pg_stat_statements" Which enables pg_stat_satements, but what ...
John Little's user avatar
1 vote
1 answer
50 views

Database isn't using the correct index

I have a table that contains several jsonb columns. Here is a simplified version of it create table if not exists files ( id int generated always as identity primary key, source text not null, ...
Aditya Chempakasseril's user avatar
0 votes
1 answer
88 views

Postgres logical replication and table rename

We have a table in main DB that is getting logically replicated to another DB called SOR. We need to rename this table, and add a bunch of tables to the publication on the main DB. I tried this ...
hxcb's user avatar
  • 3
0 votes
0 answers
61 views

database "template0" is not currently accepting connections

i got the following error database "template0" is not currently accepting connections How to vaccum it? Thanks UPDATE i got the following yesterday postgres=> select * from public.test; ...
BAE's user avatar
  • 259
1 vote
1 answer
240 views

Improving write performance for 100 million writes daily on Postgres [closed]

We have posgres 15 in RDS and the instance is db.m6g.4xlarge with 64Gb RAM. We want to write to a table that is date partitioned and has two UUID fields (lets call them id1, id2) and few other ...
Vishesh's user avatar
  • 11
0 votes
0 answers
32 views

Azure MySQL and AWS RDS insert performance difference

We had to move our infra from AWS to Azure (reasons irrelevant) and I've set up a same spec DB instance on Azure, even a tier larger (2c/8g on AWS and 2c/16g on Azure, both memory optimized). What I'...
pyr0hu's user avatar
  • 1
0 votes
0 answers
17 views

AWS RDS MySQL read replica's failover and standby instance's failover

This question is for AWS RDS MySQL I have recently started studying RDS, trying to study from the documentation as well as other sources. For following scenario I am unable to understand certain ...
Avinash Pawar's user avatar
1 vote
0 answers
95 views

AWS RDS MySQL "manual" read replica in "Waiting for dependent transaction to commit" state but lag is zero

I have an SOP I use to upgrade AWS RDS instances running MySQL with no downtime that I have been following since 2021. I'll outline my method below, but it involves manually hooking up a new master ...
Amer's user avatar
  • 111
2 votes
0 answers
93 views

'Deadlock found when trying to get lock; try restarting transaction' in AWS RDS MySQL 8.0.36 after upgrading from MySQL 5.7.42. Django v4.1.6

Following an upgrade of our AWS RDS instance from MySQL version 5.7.42 to version 8.0.36, we are encountering persistent deadlock issues across concurrent transactions, affecting even basic read ...
Karan Raj's user avatar
0 votes
0 answers
61 views

AWS RDS SQL Server 2019 Standard edition, everyday 3 am getting errors "insufficient system memory in resource pool 'internal' to run this query"

I have AWS RDS SQL Server 2019 Standard edition with 128GB RAM, everyday 3 am getting errors insufficient system memory in resource pool 'internal' to run this query There are few jobs that run at a ...
Praveen Suhalka's user avatar
0 votes
0 answers
42 views

How does AWS Data Migration Service actually work with MSSQL?

I'm very confused as to how AWS Data Migration Service is actually achieving it's replication from an on prem MS SQL 2019 instance to RDS 2019. I understand from the documentation that tables with a ...
RPD's user avatar
  • 31
0 votes
1 answer
261 views

drop database hangs with "Waiting for table metadata lock" in MySQL8 RDS on AWS

We have a large table in a database that a user tried to run DELETE * FROM table on. It was still running the next day so we killed the process. I tried renaming, dropping and truncating the affected ...
George's user avatar
  • 126
0 votes
1 answer
93 views

What could cause replication to break on MySQL when replicating from 5.7.40 to 8.0 replica

We have a MySQL primary running on 5.7.40. We are in process of testing the upgrade to 8.0.36 (this is on AWS RDS). We had 2 MySQL-8 replicas and 2 MySQL-5.7 replicas replicating from the primary. At ...
Rahul's user avatar
  • 119
0 votes
1 answer
311 views

Postgres: Investigate RAM usage of a connection

Via pg_proctab(), I can see that the connections from our application can use up to 800MB of RAM per connection in postgres. Usually up to 400MB. (Update to clarify after a comment: These connections ...
Peter's user avatar
  • 168
0 votes
1 answer
310 views

How to cancel vacuum process in AWS RDS PostgreSQL

Is there a way to cancel an automatic vacuum in rds postgresql? When running select pg_cancel_backend(...); select pg_terminate_backend(...); with a user that has the rds_superuser role an error ...
Vasileios Giannakidis's user avatar
1 vote
1 answer
72 views

DROP and TRUNCATE table on MySQL 8.0.35 freezes the DB

We recently upgraded from MySQL 5.7 to MySQL 8.0.35 in AWS RDS. There is a log table that services write to and we rotate it daily, using RENAME TABLE command. Later when we perform a DROP or TRUNCATE ...
AlexV's user avatar
  • 125
0 votes
1 answer
85 views

Select query with 90+ parameters intermittently 20x slower on RDS PostgreSQL instance when using connection pool

I'm running a select statement on a postgresql table (on an RDS instance) in order to sum up values across 2 mil rows. The select statement has about 100 parameters (mostly different countries we want ...
Arnfred's user avatar
  • 101
0 votes
1 answer
217 views

Aurora PostgreSQL TEMP TABLE creation taking more CPU than expected?

I'm running on an Aurora PostgreSQL on a db.x2g.2xlarge instance. Simply creating temporary table showed up as the third highest wait, which surprises me, as I expected it to be one of the lighest ...
Joe's user avatar
  • 1,645
1 vote
0 answers
35 views

AWS SQL - High CPU Usage from select * from #spproccol

SQL 13.x will intermittently spike a CPU usage (60-90%). It will stay high so we added AWS Performance Insights. These queries are not something we have defined or used but something is calling them ...
Brad G's user avatar
  • 11
0 votes
0 answers
119 views

Aurora RDS - difference between ConnectionAttempts and DatabaseConnections

So I have read this a few times about these two metrics: ConnectionAttempts and DatabaseConnections. Based on the above, is RDS rejecting lots of connections? Here are the graphs of these two metrics. ...
Abs's user avatar
  • 1
0 votes
0 answers
11 views

Aurora3 RDS MySQL Stored function/trigger performance when using information_schema

Since moving to Aurora3 RDS (MySQL 8 based) vs Aurora 2 (MySQL 5.7 based) noticed that execution time of certain triggers and stored functions performance has degraded. Correlation between triggers ...
BigKiwiDev's user avatar
0 votes
0 answers
32 views

What is the correct configuration for an RDS instance to allow for upgrades when the databases are very large?

I've been using Amazon RDS instances for Postgres databses for a while, but I haven't had to do a lot of upgrading on large databases until recently. I hit an issue where one database was hundreds of ...
trueCamelType's user avatar
0 votes
0 answers
69 views

MySQL - Can FLUSH TABLES Be Triggered Automatically by MySQL Itself?

As it says in the title, I am looking to determine whether MySQL itself will, on its own, issue a FLUSH TABLES command at any point. I have yet to find anything that points to a specific answer to ...
Marisa's user avatar
  • 23
0 votes
0 answers
6 views

Aurora RDS MySQL historical database recovery from historical snapshot and master snapshot?

I was able to simulate a transactional cluster replicating to a historical cluster and it does all the changes, inserts, updates, deletes. I was able to do an archiving delete so those deletes did ...
Dean Hiller's user avatar
0 votes
0 answers
90 views

Unable to connect to AWS mysql RDS instance

I created an AWS mySQL RDS instance (free tier), but i am unable to connect to it from workbench or cli. I have enabled public access to the DB while creation and allowed "All traffic" while ...
Ankit Rustagi's user avatar
0 votes
3 answers
181 views

select count(*) takes too much time in RDS/MySQL during high traffic

Setup: db.t3.xlarge RDS instance. MySQL 8.0.33 engine. Default parameter and options group. ~900k records table. RDS has no logging enabled at all, and we cannot restart the instance for now to ...
Nico's user avatar
  • 3
0 votes
0 answers
71 views

How to fix high px deq slave session stats in Oracle RDS

We are seeing some high percentage of "px deq slave session stats" waits in our Production database.(this maintained on AWS RDS). Due to which outage is happening many times from searching ...
Arun's user avatar
  • 13
1 vote
2 answers
104 views

SQL Server Combine Partioned Backups Files to One?

Scenario: Every day you receive a SQL Server 2016 database backup set that is composed of multiple partitioned .bak files of size 1GB each: backup1.bak (1GB) backup2.bak (1GB) backup3.bak (1GB) ... ...
gbeaven's user avatar
  • 213
2 votes
1 answer
347 views

Column used in the publication WHERE expression is not part of the replica identity

I'm trying to create a logical replication setup where I have a single large database with smaller read replicas branching of filtered on a sub id. For example, if I wanted a subset of items pushed to ...
goldfishalpha's user avatar
0 votes
1 answer
117 views

How to atomically update different databases?

I have a lambda function which receives data of newly signed up users from a message queue and insert that same data in two different databases. Those two databases belong to two different ...
Prerak Jain's user avatar
1 vote
1 answer
95 views

Upgrade Postgres RDS in AWS fails major version upgrade

I have been attempting to upgrade our AWS RDS Postgres from 11.22 to 12.17 and/or 15.5 In both instances I get the following error in the error log: executing: SELECT datname, datallowconn FROM ...
sweetfa's user avatar
  • 188
1 vote
0 answers
2k views

AWS RDS Postgres: How to diagnose CheckpointLag and potential slowups using AWS' Monitoring suite?

We are currently hosting a postgres RDS database and our team is noticing slowup in our querying service. I'm noticing a spike in the metric, CheckpointLag and I've been tasked in trying to find where ...
Andrew Narvaez's user avatar
9 votes
1 answer
990 views

How to add index to a big table with 60M records without downtime?

we have been struggling with one issue in the past few days. We want to add an index to a huge table with 60M records. At first we tried adding it with basic mysql syntax. But it clogged our ...
Rohan's user avatar
  • 43
1 vote
1 answer
731 views

Amazon Aurora RDS (serveless) - How to match an ACU in terms of CPU number and memory

I need to migrate an Amazon RDS back to on-premises envoriment. How to How to match an ACU in terms of CPU number and memory? My instance has: Minimum capacity 1 ACUs (2 GiB) Maximum capacity 10 ACUs (...
Astora's user avatar
  • 791
0 votes
2 answers
62 views

Oracle Batch Deletion

I have an Oracle table that has over 1.8 Billion rows, I need to delete up to 260 million of these rows. I am a Microsoft SQL DBA, so not fully comfortable with the Oracle syntax and best practices ...
Stockburn's user avatar
  • 431

1
2 3 4 5
20