Database Autonomy Service (DAS) provides the storage analysis feature. You can use this feature to view the storage usage of a database instance and the number of days for which the remaining storage space of the database instance is available. You can also view information about the usage, fragments, and anomaly diagnosis results of a tablespace in a database. This topic provides an example to describe how to use the storage analysis feature. In this example, an ApsaraDB RDS for MySQL instance is used.
The following types of database services are supported:
ApsaraDB RDS for MySQL, PolarDB for MySQL, ApsaraDB MyBase for MySQL, and self-managed MySQL databases
ApsaraDB for MongoDB and self-managed MongoDB databases
ApsaraDB RDS for PostgreSQL and PolarDB for PostgreSQL databases
PolarDB for PostgreSQL (Compatible with Oracle) databases
PolarDB-X 2.0 databases
You can use the storage analysis feature to analyze up to 20,000 tables.
View the storage analysis results of a single database instance
Log on to the DAS console.
In the left-side navigation pane, click Instance Monitoring.
On the page that appears, find the database instance that you want to manage and click the 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 database instance.Storage Analysis
You can view the storage information collected in the following dimensions: Exception, Avg Daily Increase in Last Week, Available Days of Storage, and Used Storage.Note
You can click the icon next to a dimension to view the detailed information.
You can view the exception information about tables or collections in the database instance. If the automatic space optimization feature is enabled for the database instance, you can also view the space optimization history.
DAS can identify the following exceptions:
Potential auto-increment primary key overflows: DAS can automatically identify potential overflows of auto-increment primary keys in ApsaraDB RDS for MySQL instances and PolarDB for MySQL clusters.
Duplicate indexes: DAS can automatically identify duplicate indexes in ApsaraDB RDS for MySQL instances and PolarDB for MySQL clusters.
Tablespace fragments: For more information, see Automatic tablespace fragment recycling.
You can view the usage trend within the specified time range.Note
The time range can be up to seven days.
You can view the detailed information and storage usage of each table in the database instance. Click the name of a table to view the Field and Index of the table.
You can view the storage usage of each database in the RDS instance and the storage usage of tables in the database.
Click the name of a table to view the Field and Index of the table.
View global storage usage
If you use DAS to manage multiple database instances, you can view the storage usage of the database instances by engine on different tabs on the Global Storage Usage page. This helps you find the database instance that has the highest storage usage.
The Global Storage Usage page displays the storage usage of the following types of database instances:
ApsaraDB RDS for MySQL instances
Self-managed MySQL databases
ApsaraDB for MongoDB instances
Self-managed MongoDB databases
Log on to the DAS console.
In the left-side navigation pane, click Storage Analysis. On the Global Storage Usage page, view the storage usage of the database instances by engine on different tabs.
Self-managed databases that are connected to DAS by using the Direct Access or Centralized DBGateway method are not displayed on the Global Storage Usage page because DAS cannot collect their storage data.Note
Self-managed databases can be connected to DAS by using the following methods. For more information about how to connect self-managed databases to DAS, see Access instances.
Direct Access: Self-managed databases are directly connected to DAS after the database accounts and passwords are entered.
Centralized DBGateway: Self-managed databases are connected to DAS by using DBGateway in centralized mode.