Aurora MySQL Cluster - Massive increase in bytes used
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:
| Date | Size |
|---|---|
| May 19, 2022, 8:39:13 AM UTC | 4362 GiB |
| May 18, 2022, 8:35:52 AM UTC | 4362 GiB |
| May 17, 2022, 8:41:40 AM UTC | 4100 GiB |
| May 16, 2022, 8:40:30 AM UTC | 2997 GiB |
| May 15, 2022, 8:37:08 AM UTC | 1791 GiB |
| May 14, 2022, 8:36:58 AM UTC | 583 GiB |
| May 13, 2022, 8:39:09 AM UTC | 341 GiB |
| May 12, 2022, 8:36:12 AM UTC | 341 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:
- Why Volume Bytes Used become so high on AWS Aurora RDS MySQL cluster?
- How to stop auto expanding of Aurora's storage (volume)
- Why is my "volume bytes used" always increasing on my Amazon Aurora cluster?
- How do I view the total storage used for my Amazon Aurora MySQL DB cluster?
Engine version:
5.7.mysql_aurora.2.10.2
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.
Relevant questions
Need help in upgrading the aurora MYSQL 5.7 to MYSQL 8 [URGENT]
asked 6 months agoAurora MySQL Cluster - Massive increase in bytes used
Accepted Answerasked a month agoAurora MySQL Error number 28 means 'No space left on device'
asked 4 months agoMigrating from RDS MariaDB 10.2 to Aurora MySQL 5.6
Accepted Answerasked 3 years agoMySQL Aurora Error connecting to S3
Accepted Answerasked 3 months ago(Serverless) Amazon Aurora MySQL 1 end of life on February 28, 2023
asked 3 months agoMove RDS MySQL 5.6.40 database to Aurora Serverless
asked 3 years agoAurora MySQL 8 Provisioned - Low Freeable Memory Causing Failover Despite Restricted Parameters
asked 6 months agoAurora MySQL Upgrade From 2.10.1 to 3.01.0 (MySQL 5.7 to 8) failing
asked 6 months agoAre there difficulties migrating from Aurora MySQL to Aurora Serverless
Accepted Answer