How to use storage analysis-Database Autonomy Service(DAS)-阿里云帮助中心

Monitor storage usage, detect anomalies, and view storage trends for your database instances. This topic uses an ApsaraDB RDS for MySQL instance as an example.

Prerequisites

The following database types are supported:

ApsaraDB RDS for MySQL, PolarDB for MySQL, ApsaraDB MyBase for MySQL, and self-managed MySQL
ApsaraDB for MongoDB and self-managed MongoDB
ApsaraDB RDS for PostgreSQL and PolarDB for PostgreSQL
PolarDB for PostgreSQL (Compatible with Oracle)
PolarDB-X 2.0

Usage notes

Storage analysis can analyze up to 20,000 tables.

Storage analysis for a single instance

Log on to the DAS console.
In the navigation pane on the left, click Intelligent O&M Center > Instance Monitoring .
Find the target instance and click the instance ID to open the instance details page.
In the left-side navigation pane, click Storage Analysis.

On the Storage Analysis page, you can view the storage usage of the instance on the Storage Overview and Data Space tabs:

Tab	Section	Description
Storage Overview	Storage	View information such as Exception, Daily Growth within Seven Days, Available Days of Storage, and Used Storage. Note Click the icon to view the detailed description of each metric.
	Exceptions	View anomalies detected in the tables or collections of the instance. If automatic space optimization is enabled, you can also view optimization history in the Exceptions. DAS detects the following anomalies: Auto-increment primary key overflow risk: Automatically detects the risk of auto-increment primary key overflows for ApsaraDB RDS for MySQL and PolarDB for MySQL. Duplicate index detection: Detects duplicate indexes in ApsaraDB RDS for MySQL and PolarDB for MySQL. Tablespace fragment detection: For more information, see Automatic tablespace fragment recycling.
	Storage Trend	View the storage usage trend within the selected time range. Note The time range cannot exceed seven days.
	Tablespaces	View the space usage of each table in the instance. Click a table name to view its Field and Index.
Data Space		View storage usage per database and tablespace usage per table within the instance. Click a table name to view its Field and Index.

Global storage usage

Use the Global Storage Usage page to view storage usage across all your database instances and identify those with the highest space utilization.

Note

The Global Storage Usage page supports the following types of database instances:

ApsaraDB RDS for MySQL
self-managed MySQL
ApsaraDB for MongoDB
self-managed MongoDB

Log on to the DAS console.
In the left-side navigation pane, click Tools > Storage Analysis.
On the Global Storage Usage page, you can switch between the MySQL and MongoDB engines. The table sorts instances by Data Space Utilization in descending order and includes columns such as Instance, Role, Cluster, Data Volume, Data Disk Usage, Data Space Utilization, Remaining Available Days, and Average Daily Growth in Last 7 Days.
DAS cannot collect storage data from self-managed database instances that are connected using Direct Access or Centralized DBGateway. Therefore, these instances do not appear in the Global Storage Usage list.
Note
The following are the connection methods for self-managed databases. For more information, see Connect a database instance to DAS.
- Direct Access: A self-managed database that is connected by using the Direct Access method.
- Centralized DBGateway: A self-managed database that is connected by using a database gateway in centralized mode.