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
0answers
4 views

Should Amazon RDS SQL Server 2017 Web Edition Max Memory settings be different from that of a locally installed instance?

We have an Amazon RDS SQL Server Web Edition on Windows Server 2012 with 2 processors and 8GB RAM. Should I configure the Max Memory similar to that of an instance on a local server i.e keeping back 3-...
0
votes
0answers
25 views

AWS aurora mysql is restarted unexpectedly

In our system one of aurora mysql instances was't available for short period. because this instance suddenly restarted at 08/14/2019 3:56JST. we already checked error log for aurora. but i found ...
0
votes
0answers
18 views

Amazon RDS instance recovery during mysqldump

I have a db.t2.small read replica, which crashes every time I run mysqldump. The issues started after I made some table changes - my main suspicion is the use of InnoDB. This replica is used as a ...
0
votes
0answers
16 views

PostgreSQL managed by AWS RDS - rdsadmin maxusedtransaction ID not shrinking

We are using AWS RDS Postgres. We reached the 200 million limit on one of the DB and triggered VACUUM FREEZE which took down the instance for roughly 40mins however the XID didn't shrink at all. We ...
0
votes
0answers
27 views

Postgres uses sequential scan with OR condition, but index scan with AND condition

We are doing a full text search on an object. Unfortunately, the object is normalized across different tables, and the full text search results in a condition with several OR, because the term can ...
0
votes
0answers
26 views

Grant Privileges on Production Database Throws “Error: tuple concurrently updated”

I would like to grant read access to all tables in my schema GRANT SELECT ON ALL TABLES IN SCHEMA public TO XXX; While it works on our alpha environment, it fails with our production database: [...
0
votes
0answers
3 views

How to restore data in aws rds without snapshot

Suppose I have snapshot at 9 AM and the data crashes at 3 PM and I want the data till 2:55 pm. How to restore data till 2:55 PM. Is there any method .if so how to do that.
0
votes
0answers
11 views

mysql.rds_history query locked for 70 seconds

SELECT count(*) from mysql.rds_history WHERE action = 'disable set master' GROUP BY action_timestamp,called_by_user,action,mysql_version, master_host,master_port,master_user,...
0
votes
0answers
28 views

Set slave_exec_mode value for RDS

I am trying to figure out a way to set slave_exec_mode to idempotent on Amazon RDS. I've checked the parameters associated with created DB instance on Amazon Console, but this parameter is not exit ...
0
votes
0answers
21 views

AWS RDS mysql deadlock

Everything in our production environment was working well. Yesterday, suddenly out of no where we were getting "lock wait" on any transaction related to a specific row. Same transaction on another row ...
0
votes
0answers
7 views

How to find the master instance of a read replica in AWS RDS PostgreSQL?

I have an RDS Postgres instance whose role is Replica. I do not see the master in the same region and probably is in another region of the AWS account. How do I find the master for this replica? ...
1
vote
0answers
14 views

Not able to update innodb_ft_num_word_optimize

We are using a AWS-RDS(MySQL 5.7) instance with 16GB RAM. We have a table with millions of entries and a FULL-TEXT index which needs to be OPTIMIZED. Apparently, FULL-TEXT optimization is very ...
0
votes
0answers
15 views

Major DB operations like table drop, Shrink etc on AWS SQL Server 2014 SE with Multi-AZ switched on

Are there any issues if Major DB operations like table truncation, big amount of data delete or Shrink are performed on AWS SQL Server 2014 SE with Multi-AZ switched on? Should the Multi-AZ switched ...
0
votes
2answers
41 views

Running a task without waiting for the results in Postgres 11 on RDS

I've got a question about spawning stand-alone threads on Postgres. Here's what I'd ideally like: Have a postgres-side solution to automatically launch tasks on a schedule in their own threads. ...
1
vote
0answers
18 views

Using AWS RDS Postgres: Create a superuser with access to all tables (also future created ones)

In AWS RDS (A managed Database service), we cannot create real superusers. There is a user RDS calls Master User, which can create new users, databases, tables, etc. However, when another user has ...
1
vote
1answer
53 views

RDS: permission denied for relation spatial_ref_sys when copying

I am copying tables using ogr2ogr from Oracle to PostGIS. When I run try to load these I get, ERROR 1: ERROR: permission denied for relation spatial_ref_sys when copying <table>@AWS
0
votes
0answers
29 views

Query Optimization - Potential ill effects of adding an full text index to a frequently updated table

We have a query of the following type which we are trying to optimize. SELECT table_one.* FROM table_one INNER JOIN table_two ON table_two.fk_id = table_one.id WHERE (table_one.h_id = 20626 AND ...
1
vote
1answer
43 views

Understanding BinLogDiskUsage Metric behavior

We are using AWS-RDS. The following is the screenshot of how the binary log disk usage has varied over the last 6 weeks. The log retention period is 3 days. Tables are optimized and archived once a ...
3
votes
1answer
95 views

Unexpected failover of RDS-MySQL server

We have a 16GB RDS-MySQL Multi-AZ instance. Of late, it has unexpectedly failed over multiple times causing the dependent application to be offline for over 15 minutes. AWS-Support blamed it on high ...
2
votes
0answers
15 views

Is it possible to create AWS RDS as replication from external server?

I can't find any tutorial to create a new instance of AWS RDS (MySQL) to be an replication db from an external db server. Is it possible to create one? Thanks.
0
votes
1answer
58 views

Postgres - Vacuum doesn't complete on large/busy table

We have a decently active PG database hosted on AWS. We recently started getting notifications like the following: Transaction ID age reached 750 million. Autovacuum parameter values for [...
1
vote
1answer
45 views

Amazon RDS MySQL Troubleshooting High Sessions

I just migrated my forums application to AWS. I'm in the middle of tweaking things for performance and I noticed that the number of sessions for my RDS instance (t3.large) is consistently exceeding 2....
1
vote
1answer
96 views

How to sync easily between a master database from Google Cloud SQL and a master database from Amazon RDS

I've created a master - slave (replication) in Google Cloud SQL. I've also created a master - slave (replication) in Amazon RDS. I want to sync two master MysQL from Google Cloud SQL and Amazon RDS....
1
vote
0answers
38 views

Separate login during `Too many connections` in AWS RDS

AWS-RDS does not provide any user with SUPER privilege. As a result, 'too many connections' are made, even the dba is locked out. Nobody can login and kill any sleeping connection. Apart from taking ...
0
votes
0answers
37 views

Copying SQL logins and roles into AWS RDS

I am migrating SQL Server 2017 running from EC2 instance to AWS RDS SQL Server. What would be the best approach to migrate logins with SIDS, passwords, server roles, and database roles? I know the ...
0
votes
0answers
17 views

MySQL - Granting a user access to view an existing stored procedure [duplicate]

I have a user that has been granted ALL schema privileges in a MySQL database however they are unable to view existing stored procedures that another user owns. How do you grant a users the ability ...
1
vote
1answer
135 views

AWS RDS (PostgreSQL) - Master user lost all privileges after upgrading from v9.6 to v10.6-R1

I just upgraded my AWS RDS DB instance from Postgresql v9.6 to v10.6-R1. I did this manually using the "Modify" tab in the Databases section under the Dashboard. Immediately afterwards, as the master ...
8
votes
0answers
457 views

UPDATE STATISTICS options fail in Amazon RDS SQL Server

In Amazon RDS SQL Server (any version/edition), create a temp table and update statistics on it. This works fine: IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t; GO CREATE TABLE #t (id INT ...
0
votes
0answers
189 views

how to dump mysql schema without keys and without constraint ? and keep all of them to alter afterwards

i am using ubuntu 16.04 and want to dump large schema with hounded of tables from AWS rds, remove all keys and foreign key , load data and then add back the keys , is there any automatic tool that ...
0
votes
2answers
142 views

AWS KMS Encryption enable for SQL Server Columns?

Is it possible MSSQL on EC2 with a key in AWS KMS to encrypt columns
4
votes
6answers
536 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
144 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
88 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
208 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
50 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
130 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
173 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
196 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
40 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/...
1
vote
0answers
89 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
467 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
77 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
36 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
40 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
139 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
20 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 ...
3
votes
1answer
213 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
340 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
100 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
65 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://...