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

Deploying schema changes to AWS RDS hosted Databases

With a database hosted in AWS's RDS, the database is only accessible externally if publicly accessible is set to true and the relevant ingress rules are configured to allow connection from a known ...
0
votes
0answers
13 views

MySQL: Configuring the right innodb_buffer_pool_instances and innodb_buffer_pool_chunk_size on RDS with huge RAM

We are on a db.r4.8xlarge MySQL (version 5.7.23) AWS RDS instance with 16 cores, 32 vCPUs, and 244GB RAM. We set the Buffer Pool Size to around 144GB at the default innodb_buffer_pool_chunk_size and ...
1
vote
1answer
22 views

AWS MySQL RDS: Swap Usage but high Freeable memory

We have an AWS RDS with a MySQL database. Buffer Pool size is only 144GB out of the total available 244GB RAM. However, even at such a low RAM config, we see Swap Usage happening. Does anyone have any ...
0
votes
1answer
14 views

How can I determine what's a better configuration for my app? [closed]

I'm currently using Postgres 12 on AWS RDS and am using their default configuration for the database. I use a gem called PgHero that advises me to use PGTune to improve the efficiency of the database. ...
0
votes
0answers
22 views

Rolling back transaction with trx_mysql_thread_id of 0 create deadlocks on update

I'm using MySQL 5.6.41 on AWS RDS. I have seen, recently, lot of transactions ending as deadlocks. Using SELECT * FROM information_schema.innodb_trx; I found that a transaction was always there. +-----...
0
votes
0answers
13 views

AWS RDS is showing very high wait/synch/mutex/sql/ values and EXPLAIN statements in performance insights

I'm running a CRON script which checks the database for work and executes anything that needs to be done. It does this across ~500 customers per minute, but we are using AWS RDS with a 16 vCPU ...
0
votes
1answer
23 views

Query with big IN clause

I'm having an performance issue with a query, the query is something like: Select * from requests where start_date > {start_date} and end_date < {end_date} and employee in {employee_id_list} ...
0
votes
0answers
8 views

Aurora RDS MySqlException: Unknown database

We have a .NET Core 3.1 microservice running in an EC2 auto-scaling group (7 instances) which uses MySql.Data NuGet package 8.0.18. It connects to an Aurora MySQL RDS cluster in the same account. This ...
0
votes
0answers
31 views

How to export data from multiple tables to csv from remote postgres server (AWS RDS) to local machine?

I need to export data in CSV format from many (undertimined amount) tables from a remote postgres (aws RDS PostgreSQL 10.6) server to a local machine. When the server was in its own machine (AWS EC2) ...
-1
votes
2answers
32 views

RDS MySQL top CPU queries

I'd like to know if there is any way to get the top queries in my instance per CPU. I would see which query has more impact in my instance based on CPU usage. Anyone have any idea if it possible in ...
0
votes
0answers
8 views

Export an Amazon Lightsail DB without putting your website down

I would like to get an offline local copy of my Amazon Lightsail database for debugging. However, the website is live, and starting an export could cause some serious server slowdowns. I usually put ...
0
votes
0answers
20 views

Why does my Amazon RDS Postgres server CTE Scan takes much longer than on my local docker postgres server

I just got put on a project to move the local database to AWS RDS. The Queries work great on the local database, but they are extremely slow on amazon RDS. The execution plan is slightly different as ...
3
votes
2answers
52 views

Monitoring for and dealing with sudden jump in TOAST bloat

I'm trying to diagnose a sudden jump in disk usage in one of my databases (running 11.4). Typically the database grows by ~1 GB per day, but recently in the span of 24h it grew by nearly 100 GB. ...
0
votes
1answer
13 views

MySQL binlog format change from MIXED to ROW

One of my customer has MySQL master-slave setup at on-premises, where the binlog format is kept to be MIXED. Now, we are planning to migrate the DB to AWS RDS using DMS, the binlog format should be ...
0
votes
1answer
48 views

Mysql RDS sending data

I'm facing a big issue working to improve a Mysql query, I've created a covered index in a table which has about 93 Columns, so this index will cover all columns from which will be used in my SELECT, ...
0
votes
0answers
10 views

Manual Binary logging in Amazon's Aurora

How would I enable binary logging in RDS? I get the following error: Binary logging is disabled for MySQL server [1020418] (mysql_endpoint_capture.c:352) What parameters do I need to change in ...
1
vote
1answer
23 views

Restore specific MSSQL backup from media set using AWS rds_restore_database

I have backed up several Microsoft SQL Server databases to a single media set (.bak file). I have uploaded the database to S3 and am now trying to restore the database using the following script where ...
0
votes
0answers
12 views

How restore a Postgres database on AMAZON RDS when the file is in another server?

I'm around 2 days to simply restore my database to an AMAZON RDS server. The tutorial page from AMAZON is so bad that I can't do a simple task like this. I have db_example.bak file on my local machine ...
0
votes
1answer
36 views

Cannot upgrade to v12 due to sql_identifier data type

I am attempted to upgrade Postgres 11.8 to 12.3 on an AWS RDS instance. The upgrade fails with the following error: Your installation contains the "sql_identifier" data type in user tables ...
0
votes
0answers
19 views

Unable to grant privileges with admin account

I'm running MariaDB version 10.4.8 on Amazon RDS. Once the server is up and running, I need to create some databases, users and grant privileges to those users. Creating the databases and users works ...
1
vote
1answer
41 views

Why are my queries in idle state?

I'm new to postgres , I've aws rds instance running postgresql with engine version 11.5. All my queries are clientRead has the wait_event. Why do I have all my queries in idle status.Does this mean ...
0
votes
0answers
12 views

How much time would it take for synchronizing between master and slave in Mysql on AWS RDS?

I implemented Master Slave for RDS Mysql database. The sync time for 1 GB was very less. Can I predict time for 20GB to synchronize? Master DB Slave DB Can I also predict the time and load on the ...
1
vote
0answers
25 views

What does KEY SHARE OF in a PostgreSQL statement mean?

Given the following SQL, what does "ONLY", "OPERATOR(pg_catalog.=)" and "FOR KEY SHARE" do? SELECT 1 FROM ONLY "public"."acmeinstanceinfo" x WHERE &...
1
vote
0answers
15 views

Process with Command 'Killed' and State 'Executing'. Not getting killed

Last day, when I ran a count(*) query on a table. It didn't provide any results. It ran forever even. So I tried killing those queries (I have tried it multiple times). As I'm using AWS RDS, I killed ...
1
vote
0answers
24 views

Is it bad practice to leave the master database at a lower compatibility level after an in-place upgrade? [duplicate]

Based on this documentation, Microsoft intentionally leaves the master database at the previous compatibility level after an in-place upgrade. I recently performed an in-place upgrade from 2012 to ...
0
votes
0answers
8 views

RDS Mysql: Parameter to kill idle transactions

From time to time I see some long-running idle transactions in my MySQL database. I need to set timeout for such transactions. Therefore, I want to know if there is something like PostgreSQL's ...
3
votes
0answers
62 views

RDS MSSQL in-place upgrade how to update master db compatibility level when rdsa account is db owner

Background My workplace infrastructure team ran a typical in-place upgrade of an RDS MSSQL instance to update the version from 2012 to 2017. After the upgrade, while logged in as the "master ...
0
votes
0answers
17 views

Password validation in AWS RDS Postgres database

Is there way we can check/set password validation for PostgreSQL RDS database? like in MySQL we have password validation plugin. How long password should be/password expiration date etc. I have ...
0
votes
0answers
28 views

Connect to RDS from EC2 that uses Elastic IP. Access denied for user

SHORT: I want to access my RDS MySQL from my EC2 instance. The EC2 has an associated Elastic IP address. I associated an Elastic IP address so the EC2 has a static IP. I can create a MYSQL user ...
0
votes
1answer
51 views

Why a query takes too long in statistics thread state in AWS Aurora MySQL?

The following query execution too long in statistics state and I couldn't figure out why. DB engine - 5.7.mysql_aurora.2.07.2 DB Size - db.r5.4xlarge Sample Query Profile output +----------------------...
1
vote
1answer
107 views

High CPU usage with MySQL RDS

I'm running t3.large MySQL instance and having high CPU usage issue. There are tons of data stored and tables in one database. After rebooting the instance everything is pretty good and all of queries ...
0
votes
0answers
33 views

AWS RDS upgrade from 8.0.11 to 8.0.19 fails

I am trying to upgrade an RDS database from 8.0.11 to 8.0.17. or 8.0.19. I started by creating a snapshot, restoring that snapshot, and then trying to upgrade to 8.0.17. The upgrade says it was ...
0
votes
0answers
14 views

Migrating data to new mysql rds instance

I have 1TB size mysql database for production . Now i want to migrate this database on new mysql RDS instance . Please suggest me which backup policy should i apply here like Mysqldump,XtraBackup . ?
0
votes
0answers
7 views

Scalling Down AWS RDS

I have a instance in my AWS RDS running SQL Server, setting up with 16 TB (this is the maximum accepted by AWS), I'd like to change this size to 2TB. Have anyone some idea how can I do it? AWS console ...
0
votes
0answers
38 views

Replication external Master to RDS Slave: Connection issue

I am trying to set up replication between my external database (master) to an AWS RDS database (slave). Both are MySQL 5.6. Please don't mark this as a duplicate. I know others have asked a similar ...
2
votes
1answer
29 views

How does Database Snapshots Work (MySQL)?

I have a MySQL database hosted on an AWS RDS instance. The database has many tables and I observed the following: I picked a table with about 1-2 million records that is indexed on a created_at ...
0
votes
0answers
7 views

MySQL8 leaves railing connections open

We're looking to upgrade our stack from MySQL5.7 to MySQL8. We are using a standard LAMP system on ubuntu16, php7.0 and symfony 2.3 . On our tests, I have noticed that there is a lot of trailing ...
0
votes
0answers
5 views

AWS Oracle Enterprise Edition RDS to Standard Edition RDS Migration

I have RDS snapshot of Oracle EE edition and want to move it to be converted into Oracle SE edition. Please help with the best strategy possible.
0
votes
0answers
17 views

Access Oracle DB from AWS RSD Mysql DB

I have two databases. One is in Oracle and the other one is in AWS RDS MySQL. How can I access my Oracle Database from AWS RDS MySQL Database?
0
votes
2answers
85 views

Change the binlog format MIXED to ROW

I have a database that is running on AWS RDS (MySQl 5.7.22). Currently, I have one master and 2 replicas running. My binlog format is MIXED. I have plans to change it to ROW based. I want to ...
0
votes
1answer
28 views

Migrate Oracle 12c to 18c in AWS RDS

Currently we have an Amazon RDS Oracle 12c instance and we need to upgrade it to Oracle 18c in a new RDS instance. What is the correct approach to do this? Can we set up an 18c instance staright ...
0
votes
0answers
29 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
17 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
32 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
71 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
59 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
23 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
27 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
33 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 ...

1
2 3 4 5
15