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 expected number of days after which the remaining storage may be insufficient. You can also view information about the storage 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.

Prerequisites

A database instance is connected to DAS. Make sure that the database instance is one of the following types:
  • An ApsaraDB RDS for MySQL instance
  • An ApsaraDB PolarDB MySQL-compatible edition instance
  • An ApsaraDB for MongoDB instance
  • A self-managed MongoDB instance

View global storage usage

If you use DAS to manage multiple database instances of the same type, you can view the storage usage of each database instance on the Global Storage Usage page. This can help you find the database instance that has the highest storage usage.

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.
In the left-side navigation pane, click Storage Analysis. The Global Storage Usage page appears. You can view information about storage usage of all database instances of the same type.
Note DAS cannot collect storage information from self-managed database instances that are directly connected to DAS or connected to DAS by using a database gateway. Therefore, the Global Storage Usage page does not display information about these database 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 tablespace fragment recycling.