Storage analysis helps you monitor and diagnose storage consumption for a database instance. With this feature, you can:
View current storage usage and predict how many days of storage remain
Track storage growth trends over a selected time range (up to seven days)
Inspect per-database and per-table space allocation
Identify and address tablespace issues, including fragmentation, duplicate indexes, and auto-increment primary key overflows
The following example uses an ApsaraDB RDS for MySQL instance.
Limits
Storage analysis supports a maximum of 20,000 tables per analysis.
View storage usage
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
Find the database instance you want to manage and click its instance ID. The instance details page appears.
In the left-side navigation pane, click Storage Analysis.
On the Storage Overview and Data Space tabs, view the storage usage of the instance.
| Tab | Section | Description |
|---|---|---|
| Storage Overview | Storage | Displays storage metrics across four dimensions: Exception, Avg Daily Increase in Last Week, Available Days of Storage, and Used Storage. Click the  icon next to a dimension to view detailed information. |
| Storage Overview | Exceptions | Lists tablespace issues detected for tables or collections in the instance. If automatic space optimization is enabled, also shows the space optimization history. For details on detected exception types, see Detected exceptions. |
| Storage Overview | Storage Trend | Shows storage usage over a selected time range of up to seven days. |
| Storage Overview | Tablespaces | Lists each table with its storage details. Click a table name to view its Field and Index information. |
| Data Space | — | Shows the storage used by each database in the RDS instance, and the storage used by each table within those databases. Click a table name to view its Field and Index information. |
Detected exceptions
DAS automatically identifies the following exception types in ApsaraDB RDS for MySQL instances:
| Exception type | Description |
|---|---|
| Potential auto-increment primary key overflows | DAS can automatically identify potential overflows of auto-increment primary keys in ApsaraDB RDS for MySQL instances. |
| Duplicate indexes | DAS can automatically identify duplicate indexes in ApsaraDB RDS for MySQL instances. |
| Tablespace fragments | For more information, see Automatic tablespace fragment recycling. |