All Questions
1,968 questions
0
votes
2
answers
32
views
Disable MySQL ONLY_FULL_GROUP_BY while logging violations
We have attempted to upgrade a legacy database from MySQL 5.6 to 5.7 in the hopes of bringing it up to current, but quickly experienced queries that failed with this is incompatible with sql_mode=...
- 195
0
votes
1
answer
32
views
Where can I find more detailed MySQL deadlock logs?
We have a MySQL database in AWS RDS that was migrated recently from 5.7 to 8. One of our microservices running in ECS executes bootstrapping code at launch to iterate through a large list of table ...
GS-Scooter
0
votes
0
answers
11
views
Can you downgrade provisioned iops on gp3 for postgresql RDS?
Doing an occasional analysis on a postgreSQL RDS instance with gp3 storage.
Running out of provisioned IOPS.
Is it possible to temporarily raise the provisioned IOPS limit? e.g. just for a day or ...
- 347
0
votes
0
answers
15
views
Postrgresql Logical replication causing very high buildup of log files even though replication slots are active [ AWS RDS postgresql 16.1]
I have two rds instances and have set up logical replication between them [ publisher subscriber]. for the 3-4 days everything was working fine wal files were getting cleared but suddenly when the ...
- 1
0
votes
1
answer
31
views
Amazon Aurora RDS - invalid undo record
Context
Aurora RDS, MySQL 8.0.mysql_aurora.3.05.2
Problem
The writer instance is constantly cycling. In the AWS RDS console, under Logs & events for the writer, I see
Attempting to restart the ...
- 121
0
votes
1
answer
41
views
Setting Synchronous_commit to off in Postgres in AWS RDS
0
We are experiencing significant delays in our PostgreSQL database due to LWLock:WALWrite and LWLock:WALSync waits, which are causing commits to pile up.
To address this, we have undertaken several ...
- 1
0
votes
1
answer
26
views
Analyzing sql query performance issues in mysql
I am new to mysql, I have few questions in regards to query performance tuning. (Note- its version 8.0.32)
I understand we use "explain analyze" to see the execution plan and it shows the ...
- 11
0
votes
0
answers
22
views
Granting Permissions To as User in Mysql
I created user-a that has the following grant privileges
SHOW GRANTS FOR 'user-a'@'%';
'GRANT INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, ...
0
votes
0
answers
15
views
MySQL 8.0 connecting to AWS RDS MySQL 5.7 with SSL/TLS CA authentication fails weirdly (Error code MY-002026)
When trying to establish TLS encrypted replication between a replication source living in AWS RDS on version 5.7.44, and a replica living in a VM on-premise on version 8.0.39, I keep getting an error:
...
- 1
0
votes
0
answers
94
views
How does RDS Postgres OldestReplicationSlotLag metric correlate to replication slot Log Sequence Number lag?
We run a Postgres 14.9 database via RDS Aurora Serverless. We have a logical replication slot consumed by a service (Fivetran) every 15 minutes.
We noticed this behavior where the reported ...
- 51
1
vote
1
answer
48
views
Collation difference in PostgreSQL on AWS RDS and local machine
I have an issue with collation in PostgreSQL when sorting a result set. We use AWS RDS PostgreSQL, and we want to sort query results in a specific way. Locally, everything works perfectly on my laptop ...
- 119
2
votes
1
answer
24
views
Primary Key data type suggestion for MySQL for an application that depends in a external system. unsigned bigint vs varchar data type in primary keys
I'll give you some context and then ask my question.
I'm building a database model for an ecommerce application. This application needs to communicate to another system (ERP system) to get product, ...
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
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 ...
- 801
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
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
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
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
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 ...
- 559
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
2
answers
102
views
How to work around "row is too big" for role definitions without recreating the database?
I am running into the row is too big (ERROR: 54000: row is too big: size 9976, maximum size 8160) error in Postgres related to role permissions on a couple of my instances. I understand that after ...
- 11
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?
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 = ...
- 111
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 ...
- 4,690
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,...
- 11
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
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 ...
- 101
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
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 ...
- 101
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
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 ...
- 431
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,837
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 ...
- 101
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 ...
- 123
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
1
vote
1
answer
57
views
Database isn't using the correct index
I have a table that contains several jsonb columns. Here is a simplified version of it
create table if not exists files
(
id int generated always as identity primary key,
source text not null,
...
0
votes
1
answer
315
views
Postgres logical replication and table rename
We have a table in main DB that is getting logically replicated to another DB called SOR. We need to rename this table, and add a bunch of tables to the publication on the main DB. I tried this ...
- 3
0
votes
0
answers
117
views
database "template0" is not currently accepting connections
i got the following error
database "template0" is not currently accepting connections
How to vaccum it?
Thanks
UPDATE
i got the following yesterday
postgres=> select * from public.test;
...
- 259
1
vote
1
answer
700
views
Improving write performance for 100 million writes daily on Postgres [closed]
We have posgres 15 in RDS and the instance is db.m6g.4xlarge with 64Gb RAM.
We want to write to a table that is date partitioned and has two UUID fields (lets call them id1, id2) and few other ...
- 11
0
votes
0
answers
58
views
Azure MySQL and AWS RDS insert performance difference
We had to move our infra from AWS to Azure (reasons irrelevant) and I've set up a same spec DB instance on Azure, even a tier larger (2c/8g on AWS and 2c/16g on Azure, both memory optimized). What I'...
- 1
0
votes
0
answers
26
views
AWS RDS MySQL read replica's failover and standby instance's failover
This question is for AWS RDS MySQL
I have recently started studying RDS, trying to study from the documentation as well as other sources. For following scenario I am unable to understand certain ...
- 226
0
votes
0
answers
80
views
Query performance degrade after upgrade from MySQLv5.6 to v5.7
I upgraded the MySQL Server from v5.6 to v5.7 and since then I see query performance degrade. For example, I have the following select query that selects some columns and has a single column in the ...
- 21
1
vote
0
answers
191
views
AWS RDS MySQL "manual" read replica in "Waiting for dependent transaction to commit" state but lag is zero
I have an SOP I use to upgrade AWS RDS instances running MySQL with no downtime that I have been following since 2021. I'll outline my method below, but it involves manually hooking up a new master ...
- 111