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
1
vote
0answers
241 views

MySQL denied user from SELECT

I have a MySQL database running on AWS RDS. I also have a process which runs a SELECT query from a server called SOME_EC2. "SELECT command denied to user 'myuser'@'SOME_EC2_HOSTNAME' for table '...
8
votes
1answer
3k views

Why do I get a PostgreSQL permission error when specifying a tablespace in the “create database” command?

When I create a database in PostgreSQL without explicitly specifying a default tablespace the database is created without issue (I'm logged in as the pgsys user): postgres=> create database rich1; ...
1
vote
1answer
37 views

Guideline for MySQL free space

What is the guideline for how much free space to keep available on a MySQL AWS RDS instance (SSD)? In the past for an on-premises SQL Server install we used to use something like 2x the largest table ...
0
votes
2answers
75 views

Multiple DB restore in sequence

I am restoring several MariaDB databases into a Amazon AWS RDS MariaDB instance from an AWS EC2 machine in the same VPC / region etc. I am using a shell script like so: mysql -u root -h hostname....
4
votes
1answer
564 views

Why RDS PostgreSQL `MaximumUsedTransactionIDs` not decreasing even after data base seems correctly `VACUUM FREEZE`'d?

My MaximumUsedTransactionIDs seems to keep growing indefinitely, but I have these evidences hinting me it maybe should not be happening that way: $ PGPASSWORD=$MY_USER_LAND_RDS_SUPER_USER_PASSWORD ...
1
vote
1answer
238 views

After adding indexes to an AWS RDS MySQL DB getting huge/crippling spikes in IOPS

So after looking at the production database, I realised that several queries were running utilizing no indexes at all, and as such, were row-scanning close to 4 million rows. :/ I added the required ...
0
votes
0answers
210 views

Migrating on-prem MySQL 5.5 databases to AWS RDS MySQL 5.5

Migrating on-prem MySQL 5.5 databases to AWS RDS MySQL 5.5 Background Information: I have a MySQL 5.5 dump. I have migrated the same dump to an EC2 instance and it worked. I did restore to EC2 ...
1
vote
0answers
72 views

Improve qps for postgres write

I am trying to improve the performance of my postgres instance in aws. I am using aws rds db.t2.large Here is my table structure CREATE TABLE public.my_test ( test_index1 text COLLATE ...
2
votes
0answers
285 views

MySQL delete gradually locks more and more rows

I've encountered a strange problem that I can't explain. MySQL 5.6.34, RDS. Basically, some delete from table where id in (...) queries are locking up indefinitely, but never truly deadlocking. I ...
0
votes
1answer
63 views

MySQL Queries to get only runtime/duration, not fetched results

We are running few benchmark queries against our test RDS instance for checking efficiency of partitioning, before adapting it to production, where there is no partitions presently. We have few ...
1
vote
1answer
2k views

Necessity of having two instances (Reader and Writer) in Amazon Aurora

I'm managing an Amazon Aurora account. Somebody set it up months ago. The service has TWO instances (same AZ): - project - project-eu-central-1b Same class (db.t2.small), but different "Replication ...
2
votes
1answer
2k views

How to set the default timezone in PostgreSQL on Amazon RDS?

The default timezone is currently set to UTC. How to replace that default value? I am using PostgreSQL running on top of Amazon RDS
0
votes
0answers
384 views

Once daily AWS Postgres CPU spike caused by mysterious “OS processes”

We've been experiencing huge CPU usage spikes on our Postgres 9.6 AWS RDS so the point we've had to upgrade to a cost prohibitive instance just to handle these once daily spikes. This spike always ...
4
votes
2answers
508 views

Support for libprotobuf-c on Amazon RDS

I created a PostgreSQL 10 instance on Amazon RDS with the PostGIS 2.4 extension in my database enabled. I want to test the performance of Amazon RDS as a dynamic vector-tile server. This hinges on ...
3
votes
1answer
590 views

SELECT COUNT(*) returning incorrect results

I am seeing some very strange behavior on PostgreSQL 9.6.3 on RDS Aurora. I am getting duplicate results from certain queries: => select count(id) from foos where id = 'deadbeef'; count ------- ...
0
votes
1answer
55 views

AWS RDS MySQL database created but cannot create indexes or change collation

AWS RDS MySQL 5.6.x issue: Created a MySQL database on the AWS RDS platform. Created a dozen tables, imported data to all tables and can SELECT from all tables. Granted all privileges to user on ...
3
votes
1answer
3k views

How do you monitor slow query in AWS RDS Postgres

My RDS Postgres has 5 read replica and it's the maximum number of read replica and cannot scale out by increasing read replica. In this situation, some of the read replicas occur too much high CPU ...
1
vote
2answers
746 views

What's the difference between --read-only and just permit SELECT queries?

I'm using Amazon Aurora and I have two endpoints, my endpoint which can read/write are having some issues to execute queries, these are the issues: SQLSTATE[HY000]: General error: 1290 The MySQL ...
2
votes
0answers
326 views

Amazon AWS RDS 120GB free storage suddenly became 0GB within less than 2 hours

I've been using AWS RDS db.m4.large with 128GB storage for MySQL(InnoDB) for more than one year now. The size of my database is now less than 2GB and the free storage had always been more than 125GB ...
-1
votes
3answers
563 views

Should I spread many connections over a period of time, or hammer the database at same time?

I currently have a fairly small (micro, but can upgrade if necessary) Postgres db instance on Amazon RDS. I think I have a max connections of about 85 (checked through max_connections value in console)...
0
votes
1answer
730 views

Why is PostgreSQL's auto-explain not working in AWS RDS?

These are my settings: https://collabshot.com/show/6b9f6c According to the documentation, as far as I can tell, this combination of settings along with a statement_timeout value of 3600000 should ...
1
vote
1answer
250 views

Why is AWS RDS' maximum auto_explain.log_min_duration parameter 214783?

That seems like a really arbitrary number of milliseconds to use as a maximum. What can I do if I want to log even longer-running queries on a data warehouse? C.f. https://collabshot.com/show/83dd1e
3
votes
0answers
1k views

RDS Aurora 5.6 died (randomly?)

Aurora MySQL 5.6.10a I can see these events in the console: February 20, 2018 at 4:27:24 PM UTC+11 <server>-production DB instance restarted February 20, 2018 at 4:26:52 PM UTC+11 <server&...
1
vote
1answer
771 views

AWS RDS MyISAM tables from mysql and information_schema and good snapshots

I'm wondering about the topic of moving all MyISAM tables to InnoDB in RDS. Mostly because I have this annoying warning every day in the RDS console. One thing is pretty clear, the tables of the ...
2
votes
1answer
2k views

How to maintain Index and Statistics on AWS RDS?

In the process of setting up the SQL Server Index and Statistics Maintenance code on our AWS RDS instance, I've managed to set up the scripts and can run it from SSMS. Please advice on how to setup ...
1
vote
1answer
207 views

AWS RDS (mysql) strange IO behavior

I'm dealing with s db.r3.4xlarge RDS instance with 2000GB all purpose SSD (theoretically capable of up to 6000 IOPS), I'm restoring a bunch of table backup files of over 200GB. There are 26 ...
2
votes
1answer
299 views

Effect of over allocating shared_buffers

I have a 9.6 PostgreSQL RDS instance that I am tending to, but did not initially configure, and have been struggling with two different symptoms: the system (a db.r3.2xlarge w/ 61GB memory) would ...
1
vote
1answer
368 views

MySQL 5.6 Bug Amazon RDS with replica. AFTER INSERT TRIGGER is not working. Solutions?

I have MasterDB and ReplicaDB in Amazon RDS environment. I need to move 1 table (MYTable) from replica to other external DB (ExternalDB). My solution (do not work) was to add a AFTER TRIGGER ...
2
votes
0answers
700 views

RDS (MySQL): Swap usage growing but plenty of freeable memory?

We run a db.m4.10xlarge instance on Amazon's RDS. It runs 3 fairly busy databases and has a replica instance connected to it. Over the last few weeks I noticed the swap usage has been steadily rising ...
1
vote
0answers
189 views

AWS RDS PostgreSQL Storage

One of my AWS RDS PostgreSQL instance is consuming too much storage even though there is no activity going on the Database. I have logical_replication switched ON, to use AWS DMS to replicate DBs to ...
2
votes
1answer
1k views

The CPU utilization spikes to 80+ even with just one user on Amazon RDS (MYSQL INNODB)

These are my RDS instance configs Instance Class: db.m3.xlarge Storage 40 GB Engine MySQL 5.6.34 Multi AZ : No I have a the node.js based backend hosted in EC2 instance and also have a cloud front ...
2
votes
0answers
495 views

Spike in AWS RDS Oldest Replication Slot lag

Does anyone know about this "Oldest Replication Slot Lag" in AWS RDS? What does it represent? I have a PostgreSQL instance on RDS (with Logical Replication switched on) for transferring data from ...
3
votes
1answer
534 views

Postgres occasionally slow to query

I'm running a database with a few tables with large row counts (millions) but which are fairly small in data size. All the tables are append-only, so no deletes or updates ever happening, around 250 ...
1
vote
1answer
402 views

Moving a PostgreSQL database to a different AWS RDS instance

I have an AWS RDS instance with multiple PostgreSQL databases in there including an application database and a monitoring database. The problem is that the monitoring database is consuming lots of ...
4
votes
1answer
11k views

Multiple databases in same AWS RDS PostgreSQL instance

I have an existing database in a RDS AWS PostgreSQL instance. I need to create one more database in this instance as spinning up a separate cluster will be expensive. There doesn't seem to be any ...
0
votes
0answers
358 views

AWS RDS POSTGRES - Japanese/Chinese Full Text Search support

I have a requirement to support FTS (Full Text Search) of Japanese and Chinese on PostgreSQL. I am aware that there are extensions to handle this however AWS RDS PostgreSQL appears to restrict the ...
0
votes
1answer
132 views

Create a New AWS RDS Instance of only one database from a snapshot

I'm trying to Create a new AWS RDS SQL Server instance of only one database from a snapshot. I've gone through the AWS documentation, but according to it when I restore from a snapshot it will create ...
1
vote
1answer
300 views

PostgreSQL: Running SELECT DISTINCT ON ~700m rows - how to optimize?

I have a table that, if we look at just the relevant parts, has two columns: id and raw_data. id is an integer, and raw_data is a text blob. At this point, the table has no constraints or indexes ...
0
votes
0answers
870 views

NLShimImpersonate Error 5023 - SQL Server Express - AWS RDS

I'm seeing a ton of these security_error_ring_buffer_recorded, error 5023, events in my AWS RDS SqlExpress instance. I noticed this while trying to investigate timeout errors I started getting in my ....
4
votes
1answer
1k views

Failed to create instance: Standalone DB Instances are not supported for Amazon RDS Aurora

Question What is the cause of Failed to create instance: Standalone DB Instances are not supported for Amazon RDS Aurora? Run the ansible script to create RDS Aurora but getting the error. If "aurora"...
1
vote
1answer
871 views

copy an exported dump file to a target DB instance - LOG

I just imported data into an Amazon RDS DB instance using this guide http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html But in the source DB the number of tables ...
0
votes
1answer
782 views

Errors encountered while Dump/Restoring PostGIS DB from Postgres on EC2 into RDS

I am migrating from a manually managed database on Postgres 9.4.10 and PostGIS 2.1 to an RDS instance on Postgres 9.4.9 and PostGIS 2.1. The restore seems successful, but the output gave me 27 ...
0
votes
1answer
2k views

pg_dump permission denied for sequence

I have a strange issue with dumping post-data section. Dump command is: pg_dump -Fc --verbose --section=post-data --no-owner --no-acl -h localhost -p 9999 -U root db_name -W > constraints.dump ...
0
votes
1answer
198 views

Amazon Aurora MySQL5.6 Performance Schema column datatype modified and can't be corrected

I'm having trouble getting performance_schema to work in a few of my Aurora instances. Brand new instances where I enable performance_schema work just fine, but several instances that I've had for ...
6
votes
1answer
2k views

Diagnosing high write throughput on RDS Postgres

I'm using Postgres 9.6.1 on RDS, and seeing orders-of-magnitude higher write throughput than I expect to see. I'm seeing a WriteThroughput around 40,000,000 Bytes/Second. I've looked at the ...
13
votes
2answers
1k views

Neither DBCC FREEPROCCACHE nor DBCC FREESYSTEMCACHE('SQL Plans') do anything to free CACHESTORE_SQLCP memory

CACHESTORE_SQLCP Sql Plans takes up > 38 GB after a few days. We are already running with "optimize for ad hoc workloads" option on. (Entity Framework and custom reporting creates a lot of ad hocs!) ...
8
votes
0answers
522 views

Why does RDS PostgreSQL always recover on restart?

I am running an RDS instance of PostgreSQL 9.6.3: select version(); returns PostgreSQL 9.6.3 on x86_64-pc-linux-gnu [...]. I have found that after issuing a stop from the RDS console followed by a ...
1
vote
1answer
329 views

Error ERROR 1153 (08S01) during mysqldump restoration on Amazon RDS

I am trying to import a table on an Amazon RDS server using mysqldump. During restoration, i get the following error message: ERROR 1153 (08S01) at line 925: Got a packet bigger than '...
1
vote
1answer
1k views

AWS RDS many connections cause “lock up”

I run a fairly standard LAMP stack with an Amazon RDS database on a t2.small instance. Today I was alerted through Website monitoring that the database seemed to have "locked up" completely. The ...
4
votes
3answers
2k views

Postgres to Postgres DBLink with AWS/RDS

I am trying to use dblink functionality for Postgres 9.5.2 DB to Postgres 9.52 on AWS/RDS. On the server: CREATE SERVER myremotedb FOREIGN DATA WRAPPER dblink_fdw OPTIONS (host 'myremotedb....