Help Center > > FAQs> Database Storage> What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
Updated at:Dec 14, 2020 GMT+08:00
The database storage space of an RDS DB instance is exhausted, and applications cannot read data from or write data to databases, interrupting services.
- Data occupies a great amount of storage space.
- A large number of binlog files are generated due to a large number of transactions and write operations.
- A large number of temporary files are generated due to a large number of sorting queries executed by applications.
- If data occupies too much storage space, run DROP, TRUNCATE, or DELETE+OPTIMIZE TABLE to delete useless historical table data to release storage space. If no historical data can be deleted, scale up your storage space.
- If binlog files occupy too much storage space, contact technical support to delete local binlog files to release storage space.
- If temporary files generated by sorting queries occupy too much storage space, optimize your SQL query statements.
- If the preceding solutions are invalid, implement database and table sharding.