Archive jobs maxing out IOPS


#1

I have a RDS MySQL instance setup with 3000 IOPS.

We are running into an issue that when the archive job runs via cron the web interface becomes unresponsive due to MySQL dead lock errors.

Is there a way of throttling the archive job to not use up all 3000 IOPS during the archive process?

-Eugene