Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
10 views

AWS KMS Encryption enable for SQL Server Columns?

Is it possible MSSQL on EC2 with a key in AWS KMS to encrypt columns
0
votes
1answer
20 views

MySQL join has drastically worse performance after upgrading from 5.6 to 5.7

I have a fairly straightforward query that has become very slow after upgrading from MySQL 5.6.35 to MySQL 5.7.12 (running on AWS RDS). SELECT DISTINCT Name,d.id,deviceType,issuedBy, description,...
0
votes
1answer
12 views

Why is my AWS RDS (postgres) at a high percentage of cpu with no active sessions?

I have two postgres db, prod and dev. Lately, dev has been really slow, so I checked into it, and it appears to be using CPU credits faster than I'm getting them. I could not figure out why, so I ...
0
votes
0answers
33 views

MySQL Error seems unfixable: Index column size too large

I'm getting: ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes. There are many questions about this here, I tried many of them. No luck. My context: MySQL 8.0.13 ...
0
votes
1answer
25 views

Mysql Out of memory (Needed 536870945 bytes)

I'm trying to import an sql file into aws RDS database the file size is 1.5 GB i'm connecting to the rds from ec2 instance then executing this command "source sqldata.sql" to import it into the rds ...
1
vote
1answer
25 views

Is compression used in RDS SQLServer database

I have few Clarification regarding AWS RDS SQL Server. Do we have any compression technique to compress the data loaded into RDS SQL server? Is there any option or parameter to compress the data and ...
1
vote
0answers
32 views

Predicting AWS RDS MySQL Instance Performance

I have a small MySQL db running on AWS RDS t2.small instance. So far, the CPU usage has been very predictable based on the traffic from my app. Example: 1000 concurrent users = 15% CPU 2000 ...
1
vote
0answers
26 views

AWS RDS Performance Insights not showing SQL Server Queries

I enabled Performance Insights on an existing SQL Server database (Express, if it matters) in AWS RDS. If I look at the database load graph and table I do not see any of the queries I am doing in real ...
3
votes
0answers
80 views

MySQL RDS Incompatible Restore while creating read replica

We have multiple m5 generation MySQL RDS instance. The problem we are facing is that while creating read replica for these instances we are repeatedly getting 'incompatible-restore' error. In the ...
0
votes
1answer
19 views

Find queries causing a lot of read IO

I'm trying to find the cause of a higher amount of VolumeReadIOPs in our Aurora Postgres instance on AWS. This is what the past 6 weeks look like: I found the cause of the largest period (02/27 to 03/...
0
votes
0answers
27 views

How can I install pgtap on rds postgresql?

I am using postgresql 10.7 under AWS RDS. I downloaded pgtap-1.0.0.zip from https://pgxn.org/dist/pgtap/ because I saw an article in AWS forums saying you can just run pgtap.sql yourself. However, ...
0
votes
1answer
88 views

Mysql Alter table add column with ALGORITHM=INPLACE, LOCK=NONE

Am running below query Query Alter table dbname.tablename add column column1 varchar(50), add column column2 text , ALGORITHM=INPLACE, LOCK=NONE; It takes more time to execute. Ideally running ...
1
vote
1answer
24 views

MySQL RDS - Unable to Kill Hung Queries

I have a MySQL RDS instance that's got 100+ queries all stuck waiting for a table metadata lock. The good news I have permission to kill all of the sessions, and have 0 concern for data loss as this ...
2
votes
0answers
25 views

AWS RDS PostgreSQL: Significant query runtime difference between two (identical?) instances

TL;DR: Solution The problem was that one instance hat magnetic storage attached and was therefore significantly slower. Original Question I have two identical AWS RDS PostgreSQL 10.6 databases ...
0
votes
1answer
27 views

Oracle AWS package errors when removing user

We are getting the folowing error when attempting to remove a user from our 11g Oracle. a dump from an Amazon DB was (failed) imported, and now we see this. ERROR at line 1: ORA-00604: error occurred ...
0
votes
2answers
54 views

MySQL 5.6 @ AWS RDS read IOPS plateaus lower than write IOPS

I have an RDS MySQL 5.6 instance which plateaus ReadIOPS at around 6.5k. My WriteIOPS is most often lower, but sometimes higher than ReadIOPS, but has never entered such a rigid plateau. The disk was ...
0
votes
0answers
16 views

Amazon RDS on VMware

I am not sure whether this is the right forum to post my question(sorry if this is not the place). I recently gone through the AWS RDS on VMware offering which is interesting and i have question which ...
0
votes
0answers
18 views

2 postgresql identical rds instances and one is significantly slower

I have 2 instances of free tier rds postgresql db.t2.micro on same zone us-west2 region on 2 different accounts, using defaults at creation, Original and Copy. Original is significantly slower than ...
2
votes
1answer
64 views

RDS MySQL read replica larger than master

We have a Multi AZ AWS MySQL 5.6.40 server with a matching single AZ read replica. Both have 200GB of storage available. However, the read replica is rapidly running out of free storage space, while ...
0
votes
1answer
81 views

Oracle AWS RDS supermaster user cant grant select on some tables

I'm dealing with some sort of issue beyond my Oracle knowledge. A customer wants to execute some queries to detect issues, locks, etc in a Oracle RDS database. I assume this queries needs database ...
0
votes
1answer
27 views

Aws RDS cpu Spike to 100% because of running set isolation command and set

My application running with the AWS RDS as a backend. currently i am doing a performance test. While doing that i am seeing RDS cpu usage goes 100% after 20min. While seeing the performance insights ...
0
votes
1answer
26 views

Does requiring SSL matter if using AWS RDS and AWS EC2 in a VPC

I have a MySQL RDS DB and am connecting it through an EC2 instance. My RDS isn't publicly accessible, so I think it can only be connected to through my EC2 instances. I see at this link https://...
0
votes
0answers
11 views

Does it require to change date values of tables while changing the database timezone

Currently, I am using the rds with timezone UTC. While changing the timezone from UTC to EST, How could i convert the values of date field of all tables of database in EST?
0
votes
0answers
230 views

CPU usage constantly high after upgrading from Postgres 9.5 to 9.6 to 10.6

I upgraded my RDS instance (db.t2.medium) from Postgres 9.5 to 9.6 couple of days back. Since the upgrade, the CPU usage was almost 100% all the time. This brought down my application. Presuming that ...
3
votes
1answer
104 views

How to benchmark disk performance from within SQL Server?

I know of tools such as SQLIO and diskspd to benchmark IO/disk performance, but need something that can be run from the SQL Server instance itself via T-SQL, as I'm working on a Cloud-hosted ...
0
votes
1answer
82 views

How to alter system on AWS RDS?

I need to run ALTER SYSTEM SET track_activity_query_size = 16384; So I can see the contents of some long running queries (I can only see the beginning at the default size), but when I try to do ...
0
votes
1answer
49 views

Schema replication Postgresql AWS

Is there a way to replicate Postgres Schemas in AWS into one location for reporting purposes? I have 3 postgres databases (up to date with current version) running in AWS that I would like to ...
0
votes
0answers
19 views

Sharing read/write resources between connections in an unfair way

I have two applications that connect to a Postgresql database. A read-only application querying tuned MVs A write-only application updating the database and the MVs We only really require that (1) ...
0
votes
0answers
11 views

Why would PSQL on AWS RDS trigger an unexpected recovery?

Setup AWS RDS db.t2.small Postgres 9.6.3 Conditions - seen in monitoring Free mem 1GB Swap grew up to about 15 MB before the recovery Nothing unstable in any other monitoring Event logs lost not ...
0
votes
1answer
132 views

MySQL slave stuck on Applying batch of row changes (write)

I'm using Amazon RDS as a slave for my dedicated MySQL server (running outside of AWS). Replication has been working alright for the past few months, until yesterday when I updated the structure of ...
1
vote
1answer
39 views

Issue with Time Zone while migrating MySQL on-premises DB to AWS RDS

I am having MySQL 5.6 database with PST time format in on-premises server. Now we are willing to migrate the database to RDS. For this, we have taken backup from physical server and restored in RDS ...
1
vote
0answers
79 views

Amazon RDS SQL server and DBCC Checkdb

New Company and new to Amazon RDS. Several databases have been migrated to the cloud because "everything" is done for us a manager has stated. I have explained standard DBA tasks are still required ...
0
votes
1answer
100 views

Adding index only on read replica of MySQL RDS instance

I have created read replica of RDS production database for reporting purposes. Cross-team is using the replica for their use. Consumers of this replica are looking for additional indexes for faster ...
0
votes
0answers
18 views

estimating I/O for aurora from current mysql rds instance

If I have the following averages over the last 4 weeks for mysql rds instance db 1 77.7 writes/second, 8.54 reads/second db 2 108 writes second, 8.56 reads/second (2629746 = seconds in a month) ...
0
votes
0answers
153 views

Cannot revoke permissions or drop user in PgSQL AWS RDS

I want to drop the user asd from the DB. So, I've got two DBs: foo and bar and the user apparently has dependencies in both. The DBs have been created from the root user postgres, but all tables and ...
0
votes
0answers
21 views

MySQL DB Migration from on-premises to AWS through replication

I am having a production MySQL server with set of 20 databases in on-premises server. Now I require to migrate few databases from production server to AWS RDS without disturbing other databases in one-...
1
vote
0answers
109 views

AWS Aurora Database Corruption

I'm running Aurora Postgres and noticed that metric Maximum Used Transaction IDs is increasing a lot. Trying to manually vacuum the tables that's was not automatically vacuumed lead me to the ...
0
votes
1answer
36 views

Loss of 20+Gb of space and cannot find out why (amazon mysql rds)

I am trying to figure out why one of my MYSQL RDS DB instances lost 20+GB of storage space and I cannot figure out why. I have 2 RDS instances and am using some queries to compare data + free data ...
0
votes
1answer
108 views

Installing extension as non superuser on Amazon AWS RDS

I would like to allow non super users to install a specific postgres extension. Accordingly to the documentation at https://www.postgresql.org/docs/current/extend-extensions.html that is possible if I ...
0
votes
1answer
162 views

Postgres 10.5: Granting full schema access to a user that isn't the owner

So the underlying problem I'm having is trying to migrate my on premise Postgres 10.5 instance to RDS. RDS does NOT give end users the SuperUser role so I'm hitting tons of permissions issues when ...
0
votes
1answer
26 views

Increase in number of temp files being generated after increasing checkpoint_timeout

I have pgbadger set up to analyze the log files from my postgres db. I recently changed a couple of parameters in my postgres config. I changed the checkpoint_timeout from the default value of 300 ...
0
votes
1answer
66 views

Some queries not logging using RDS's SQL Server with C2 Auditing enabled

Similar to a past issue I had with audited queries not showing when using Extended Events, I'm having an issue with queries not logging when using C2 Auditing on an RDS SQL Server instance. (I would ...
1
vote
0answers
31 views

How to backup a local database to cloud database?

I am about to start developing a POS software as my new project with python and electron js. It is going to be a desktop application. However, my concern is it should work in both cases when desktop ...
0
votes
1answer
68 views

Are the MariaDB and MySql drivers interchangeable when connecting to a MySQL backend Aurora cluster?

I saw a similar question asked before but I didn't get enough supporting information Does anyone know any new information on this? Can MariaDB connector (driver) be used instead of the MySQL ...
1
vote
0answers
31 views

mysql RDS cpu utilization is 90 % above always for less than for 250 connections ( max conn 1236)

I'm using mysql RDS db.m3.xlarge( 4 vcpus, 15G Ram). max_connection limit is 1236 but cpu is used more than 90% for less than 250 connection. I don't know what I'm struggling to find reason. Please ...
3
votes
3answers
575 views

MySQL in AWS RDS 100% CPU on some queries

I have a managed MySQL (5.7.19) instance on AWS. In general, things work pretty well. I'm consistently around 4% CPU usage, and well below my IOPS limits for the burstable instance (t2.micro). ...
0
votes
1answer
193 views

mysqldump from AWS RDS slowing down

Im taking a db backup from AWS RDS (MySQL) slave from an EC2 (m5.large - 2c/8GB) in same AZ using - mysqldump -hxx -u xx -p --extended-insert --single-transaction --max_allowed_packet=1G db > ...
6
votes
1answer
465 views

What is the apgcc schema in Amazon RDS Postgresql?

Recently a mysterious new schema called apgcc appeared in every database in our testing Aurora Postgresql cluster (eu-west region). It is owned by the rdsadmin account. What is it, and where did it ...
0
votes
0answers
73 views

Can an Amazon RDS SQL Server link to an RDS MySQL server?

Amazon RDS for SQL Server supports linked servers, but the doc page only describes linking to other SQL Servers. I would like to link to an RDS MySQL instance, but this normally involves installing ...
0
votes
1answer
13 views

Do I need SQS queues to store remote data in the Amazon Web Services (AWS) cloud?

My first question is, do I need SQS queues to receive my remote data, or can it go directly into an Amazon cloud storage solution like S3 or EC2? Currently, my company uses a third-party vendor to ...