Insufficient storage can cause read and write failures, backup failures, and prolonged storage expansion operations. Database Autonomy Service (DAS) provides tools to monitor storage usage, automatically expand storage capacity, and reclaim wasted space from tablespace fragments.
Monitor storage usage
Use Storage analysis to check the storage status of a database instance. Storage analysis provides the following information:
Total storage usage and available days of storage
Estimated number of days before storage runs out
Per-table storage breakdown, including tablespace fragments
Diagnostic reports on storage anomalies
Automatically expand storage
Enable auto scaling to let DAS expand the storage capacity of a database instance when storage becomes insufficient.
| Database engine | Setup guide |
|---|---|
| ApsaraDB RDS for MySQL | Automatic storage expansion |
| ApsaraDB RDS for SQL Server | Automatic storage expansion |
| ApsaraDB RDS for PostgreSQL | Automatic storage expansion |
Recycle tablespace fragments
Over time, tablespace fragments accumulate and waste storage. Enable automatic tablespace fragment recycling to let DAS run OPTIMIZE TABLE or ALTER TABLE on the primary instance and reclaim unused space without manual intervention.
Video tutorial
For a walkthrough of the features described on this page, watch the following video.