Aurora MySQL Cluster - Massive increase in bytes used

0

I recently noticed our Aurora MySQL cluster's Bytes Used increased massively from 341 GiB, to 4362 GiB over the course of five days.

The backup logs look like this:

DateSize
May 19, 2022, 8:39:13 AM UTC4362 GiB
May 18, 2022, 8:35:52 AM UTC4362 GiB
May 17, 2022, 8:41:40 AM UTC4100 GiB
May 16, 2022, 8:40:30 AM UTC2997 GiB
May 15, 2022, 8:37:08 AM UTC1791 GiB
May 14, 2022, 8:36:58 AM UTC583 GiB
May 13, 2022, 8:39:09 AM UTC341 GiB
May 12, 2022, 8:36:12 AM UTC341 GiB

As you can see it rises sharply for a few days and then levels off.

There is no operational reason for this to have happened because our database size is only about ~40 GiB. I upgraded the cluster engine from 2.08.2 to 2.10.2 hoping that the dynamic resizing would take care of the issue, but the bytes used is still showing over ~4000 GiB.

I have rebooted the cluster, but that has made no difference.

Through some research there are a few other resources, but none of them have any real resolution as to this exact issue:

Engine version:
5.7.mysql_aurora.2.10.2

1回答
0
承認された回答

So it looks like upgrading the cluster to 2.10.2 did indeed fix the issue, it just took some time for the dynamic resizing to finally kick in.

Over the course of the last 24 hours, it has gradually resized down to match the actual size of the database.

For anyone running into this in the future, upgrading your cluster engine and just... waiting seems to be the most appropriate course of action.

回答済み 2年前

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

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

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

関連するコンテンツ