RDS mariadb performance on update queries

0

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

質問済み 2年前443ビュー
1回答
0
  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.

AWS
モデレーター
philaws
回答済み 2年前
  • Hi Phil, thanks for your answer but the problem is not in what I see in logs but the performance of my workload. So I rewrite my question to make it clearer

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ