RDS mariadb performance on update queries

Question

Hi, I've migrated a workload from mariadb on ec2 to rds and I'm facing a performance issue.  
This job make massive update queries on some tables (69465).

Using mariadb service on Ec2 common instance (t3a.small) it takes **1m31,148s**

Using RDS (db.m6g.xlarge - storage io1 200GB ): **5m46,239s**

After many tries I realized that the only way to have the same performance on Ec2 and RDS is to disable "automated backups" on RDS

Can anybody help me to understand why? Backup is a requirement

Answer

1) Enabling backups in RDS requires enabling binlogs. So, with/without binlogging you will see different io pattern.
2) Also, you don't state the IOPS for 'RDS1' or your self managed ec2. These are important details for your question.
3) 'RDS2' is a 100g gp2 volume, so you need to look at the BurstBalance to be sure that you are not running out of Burst IOPS. 
4) Finally, IOPS < 0.5 is essentially an idle instance. It is unlikely with any configuration that your massive update workload is active and the IOPS is near zero.

Hope that is helpful.

RDS mariadb performance on update queries

相关内容