Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.
2
votes
2answers
3k views
Local database vs Amazon RDS
I am doing large INSERT into a local MySQL database
I am at 2,000,000 rows and am really starting to notice the slowdown now. I always heard that MySQL wasn't very scalable
I expect this database to ...
1
vote
1answer
713 views
How do I reduce the database size on AWS RDS MySQL?
I have an RDS MySQL database on Amazon Web Services.
I want to reduce the size of the database in the control panel in order to save money.
Q: How do I make it smaller? Their site says you have to ...
2
votes
1answer
525 views
When should I think about upgrading our RDS MySQL instance based on memory usage?
It seems like our DB server is doing garbage collection at a increasingly faster rate, which seem normal since it's growing. What's a good rule of thumb of when to switch to a bigger instance, I'm not ...
2
votes
1answer
464 views
Does the Amazon RDS backup/snapshot service lock tables?
We have a database that is 100+GB. Most tables use the InnoDB engine.
A regular dump takes 1-2 hours.
If we moved to Amazon RDS, would this backup cause table locks?
Does Amazon use a simple ...
2
votes
1answer
572 views
MySQL 5.5 Runs Out of Memory, Drops All Connections When Creating Many Databases
I'm running into a problem when I create a large number of databases consecutively on an Amazon RDS db.m1.large instance. The MySQL Engine Version is 5.5.23. At some point, the RDS instance drops all ...
3
votes
1answer
274 views
MySQL on RDS, data transfer from one instance to another as a production job
I have a MySQL RDS instance ("production") from which I need to copy incremental data to another MySQL RDS instance ("reporting"). “Incremental data” being the new rows in certain tables. Currently ...
3
votes
1answer
183 views
Random write freezes
I have a MySQL 5.5.23 DB that performs about 3k qps, 5% of which are writes. Lately, I've been having a big problem with random write freezes. Everything is going great, and then all of a sudden any ...
1
vote
1answer
246 views
Should I increase max_connections in AWS RDS t1-micro for MySQL?
I have an AWS RDS t1-micro running MySQL 5.5. It gives me too many connections error. I checked and it allows 34 maximum connections concurrently. What I have read is that i can increase this max ...
1
vote
1answer
60 views
MySQL localhost vs Amazon RDS instance
I am seeing unexpected behavior with some MySQL performance.
When I run a simple query SELECT 1; on my local host (MySQL 5.6.x) using workbench, it executes in 0.000s, but the same query run on ...
1
vote
1answer
288 views
MySQL optimization
I'm trying to optimize a MySQL Server to be able to serve as many connections as it can.
The server is in AmazonAWS RDS and has currently the following resources:
--7.5 GB memory, 4 ECUs (2 ...
