Aurora SQL: VolumeBytesUsed increased with no reason
0
We had strange issue in June. Our VolumeBytesUsed started increasing on everyday basis without no reason. The DB itself doesn't have so much data, it should be less than 50Mb. We also didn't have more than 10 transaction per day. This increase stoped once we restarted RDS service. But now we're paying for the space we don't use. Any ideas?
1 Answer
- Newest
- Most votes
- Most comments
0
Youd want to review your Aurora logs for this period.
There may have been a case of a particular process or query that has been running and generating lots of log events in turn causing the storage to grow until it was restarted and the process cleared down.
Relevant content
- asked 2 years ago
- asked 2 months ago
- asked 2 years ago
- asked 2 years ago
AWS OFFICIALUpdated 10 months ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago
Yes, that's what I think of too. But Aurora logging is turned off by default, isn't it. There is no logs information on Logs & events tab. We do logging lambdas, but I assume it shouldn't be taking in consideration since their logging is written into console not DB. Additionally log rotation should cut all the exceeded data by now. "When FILE logging is enabled, general log and slow query log files are examined every hour and log files more than 24 hours old are deleted. In some cases, the remaining combined log file size after the deletion might exceed the threshold of 15 percent of a DB instance's local space. In these cases, the oldest log files are deleted until the log file size no longer exceeds the threshold"