Questions tagged with MySQL

I have a mysql 5.7 replica on RDS and I would like to know if I could make any changes. For some replica tables, I need to remove the foreign keys and partition it. I need to do this, because the...

Hi all, I am trying to create an Aurora serverless read replica for a mySql RDS database and I am getting this rather confusing error message. The RDS myql is on version 8.0.28. What should I...

I am planning to migrate RDS MySQL to Document DB, so I've used DMS for migration. I am facing connectivity issue while connecting Source and Target Endpoints. Note : RDS MySQL is One account and...

Hi, We experienced high cpu usage on RDS MySQL instance today for about 4 hours. Our number of queries did not change drastically for the past year or so. Everything has been working fine until this...

Hello, Our RDS storage size was 100GB. Actual DB size was 18 GB. But suddenly storage get full & after some time it was automatically decrease. We have checked DB size at & binlog size, both are...

Hi, I hope you can help me, these days I installed wordpress together with apache and other plugins, I did it by command line and the database was done in RDS in my AWS account, a MariaDb database....

Hi there, In my Lightsail-Nginx instance, MariaDB stopped suddenly sometimes and my WordPress website got the ``` error establishing a database connection ``` And when I tried to connect MariaDB on...

Hello. I'm having a problem with my instance of RDS MySQL 8.0.28, which is crashing and soon after I see in the logs on the RDS dashboard that a recovery process has been started that takes a few...

I have created my RDS (MySQL) instance and its status has been "availble". I have also done below: 1. Selected "Publiclly accessible" from the "Public Access" section in the "Modify Instance"...

Hello, This is a qualitative question. When I log on to **RDS** on my aws management console the console does not show all of my databases. The URL automatically defaults to the `us-west-2`...

I want to overwrite or truncate a table in Mysql using aws glue job python, I tried using preactions like redshift but It doesn't work. here is my code : ``` datasink4 =...

After a Major Version Upgrade from Aurora 2 MySQL 5.7 to Aurora 3.03.1 MySQL 8.0 I have a lot of Aborted Clients, checking the logs I can see messages like the following: [Note] [MY-010914] [Server]...