forked from docs/doc-exports
Wang , Deng Ke
79b1bc1455
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com> Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
6.7 KiB
6.7 KiB
Which Types of Logs and Files Occupy RDS Storage Space?
The following logs and files occupy RDS storage space.
DB Engine |
File Type |
|---|---|
MySQL |
Log files: database undo-log, redo-log, and binlog files |
Data files: database content files and index files |
|
Other files: ibdata, ib_logfile0, and temporary files |
DB Engine |
File Type |
|---|---|
PostgreSQL |
Log files: database error log and transaction log files |
Data files: database content, index, replication slot data, transaction status data, and database configuration files |
|
Other files: temporary files |
DB Engine |
File Type |
|---|---|
Microsoft SQL Server |
Log files: database error log, transaction log, and trace files |
Data files: database content files |
Solution
- If the original storage space is insufficient as your services grow, scale up storage space of your DB instance.
- 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 temporary files generated by sorting queries occupy too much storage space, optimize your SQL query statements.
- A large number of temporary files are generated if there are a large number of sorting queries executed by applications.
- A large number of binlog files are generated and occupy space if there are large amounts of insert, delete, and update operations in a short period.
- A large number of binlog files are generated if there are a large number of transactions and write operations.
- Use Cloud Eye to monitor the size, usage, and utilization of storage space of your DB instance and set alarm policies.
Parent topic: Resource and Disk Management