All Products
Search
Document Center

Stoarge analysis

Last Updated: May 30, 2020

You can use the storage analysis feature of DAS to view the space usage profile of a database instance, the remaining days of space available, and the space usage, space debris, and space anomaly diagnosis of a table in the database.

The storage analysis feature is only available to MySQL and MongoDB databases. MySQL databases can be ApsaraDB RDS for MySQL databases and Apsara PolarDB databases. MongoDB databases can be ApsaraDB for MongoDB databases and user-created MongoDB databases. This topic uses ApsaraDB RDS for MySQL databases to demonstrate how to use the storage analysis feature.

Prerequisites

DAS has accessed the database instance. For more information, see Access Instance.

Procedure

View the storage analysis of a single database instance

  1. Log on to the DAS console.

  2. In the left-side navigation pane, click Instance Monitoring.

  3. Find the target instance. Choose Performance > Storage Analysis in the Actions column.Storage Analysis

Storage Analysis page

  1. On the Storage Analysis > Storage Overview tab, you can view data such as the storage overview and storage trend.

  2. On the Storage Analysis > Data Space tab, you can view the storage usage of databases and tables. Click a table name to view the fields and indexes of the table.

View global storage usage

If you have multiple database instances, you can view the storage usage of all database instances on the Global Storage Usage page, and quickly find the database instance with the highest storage usage.

The global storage usage feature is only available to ApsaraDB RDS for MySQL databases, user-created MySQL databases, ApsaraDB for MongoDB databases, and user-created MongoDB databases.

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Storage Analysis to go to the Global Storage Usage page and view related information.Global Storage Usage

The Global Storage Usage page cannot display information of database instances deployed in the direct access and centralized-mode access methods, because their storage data cannot be collected.