aws mysql iops,AWS增加iops

I have never used AWS before and have created a php application hosted on an EC2 instance.

The application inserts records into a RDS after processing them. On the free tier it is inserting them at a rate of around 10 records per second.

How would I go about improving the speed at which this process takes place? I have added 100GB provisioned IOPS storage with a limit of 1000 iops.

However when I run my application I get the same speeds as before.

What specs on the Ec2 instance and the RDS instances will determine how quickly it will write to the database?

解决方案

Do take note

AWS free tier instance is only mean for casual usage. t2.micro is running on "CPU credit" burst mode. Once you run out of those CPU credit, the server will throttle to more than 25% CPU, thus your performance will suffered.

you should invest a bit in cloudwatch to send RDS IOPS info to learn what is the real issues, e.g. to find out whether it is CPU, RAM or IO issues.

AWS introduce SSD gp2 storage for quite some time. So you should make use of AWS per GB x 3 IOPS mechanism than jump straight into Provisioned IOPS.

This article tell you why you should over provisioned gp2 storage than use provisioned IOPS. You also get extra value for money with gp2 with burst IO.