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.
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
45
views
asked 18 hours 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
26
views
asked a day 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
41
views
asked a day 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
67
views
asked a day 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...
0
answers
0
votes
18
views
asked a day 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
72
views
asked 2 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
127
views
asked 2 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
46
views
asked 2 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...
0
answers
0
votes
127
views
asked 2 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....
0
answers
0
votes
23
views
asked 2 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
73
views
asked 3 days agolg...
I have deployed opensearch serverless collection. The collection type is VectorSearch. I have also defined all the security policies, like data access policies, encryption policy (Using KMS key),...
0
answers
0
votes
63
views
asked 3 days agolg...