Storage exhaustion can cause an RDS instance to become unavailable with little warning. The storage analysis feature lets you monitor storage consumption in real time, track how many days of storage remain, and identify exceptions — such as potential auto-increment primary key overflows, duplicate indexes, and tablespace fragments — before they cause an outage.
Supported editions
The storage analysis feature is available on RDS High-availability Edition and RDS Cluster Edition.
If your instance runs RDS Basic Edition, run storage analysis in the Database Autonomy Service (DAS) console instead. For more information, see Storage analysis.
Limitations
The storage analysis feature can analyze up to 20,000 tables.
View storage analysis
-
Go to the Instances page. In the top navigation bar, select the region where the instance resides, then click the instance ID.
-
In the left-side navigation pane, choose Autonomy Services > Diagnostics.
-
Click the Storage Analysis tab.
-
On the Storage Overview and Data Space tabs, review storage information for the instance.
Storage Overview tab
| Section | Description |
|---|---|
| Storage | Displays four metrics: Exception, Avg Daily Increase in Last Week, Available Days of Storage, and Used Storage. Hover over the icon next to a metric to view its details. |
| Exceptions | Displays exception information for tables or collections on the instance. If automatic space optimization is enabled, this section also shows the space optimization history. DAS detects three exception types: potential overflows of auto-increment primary keys, duplicate indexes, and tablespace fragment identification (see Automatic tablespace fragment recycling). |
| Storage Trend | Shows a chart of storage usage over a selected period. The period can span up to seven days. |
| Tablespaces | Shows storage usage broken down by table. Click a table name to view its Field and Index details. |
Data Space tab
Shows storage usage by database and the tablespace usage within each database. Click a table name to view its Field and Index details.
What's next
-
Automatic storage expansion: Configure the system to expand storage automatically when available storage drops below a threshold. For more information, see Use the automatic storage expansion feature.
-
Automatic fragment reclamation: Configure the system to reclaim tablespace fragments automatically when a metric such as the tablespace size or fragmentation percentage exceeds a threshold. For more information, see Use the automatic fragment reclamation feature.
-
Other database engines: Storage analysis is also available for ApsaraDB RDS for SQL Server and ApsaraDB RDS for PostgreSQL.