Help Center/ Relational Database Service/ User Guide (Paris Region) / FAQs/ Database Storage/ What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?
Updated on 2022-12-08 GMT+08:00

What Should I Do If My Data Exceeds the Database Storage Space of an RDS DB Instance?

Scenario

The database storage space of an RDS DB instance is exhausted, and applications cannot read data from or write data to databases, interrupting services.

Cause

  1. Data occupies a great amount of storage space.
  2. A large number of binlog files are generated due to a large number of transactions and write operations.
  3. A large number of temporary files are generated due to a large number of sorting queries executed by applications.

Solution

  1. 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.
  2. If binlog files occupy too much storage space, contact technical support to delete local binlog files to release storage space.
  3. If temporary files generated by sorting queries occupy too much storage space, optimize your SQL query statements.
  4. If the preceding solutions are invalid, implement database and table sharding.