All Questions
Tagged with amazonrds or amazon-rds
985 questions
0
votes
1
answer
1k
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 ...
CommunityBot
- 1
1
vote
1
answer
712
views
How to clear AWS RDS Aurora MySQL local storage?
I got a warning message about running out of AWS RDS local storage.
The free storage capacity for DB Instance: {MY INSTANCE NAME} is low
at 2% of the provisioned storage [Provisioned Storage: 157.36 ...
CommunityBot
- 1
0
votes
0
answers
41
views
How can I tell if SQL Server is RDS, RDS Custom, or installed manually on a VM (EC2)?
I only have direct access to the SQL Server. How can I check if it's RDS, RDS Custom (which allow to connect to the VM), or installed manually on a VM (EC2)?
- 801
1
vote
1
answer
632
views
Massive slowdown after doing an ALTER to change index from int to bigint, with Postgres
I have a table like this:
create table trades (
instrument varchar(20) not null,
ts timestamp not null,
price double precision not null,
quantity double ...
CommunityBot
- 1
0
votes
1
answer
576
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-...
CommunityBot
- 1
0
votes
1
answer
153
views
RDS MySQL not using NVMe instance storage - no benefit of "Optimised Reads"
I am load testing various RDS instances trying to optimise db price/performance
I had seen this doc https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-optimized-reads.html and it sounded like ...
- 528
2
votes
2
answers
546
views
What schema does this mean 'mysql - schema's default character set: utf8'?
While upgrading mysql from 5.6 -> 5.7 -> 8.0.23 in step 5.7 -> 8.0.23 I got a warning:
The following objects use the utf8mb3 character set. It is recommended to convert them to use utf8mb4 ...
- 26.9k
1
vote
1
answer
2k
views
'Can't create thread to handle new connection' on RDS
I have two production instance of MySQL on AWS RDS that failed with:
2017-06-20T15:48:35.226833Z 0 [ERROR] Error log throttle: 1 'Can't create thread to handle new connection' error(s) suppressed
...
CommunityBot
- 1
0
votes
1
answer
85
views
How can high severity alerts be configured in Amazon RDS SQL Server?
Per the RDS documentation,
SQL Server Agent alerts and operators aren't supported.
But on any sensible SQL Server, you really want these for the high severity alerts.
So, I'm here to ask: How can ...
- 629
1
vote
2
answers
1k
views
Import a large MySQL dump 68GB on RDS instance
I tried to import a large MySQL dump.sql (68GB) on RDS AWS instance MySQL 8.0 (db.t3.2xlarge: 32GB RAM).
The import takes more than six hours:
More than 500 tables
I have 2 large tables: the first ...
CommunityBot
- 1
1
vote
1
answer
304
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 ...
CommunityBot
- 1
0
votes
1
answer
433
views
AWS RDS downsizing alternatives
I've recently increased my General Purpose SSD storage up from 1000Gb to 6000Gb in an accident. Now I'm trying to bring the storage size down to the original 1000Gb but I can't do it over the console.
...
CommunityBot
- 1
1
vote
1
answer
3k
views
Amazon RDS index creation on large table over 300 M records
I need to create a new index on large table in RDS MySQL. This index is needed to reduce the scan time on this table. Below is the configuration:
Table size: 400 GB
Records: 400 Million
column - ...
CommunityBot
- 1
1
vote
0
answers
45
views
How can I improve the performance of a "cold" (first) run of this seemingly simple query?
I'm working on a specific query which has been slowing down an application for some time. The table in question has about 55 million rows.
A "cold" (first) run of this query usually takes ...
- 193
9
votes
1
answer
2k
views
AWS RDS postrgres massive disk use, small tables
I can't figure out why our AWS postgres server has consumed all of it's space. We just had to up the storage space allocated to it, but can't find any hint from postgres that it's using that much ...
CommunityBot
- 1
0
votes
1
answer
613
views
MariaDB large number of sessions waiting on index_tree_rw_lock
I have a MariaDB RDS instance that is mostly saving batched insert statements to 4 tables. These inserts have batches of an average of 200/batch and each statement saves to a single table. However, ...
CommunityBot
- 1
2
votes
1
answer
2k
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....
CommunityBot
- 1
0
votes
0
answers
22
views
RDS Mysql replica cdc performance
I have a RDS Mysql which has high read/write volume. ~10k IOPS on an average and peaks up to 16k IOPS.
I have another RDS mysql replica of the main. We are using this replica to capture cdc logs and ...
0
votes
0
answers
46
views
How can I find what's eating so much space in Postgres in AWS RDS Aurora?
Essentially when I run
SELECT
pg_size_pretty(SUM(pg_total_relation_size(relid))) as total_size,
pg_size_pretty(SUM(pg_indexes_size(relid))) as index_size,
pg_size_pretty(SUM(pg_relation_size(...
- 101
1
vote
2
answers
62
views
Does regular truncate & insert hurt performance?
We have a large (5 TB) PostgreSQL 15 RDS that acts as a data warehouse, data comes in through regular pipelines and then ~20 users run analytic queries on it.
Our infrastructure people have access to ...
- 18.3k
-1
votes
2
answers
1k
views
AWS KMS Encryption enable for SQL Server Columns?
Is it possible MSSQL on EC2 with a key in AWS KMS to encrypt columns
CommunityBot
- 1
0
votes
0
answers
192
views
How to grant SYSTEM_VARIABLES_ADMIN permission to master MySQL user or rds_superuser_role from MySQL Workbench hosted on RDS?
Using MySQL 8.0.39 on an AWS RDS insteance, for troubleshooting purposes we want to be able to Enable/Disable the global general_log setting , being able to turn it on and off easily and quickly from ...
- 9
1
vote
2
answers
610
views
Automating MySQL replication using snapshots on AWS RDS (or Linux)
I'm currently working on a BASH script to build a new Aurora cluster based on the latest snapshot of an existing cluster, then set up MySQL replication from the old one to the new. In the past I've ...
CommunityBot
- 1
1
vote
1
answer
2k
views
Reduce 'wait/sql/table/io/handler' load of high frequent updates on the same rows
We have a time-series application that also writes all the records to kind of a 'head' table in MySQL. This is somewhat of a legacy, but very interwoven and hard to get rid of. The problem is, that it'...
CommunityBot
- 1
0
votes
1
answer
2k
views
innodb_autoinc_lock_mode = 2, real danger if not using AUTO_INCREMENT columns
I've got a MySQL RDS database that uses pure generated GUIDs for key columns. The current value of the innodb_autoinc_lock_mode is 1, and due to some performance bottlenecks we want to change it 2. ...
CommunityBot
- 1
0
votes
0
answers
11
views
How to see number of storage volumes on AWS RDS MySQL?
According to https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html, for "400–65,536 GiB" storage MySQL RDS will use "Number of volumes provisioned = 4".
I have ...
1
vote
1
answer
32
views
Why free storage space dip on MySQL replica?
I have AWS RDS MySQL 8.0.36 primary-replica setup. I see this storage free space dip on the replica only. Any ideas why it happened?
- 184k
0
votes
1
answer
1k
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
+----------------------...
CommunityBot
- 1
2
votes
0
answers
76
views
AWS RDS PostgreSQL -
We have an AWS RDS PostgreSQL (v14.10) instance running on a db.t3.micro instance. Randomly throughout the day (some days more than others), our .NET Core application starts failing with the following ...
- 121
0
votes
0
answers
31
views
MSSQL on AWS: remote user unable to establish connection via SSMS
Newly created MSSQL 2017 SE instance, using SQL authentication. I am able to connect to it with no issues via my corporate VPN. Overseas user on VPN is unable to connect, getting this error from SSMS:
...
- 143
0
votes
0
answers
41
views
How can I avoid downtime for AWS RDS SSL/TLS certificate rotation?
I have some production databases in RDS for which I have active connections and writes every minute. The current server certificates are expiring on 22nd August. I tried to update one, it takes 5 ...
- 101
0
votes
0
answers
23
views
Failed to prune sessions: no pg_hba.conf entry for host, although connection works fine
I am using an AWS RDS Postgres database and Typeorm to connect to the database. I have also configured the RDS database to require a SSL connection. I pass the CA certificate to the database like this:...
- 101
1
vote
1
answer
37
views
Decrease high response time when reading large table in MySQL
I have a table with around 80~ million rows called parts.
I have a simple query like this
SELECT line_code, part_number, compressed_part_number, ...[Others columns]
FROM parts
WHERE (@partNumber = ...
- 8,668
0
votes
1
answer
71
views
How to run a query against AWS RDS "locally"?
Our company has an RDS instance of a Postgres database in AWS. I don't have much experience with AWS.
I'd like to run a very lengthy query against the database (VACUUM FULL) that may take many hours ...
- 166
0
votes
2
answers
239
views
How to down size the storage of AWS RDS MySQL instance?
I have an RDS MySQL instance db.m5.4xlarge with 8.3TB of data, and I want to shrink it to 4TB to save costs because it actually has 4TB of data. What are the viable options?
I've tried several methods,...
0
votes
0
answers
53
views
Intermittent AWS RDS Connection Spikes Causing Production DB Outages
I'm new to AWS, and we're using a db.r7g.2xlarge instance running MySQL with default configurations. Typically, CPU usage and database connections are normal until "something" causes the DB ...
- 101
2
votes
1
answer
282
views
How does an encrypted DynamoDB (the same question applies to RDS as well) query work?
I am trying to understand whether the primary key is encrypted when I choose to encrypt at rest for AWS DynamoDB
If the primary key is encrypted, how does a primary-key lookup get
performed under the ...
CommunityBot
- 1
0
votes
1
answer
63
views
AWS RDS taking snapshots outside the backup window
I administer an AWS RDS SQL Server instance, with a backup window of 22:00-22:30 UTC and a retention period of 35 days.
I have noticed some peculiarities:
There are 55 automatic snapshots currently ...
- 199
2
votes
2
answers
426
views
Unable to enable Performance Insights on Amazon RDS db.t3.small instance
I recently upgraded my Amazon RDS instance from db.t2.micro to db.t3.small. After the upgrade, I also activated the performance_schema parameter in the associated parameter group because I've read ...
0
votes
0
answers
62
views
I have created a blue green deployment for my AWS RDS MySQL Database as I need to update the version. But I can't connect to the green instance?
I have an old MySQL database on AWS RDS that I need to upgrade to a newer version. I have created a blue green deployment, in order to test out the upgraded version of MySQL before switching over. But ...
- 1
0
votes
0
answers
89
views
When to provision higher iops or throughput on gp3
We have an AWS PostgreSQL RDS instance. Not a lot of users, high loads in the overnight batch jobs.
Current instance type is m6g.large (2CPU 8GiB RAM) with 1300 GB Storage on gp3 SSD with 12000 IOPS ...
- 347
1
vote
1
answer
87
views
ORACLE: RDS On AWS
This may be a lack of understanding as I am a MSSQL DBA more than Oracle.
We are running Oracle on RDS in Amazon.
Engine Version 19.0.0.0.ru-2020-10.rur-2020-10.r1
I dropped an old _backup table but ...
- 1,102
0
votes
1
answer
191
views
high cpu spikes on postgresql (rds)
I have a PG 15(.5) RDS instance, which is experiencing intermittent random(?) periods of high cpu; that do not seem to, afaict, correlate with an obvious cause:
Here is one example. The queries being ...
- 48
0
votes
0
answers
27
views
Accessing RDS transaction logs
Greetings to everyone from a newcomer to this forum!
There is an RDS MySQL 5.7 database the transaction logs of which I would like to inspect: more specifically, upon attempting to add foreign keys to ...
- 101
0
votes
1
answer
162
views
Can not create logon trigger on AWS RDS sql server instance
In order to audit logins I've used before a server level trigger catching the LOGON and saving it to a table, there are endless examples to do this.
But trying to do the same on and AWS RDS sqlserver ...
- 2,018
1
vote
1
answer
932
views
Understanding RAM Usage, ReadThroughput, and Freeable Memory Metrics in PostgreSQL RDS
I'm facing an interesting issue related to RAM usage, ReadThroughput, and Freeable Memory metrics with my PostgreSQL database on an RDS instance, and I'm hoping to get some insights here.
Two months ...
CommunityBot
- 1
0
votes
0
answers
18
views
RDS too many connections from Magento
Hi
I am facing an abnormal issue with RDS. Some times the sessions increases rapidly and eventually i need to restart the database. May be it is causing due to a lock on any table.
I still curious ...
3
votes
3
answers
22k
views
AWS DMS Task getting failed after completion with error as AlwaysOn BACKUP-ed data is not available
I have created DMS task for migrating data from one RDS MS SQL Server instance to another RDS MS SQL Server instance with "Full load + ongoing replication", and data copied to target ...
1
vote
0
answers
31
views
how to use Amazon SCT to connection to an Amazon RDS database?
Apparently, Amazon SCT can be used to compare two schemas for differences.
We have several RDS Postgres databases, using Native postres authentication.
SCT has the option to connect to an RDS database ...
- 213
0
votes
1
answer
44
views
How to enable pg_stat_user_indexes on postgres on Amazon RDS
We want to check if we have unused indexes in our postgres 15.5 RDS instances.
Currently, we did "CREATE EXTENSION IF NOT EXISTS pg_stat_statements"
Which enables pg_stat_satements, but what ...
- 213