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
27 views

MYSQL storage increasing unexpectedly (RDS)

I am total newbie to database game. & I am using mysql 8.0 RDS 20GB free tier. I don't have much data on it.(just 300 Mb) But I always get a mail that you have exceeded 85% of storage limit.(...
1
vote
0answers
16 views

Storing Analytic Data for Multi-Tenet SaaS with AWS Aurora [closed]

I have an app that a user can upload an excel sheet of analytics data to S3. I am wanting to trigger a Lambda function on upload to do some data processing and then write the analytics to a client's ...
0
votes
1answer
24 views

AWS RDS MySQL some time get slow performance when update table1 set field='any word' where primarykey=1234

Normally when update table1 set field='any word' where primarykey=1234 take 1sec. or less but sometimes random take much more time possible 500sec. or more. I was set very well and never see high CPU,...
1
vote
2answers
65 views

MySQL 8.0 table with JSON column that uses JSON “merge” operations has 500k rows but analyze table shows 7MM

I have a database table that according to TABLE STATUS has 7MM rows, but when I SELECT COUNT(*) it only has 500k rows. This is a problem because table growth is increasing and we're running low on ...
3
votes
2answers
54 views

Why is creating and dropping a random index fixing this performance problem?

I have a big heap table with 17,093,139 rows. This table is the most heavily used table in the database. Since this is a heap table, there are only non-clustered indexes in this table. I rebuild/...
0
votes
1answer
21 views

( RDS ) MySQL to MySQL migration within aws [closed]

RDS MySQL to MySQL migration I've 2 MySQL(5.7) RDS instance in my AWS account namely prod & dev. My task here to migrate all objects from Prod instance to Dev in order to make sure all prod ...
0
votes
0answers
4 views

scaling aws RDS with instant read

Question : How do I scale a DB, in which I'm doing instant reads a lot! (i.e just after writing/update I'm trying to read the same) I'm using AWS RDS and in production. currently having just one ...
0
votes
1answer
22 views

Storage problem with MYSQL read replica

I have one master RDS instance of 50 GB storage and created a read replica of the master DB with the same configuration. I use this read replica only for SELECT operations nothing else. But suddenly ...
0
votes
1answer
29 views

How to get a breakdown of CPU usage at each point in time?

I have a SQL Server RDS instance, running on a db.m5.xlarge (4 vCPU, 16GB RAM) with Multi AZ enabled. I am trying to determine the cause of a constant 25%-30% CPU load on the instance at a time when ...
2
votes
3answers
53 views

RDS MySQL 5.7 help with maximum memory usage is dangerously high [closed]

Anyone can help me out with this MySQL 5.7 server configuration please? I'm running a db.m5.2xlarge rds instance to host 5 e-commerce separate databases and running MySQLTuner against it gives me the ...
0
votes
1answer
27 views

How should we give privileges/permissions to group to access different db's

I'm new to working on RDS postgresql instance, I've a group and added a couple of users to the group. I need to give permission to users in the group to allow them to access other dbs like x ,y and z ...
0
votes
1answer
11 views

High write IOPS on MySQL instance

I posted this first in the aws forums before i learned that there's a stackoverflow for DBs but i would ask this here as well. We recently took over management of a wordpress site using a MySQL DB ...
1
vote
0answers
28 views

Performance issues after PostgreSQL v12 upgrade

Just upgraded our RDS instance to v12.2 from v11.6, and we are seeing some of the queries are performing much slower than v11.6 instance. After the upgrade, we rebuilt the indexes using - REINDEX ...
0
votes
0answers
41 views

In 8.0.17 EPSG Spatial reference systems are not available at installation? [duplicate]

In 8.0.17 INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS is not prepopulated with ORGANIZATION="EPSG" records, leaving the table with only a single record, that for the default SRID=0. A count in ...
0
votes
0answers
41 views

What is the difference between Aurora Mysql 5.7.x and Aurora 2.x.x

I have an RDS instance with Aurora Mysql 5.7.12 and I noticed that there are other versions of Aurora Mysql 5.7, but I don't understand what is the difference between them. Some of the version ...
1
vote
1answer
45 views

MySQL version 5.6.35 RDS DB Instance crashed with error code 6

DB instance is running on MySQL version 5.6.35 Please see below for more details... Is it a bug in this version which needs an upgrade to a later version or there is something to look at the memory ...
-1
votes
1answer
22 views

Connecting to RDS MySQL from command line sometimes fails — why?

I have used RDS for many years, and MySQL for even longer, so I am very familiar with both -- yet, I am running into an odd thing that I cannot figure out. Wondering if someone can help. I have 2 ...
0
votes
0answers
12 views

AWS RDS Fine Grained Access Control using IAM Authentication

Is it possible to limit a users access to specific 'databases' within an RDS DB cluster using IAM authentication? Looking at this documentation I can't see any obvious Conditions that would allow ...
0
votes
0answers
26 views

How to check RDS MySQL database synchronization status

We were creating a read replica for an RDS MySQL (5.7.28) instance, and before the read replica became available one of our developer accidentally connected to the read replica and was able to write ...
0
votes
1answer
30 views

Grant privileges to tables in all (dynamic) schemas

We've setup an AWS Database Migration Service which migrates schema and tables from multiple sources. The rule for migrating from source can be a wildcard on schema, meaning a schema could 'pop up' ...
0
votes
0answers
14 views

Monitoring alert logs of Aurora and RDS postgres instance

I need to have a automation to grep the errors and receive a notification email around those errors in RDS and Aurora instances. What is the best way to approach this?
1
vote
2answers
39 views

Wordpress UPDATE queries on MySQL database stuck

I have an Amazon 24XL server 96 Cores 378 GB RAM Database size 5.7G Debian GNU/Linux 9 (stretch) PHP 7.3.16 mysql Ver 15.1 Distrib 10.3.22-MariaDB I have only one WordPress site where users read ...
1
vote
1answer
19 views

Speed up AWS PostgreSQL insertion via Python script

I have 120,000 csv inside my AWS EC2 instance, each containing 120,000 rows. I can't insert each of them as is into my AWS RDS postgresql DB, that will be 120,000^2 = 14,400,000,000 records. Each csv ...
0
votes
0answers
16 views

MYSQL query working fine in AWS RDS instances with 1 vCPU but hangs if running in instances with 2 vCPU or more

I have this following SQL query below executed in a Lambda function. The Lambda function connected to AWS RDS running MySQL 5.7.22. When this query is executed against an instance type db.t2.small ...
1
vote
1answer
27 views

How to measure amount of MySQL 8 INNODB table used to store blobs?

I'm trying to understand a discrepancy in the file size on disk of my tables and the size of the information stored in them. I'm using MySQL 8 hosted on RDS (InnoDB, one file per table), so getting ...
0
votes
1answer
22 views

Error when restoring Postgres Database on RDS

I am following this to restore an externally backed up Postgres DB onto my RDS instance - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Procedural.Importing.html However, when I ...
0
votes
1answer
20 views

What are the differences between the first and subsequent rds_superusers in an AWS RDS Postgres Instance?

I have been asked to provide administration of an existing RDS Postgres instance. The AWS admin has created a new user for me and has added the rds_superuser role to it. But this user with the ...
0
votes
0answers
12 views

Redash metadata DB migrate

I am using Redash v5.0.0 and PostgreSQL for metadata in an EC2 instance. I can create Redash v8.x container on ECS and PostgreSQL on RDS, however how can I migrate metadata in EC2 for Redash v5 to RDS ...
0
votes
0answers
30 views

How to migrate tables with defaults, constraints and sequences with AWS DMS for postgres to postgres migration?

I recently did a migration from a RDS postgresql to Aurora postgresql. The tables were migrated successfully but the tables are missing their defaults, constraints and references. It also did not ...
0
votes
1answer
12 views

RDS Does Not Allow Restoring MS SQL DB from S3

I have a question for you folks who might be familiar with the intricacies of restoring a .bak file from S3 to an AWS RDS MS SQL instance. Here is what I have tried, and how far I have gotten: First ...
0
votes
2answers
42 views

PostgreSQL slow query log entries contain no query details, only duration

I have a PostgreSQL RDS instance hosted in AWS. I have set the log_min_duration_statement setting to 1 second. When checking my log for slow queries I found the following six entries which don't ...
0
votes
0answers
4 views

Will multi-AZ RDS provided by AWS always have 2 databases?

I have a database in AWS RDS with the multi-AZ feature available. I had tested the failover also to understand it's working. But my doubt is this: During the failure of the primary database, the ...
1
vote
0answers
28 views

Difficulty Optimizing Postgres Write Throughput

I'm trying to index a collection of roughly 127K files using a PostgreSQL 9.6 server on RDS. I had expected the process of writing these documents to the DB to take about 8 hours, but over time I ...
0
votes
0answers
8 views

Do I need Provisioned IOPS for AWS RDS if I only need 3000 IOPS?

I have an application currently with RDS as its database. Right now I have configured it with an r5.large machine that has 16GB of RAM, 100GB Provisioned IOPS SSD storage, etc and the Provisioned IOPS ...
0
votes
0answers
8 views

How to check locked tables at specific time

I got error on my cron "(1205, 'Lock wait timeout exceeded; try restarting transaction')" I want to check during that time (midnight), what query/process that locked my table. I have general_log ...
0
votes
0answers
24 views

Imported database very slow on a simple query

A production database has been exported to a separate location for various reasons, however the dumped/imported database is performing much slower on some very specific queries. Here is 2 queries on ...
1
vote
2answers
87 views

Finding cause of high write IOPS on RDS Postgesql

Our RDS Postgresql 9.6 instance has had an unusual instance of high write IOPS. Write iops went from an idle level of ~10 to over 4000 (our provisioned level) yesterday evening, and stayed at that ...
9
votes
1answer
298 views

MS SQL Express 2016 on Amazon AWS: I Can Take Database Offline but Can't Bring It Online

I can take databases offline (via GUI) but can't bring them back online. The server details are as follow: RDBMS: MS SQL 2016 Express Host: Amazon AWS/RDS Free Tier Details/History of the Problem A ...
2
votes
2answers
75 views

Permission denied when trying to install sp_blitz on in the master database in Amazon RDS

I am trying to install sp_blitz on AWS RDS SQL Server (14.0.3223.3) standard edition and getting following error: Msg 262, Level 14, State 18, Procedure sp_Blitz, Line 1 [Batch Start Line 0] CREATE ...
0
votes
0answers
47 views

In Amazon RDS, how does one enable PLV8 extension?

I see it is available. Just can't find the right documentation to help me enable it. From the docs, I entered the following command and got: postgres=> select * from pg_available_extensions where ...
1
vote
1answer
25 views

Linked server not working after AWS RDS failover

Linked servers created on AWS RDS to other instances is not working after RDS instance failover. Error we get is "An error occurred during decryption". This is similar issue reported, but no ...
0
votes
0answers
100 views

Fast long-to-wide reshaping in PostgreSQL

I am trying to change a really long table (1955451890 rows -- 278 Gb on the DB) to a wide format using crosstab from the tablefunc extension. Following several examples from SO (i.e. Crosstab with ...
0
votes
1answer
16 views

AWS RDS : Setting Create and other grants only for single Database is not working

We are using AWS RDS Mysql, and we are trying to give SELECT access to all databases i.e RO only, but for a single database, we want to give all permissions i.e CRUD. It's not working out ...
1
vote
0answers
100 views

What does the error means: `SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected (SQL: )`

On my Amazon RDS Postgresql database connection I receive the following error: SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected (SQL: ^sql^) So I try to understand what this error ...
1
vote
0answers
155 views

Does the `hot_standby_feedback=on` may cause `SSL SYSCALL error: EOF detected` error?

On a AWS Master slave hot standby replication schema on Amazon RDS with a single master and a single slave. Both master and replica are being hosted over Amazon RDS on eu-central-1 and the master is ...
0
votes
1answer
115 views

MySQL 8.016 master with MariaDB 10.2 slave on AWS RDS, Character set '#255' is not a compiled character set

I have a MySQL 8.016 master and a MariaDB 10.2 slave, both running on AWS RDS. This was working perfectly until today, when I figured I wanted to do chain replication instead, like this MySQL 8.016 ->...
1
vote
2answers
38 views

Postgresql low performance with max and min (wrong index?)

I'd appreciate some help here, I'm new with Postgresql and don't fully understand what's happening here. I have the following table: history=> select * from last_sales.store01 limit 5; ...
0
votes
1answer
46 views

Limiting user access by subnet to Amazon Aurora PostgreSQL

How do I limit user access by IP? For example, assuming I have two non-superusers (user1 and user2), how can allow general access (only limited by security groups) to the instance/cluster by user1 but ...
0
votes
2answers
104 views

Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4

I have thousands of columns across hundreds of tables in about a hundred databases inside a MySQL instance that need to be upgraded from utf8mb3 to utf8mb4. Is there a way to generate ALTER ...
0
votes
2answers
30 views

Optimization: Increase Innodb_pool_size useful?

We run an AWS RDS instance with 8vCPUs and 64GB memory. All tables are using InnoDB engine. I have kept the default setup of innodb_pool_size to be half the memory. What I see is that almost 30Gb of ...

1
2 3 4 5
14