Insufficient storage can cause read and write failures, backup failures, and prolonged storage scaling. Database Autonomy Service (DAS) helps you monitor storage usage, automatically expand storage capacity, and reclaim space occupied by tablespace fragments.
Monitor storage usage
Use Storage analysis to view the storage status of a database instance. You can obtain the following information:
-
Total storage usage and remaining available days
-
Estimated 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 automatically expand instance storage when capacity 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
Tablespace fragments accumulate over time 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
Watch the following video for a walkthrough of these features.