Questions tagged with MySQL
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.
I have RDS MySQL 8 server, recently upgraded to db.r6d instance.
Now I'd like to activate "RDS Optimized Writes". I saw that it's possible to do this using either Blue/Green deployment and read...
1
answers
0
votes
66
views
asked 18 days agolg...
I have a dump main.sql which I dumped from a database from inside lightsail.
I have then created a new database in another lightsail instance and I am trying to import the dump main.sql into that...
2
answers
0
votes
310
views
asked 19 days agolg...
We are getting an intermittent "Error establishing a database connection" errors we are experiencing in two of our WordPress websites hosted on Amazon Lightsail.
**Error Description:**
The error...
1
answers
0
votes
450
views
asked 22 days agolg...
I have an RDS MySQL, which used my owner DB instance parameter group, where I have:
max_connections =6000
table_open_cache = 6000
thread_cache_size = 4000
require_secure_transport =...
1
answers
0
votes
110
views
asked 22 days agolg...
Hi,
I have configuration:
- rds mysql 8.0.36 multi az deployment (active - standby)
- few instances of read-replica
I have configured job to scale in and scale out of my main database (to save $ after...
1
answers
0
votes
117
views
asked 22 days agolg...
I used mysqljump to back up the database, uploaded the sql file to S3 and used Restore from S3 to restore the database, and then failed and reported an error: "Incompatible-restore"
My database...
1
answers
0
votes
137
views
asked 23 days agolg...
```
mysqldump -h source_MySQL_DB_instance_endpoint \
-u user \
-ppassword \
--port=3306 \
--single-transaction \
--routines \
--triggers \
--databases database database2 >...
1
answers
0
votes
91
views
asked 23 days agolg...
We would like to have a certain table truncated when the RDS for MySQL instance is started using the server parameter "init_file" which currently is NOT supported on RDS.
(The statements should be...
2
answers
0
votes
112
views
asked 25 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
64
views
asked a month 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
157
views
asked a month 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
82
views
asked a month agolg...
I hope someone has some ideas on how to resolve the following issue I'm facing.
Here's the setup:
- 8.0.mysql_aurora.3.06.0 cluster with a writer and a reader instance(db.r7g.large)
- PHP web...
0
answers
0
votes
390
views
asked a month agolg...