Database Autonomy Service (DAS) provides the storage analysis feature. You can use this feature to view the storage overview of a database instance and the estimated remaining days available. You can also view information about the usage, fragments, and exception 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, ApsaraDB RDS for MySQL instances are used.

Prerequisites

A database instance of one of the following types is created:
  • RDS MySQL
  • PolarDB MySQL
  • ApsaraDB for MongoDB instances
  • Self-managed MongoDB instances

View the storage analysis results of a single database instance

  1. On the Instance Monitoring page, find the database instance that you want to manage and choose Performance > Storage Analysis in the Actions column.
  2. On the Storage Analysis page, you can view the storage overview, usage of data space, exceptions, and storage usage trends of the instance. The following table describes the parameters.
    Parameter Description
    Storage Overview You can view information such as the average daily space usage within the last week, the estimated remaining days available, and the total amount of used space.
    Data Space You can view the usage of each data space and tablespace. You can click the name of a table to view the fields and indexes of the table.
    Storage Trend You can view the usage trends of data space, used storage, log space, and temporary space.
    Exceptions
    • Auto-increment primary key overflow risks: DAS can automatically identify potential auto-increment primary key overflow risks in ApsaraDB RDS for MySQL databases and ApsaraDB PolarDB MySQL-compatible edition databases.
    • Duplicate indexes: DAS can automatically identify duplicate indexes in ApsaraDB RDS for MySQL databases and ApsaraDB PolarDB MySQL-compatible edition databases.
    • Tablespace fragments: For more information, see Automatic space debris recycling.

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. This helps you find the database instance that uses the most storage space.

Note DAS provides the global storage usage ranking feature only for ApsaraDB RDS for MySQL instances, self-managed MySQL instances, ApsaraDB for MongoDB instances, and self-managed MongoDB instances.
  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Storage Analysis. The Global Storage Usage page appears.
    Note DAS cannot collect storage information from directly connected ECS-based self-managed database instances or ECS-based self-managed database instances that are connected to DAS by using a centralized database gateway. Therefore, the Global Storage Usage page does not display information about these database instances.