I've been using AWS RDS db.m4.large with 128GB storage for MySQL(InnoDB) for more than one year now.
The size of my database is now less than 2GB and the free storage had always been more than 125GB as captured below but it suddenly dropped to 0GB in less than 2 hours 2 weeks ago.
So I upgraded the storage to 250GB but it was dropped to 0GB again two days ago.
So I asked AWS customer center about it and they told me that mysqlInnoDbTablespace took 243GB and I can reduce the size of it by executing OPTIMIZE TABLE on all of my tables.
dataVolumeAvailableSize 43.3 gb, dataVolumeTotalSize 295 gb dataVolumeUsedSize 251 gb mysqlErrorLogFileSize 72.4 kb mysqlGeneralLogBackupSize 0 bytes mysqlGeneralLogFileSize 0 bytes mysqlGeneralLogSize 0 bytes mysqlInnoDbLogSize 256 mb mysqlInnoDbTablespace 243 gb mysqlSlowLogBackupSize 124 mb mysqlSlowLogFileSize 35.9 kb mysqlSlowLogSize 4.03 gb
I did it but the free storage hasn't been increased. so I asked them again but they haven't replied my inquiry.
Below is the size of my database. it's less than 2GB.
Did anybody experience this kind of case or can somebody help me to free up the free storage?