Increase the maximum storage threshold for RDS

The message you're seeing about the RDS storage size approaching the maximum threshold, despite your database only using 100MB, suggests that there could be other factors utilizing the storage. Here are a few steps and considerations to help you investigate and resolve this issue:

Log Files: RDS automatically generates various log files, such as error logs, slow query logs, and general logs, which can consume significant disk space over time. Check the size of these logs and configure their retention settings appropriately in the RDS console.

Snapshots and Backups: Automatic backups and manual snapshots also use storage within your RDS instance's allocated space. Review your backup retention policy and the number of snapshots you're keeping.

Index and Overhead Space: Database indexing and overhead can consume more space than the visible data size. Run a detailed report or use a database management tool to examine how much space your indexes and overhead are consuming.

Hidden Tables or Unused Schemas: Sometimes applications or users might create additional data structures that aren't regularly monitored. Make sure all tables and schemas are accounted for.

Increase Storage Threshold or Clean Up: If you find that the space is legitimately being used and necessary, consider increasing the storage limit of your RDS instance. This can typically be done through the AWS Management Console under the RDS section, selecting your instance, and modifying the allocated storage. If it's not necessary, then actions such as cleaning up old logs, compressing tables, or removing unnecessary data might be appropriate.

If after these checks you still find discrepancies, it might be worthwhile to reach out to AWS Support for a deeper analysis, as there could be specific settings or issues related to your instance type or configuration affecting the storage usage.

This error is because you have a Maximum storage threshold configured on the RDS Instance of 35GB and your Storage is at 30GB. This will alert because its within 26% of the Max. It doesnt mean your using 30 GB of storage.

If you look at the FREE storage Metric of the RDS i believe you will have 28GB ish free space.

Increase your Maxium storage threshold to 40GB and I believe your alerts will subside.

You must set the maximum storage threshold to at least 10% more than the current allocated storage. We recommend setting it to at least 26% more to avoid receiving an event notification that the storage size is approaching the maximum storage threshold. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html#:~:text=You%20must%20set%20the%20maximum,approaching%20the%20maximum%20storage%20threshold.