Questions in Database
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hello, can anyone give any advice on this.
I created the very simple test Glue job: Source - RDS Postgres, Destination - S3 bucket.
Run takes about 23 minuts and ends with timeout error.
In the log I...
3
answers
0
votes
553
views
asked 10 days agolg...
New to SageMaker evalutating ML models. I have 2 domains each created with quick and custom setup.
Each domain connects to 2 different VPCs, the quick setup is under staging-vpc and the custom domain...
1
answers
0
votes
534
views
asked 12 days agolg...
We have a MySQL multi-AZ instance on t2 class, which needs to be migrated to t3 family.
AWS documentation says this requires downtime, which is understandable. But it also mentions that only one...
Accepted AnswerMySQL
1
answers
0
votes
54
views
asked 12 days agolg...
I have an issue with my RDS Proxy on AWS. I've configured a proxy for my PostgreSQL database, which works correctly within my VPC. However, I'm trying to use Amazon AppFlow to access the database...
0
answers
0
votes
509
views
asked 12 days agolg...
We recently migrated our on prem SQL server 2008 R2(8 CPU 16 GB RAM) to EC2 (r5.4xlarge - 16 CPU 128 GB RAM) 2019. The server is very slow, all the queries are slow. We can see CX_PACKET wait being...
3
answers
0
votes
114
views
asked 12 days agolg...
We have an application, which needs to create table in system database in SQL SERVER RDS.
We are getting , below error while trying to create a table.
The following SQL Server error or errors...
1
answers
0
votes
82
views
asked 12 days agolg...
I'm trying to remove a database but i'm getting this error:
SQL Error [1010] [HY000]: Error dropping database (can't rmdir './databasename', errno: 39)
I've been reading solutions, but it looks like...
1
answers
0
votes
135
views
asked 12 days agolg...
say i have couple of json files in s3, I would to set up a crawler or a glue job, such that i can create table in aws rds (mysql or postgre) , such that in table 1, it creates a autogenerated id and...
1
answers
0
votes
690
views
asked 13 days agolg...
We recently upgraded MySQL 5.7 to MySQL 8.0.35 and are noticing huge performance problems in our production website.
Any insights as to what sort of queries can cause performance issues? Any config...
Accepted AnswerMySQL
1
answers
0
votes
73
views
asked 13 days agolg...
I need to find the difference between two timestamp range. I tried using DATEDIFF but not getting the exact result. Below is the query I am using:
```
select
rtrim(datediff(hour,'2024-05-15...
1
answers
0
votes
263
views
asked 13 days agolg...
I'm having the same issue. Data is stored in below format in s3 as JSON array with partitions
S3 path - s3://fleet-fuelcard-data-import-dev/lambda/fuelsoft-morgan/660306/2024/Apr/03-Apr-2024.json....
1
answers
0
votes
70
views
asked 13 days agolg...
It is mentioned in the user guide Managing an RDS Proxy (https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-managing.html#rds-proxy-changing-db-user-password) that we to modify a proxy...
0
answers
0
votes
93
views
asked 13 days agolg...