By using AWS re:Post, you agree to the Terms of Use
/Aurora MySQL Cluster - Massive increase in bytes used/

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 Answers
0
Accepted Answer

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.

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions