Database Autonomy Service (DAS) provides storage analysis to help you monitor disk usage, forecast storage exhaustion, and diagnose space anomalies. With this feature, you can:
-
Track storage usage, daily growth, and the estimated number of days until remaining storage is exhausted
-
Identify anomalies such as tablespace fragments, duplicate indexes, and auto-increment primary key overflows
-
Drill down into tablespace and table-level usage
-
Compare storage across all managed instances to find the highest consumers
Prerequisites
Before you begin, ensure that your database instance is one of the following supported types:
-
ApsaraDB RDS for MySQL, PolarDB for MySQL, ApsaraDB MyBase for MySQL, or self-managed MySQL databases
-
ApsaraDB for MongoDB or self-managed MongoDB databases
-
ApsaraDB RDS for PostgreSQL or PolarDB for PostgreSQL databases
-
PolarDB for PostgreSQL (Compatible with Oracle) databases
-
PolarDB-X 2.0 databases
Usage notes
Storage analysis can analyze up to 20,000 tables per instance.
View storage analysis for a single instance
-
Log on to the DAS console.
-
In the left-side navigation pane, choose Intelligent O&M Center > Instance Monitoring.
-
Find the instance you want to manage and click its instance ID.
-
In the left-side navigation pane, click Storage Analysis.
-
On the Storage Overview and Data Space tabs, review the storage information described in the following table.
| Tab | Section | Description |
|---|---|---|
| Storage Overview | Storage | View storage metrics across four dimensions: Exception, Daily Growth within Seven Days, Available Days of Storage, and Used Storage. Click the |
| Exceptions | View anomalies detected in the database instance. If automatic space optimization is enabled, the space optimization history is also displayed. DAS detects the following exception types: Potential auto-increment primary key overflows (ApsaraDB RDS for MySQL and PolarDB for MySQL only), Duplicate indexes (ApsaraDB RDS for MySQL and PolarDB for MySQL only), and Tablespace fragments (see Automatic tablespace fragment recycling). | |
| Storage Trend | View the storage usage trend over a time range of up to seven days. | |
| Tablespaces | View the storage details of each table. Click a table name to view its Field and Index information. | |
| Data Space | View the storage usage of each database and the tables within it. Click a table name to view its Field and Index information. | |
View global storage usage
If you manage multiple instances with DAS, use the Global Storage Usage page to compare storage consumption across instances by database engine and identify the highest consumers.
The Global Storage Usage page supports the following instance types only:
-
ApsaraDB RDS for MySQL instances
-
Self-managed MySQL databases
-
ApsaraDB for MongoDB instances
-
Self-managed MongoDB databases
Self-managed databases connected to DAS via Direct Access or Centralized DBGateway are not displayed because DAS cannot collect their storage data. For information about connection methods, see Connect a database instance to DAS.
-
Log on to the DAS console.
-
In the left-side navigation pane, choose Tools > Storage Analysis.
-
On the Global Storage Usage page, switch between tabs to view storage usage by engine type.
