Database Autonomy Service (DAS) provides the storage analysis feature for ApsaraDB RDS for MySQL. This feature allows you to view the storage usage and the number of remaining days for which storage is available of your ApsaraDB RDS for MySQL instance. This feature also allows you to view the storage usage, fragmentation, and exception diagnostic results of a table on the RDS instance. This feature helps you identify storage exceptions at the earliest opportunity to ensure database stability.

Prerequisites

Your RDS instance runs one of the following MySQL versions and RDS editions:
  • MySQL 8.0 on RDS High-availability Edition or RDS Enterprise Edition
  • MySQL 5.7 on RDS High-availability Edition or RDS Enterprise Edition
  • MySQL 5.6 on RDS High-availability Edition
  • MySQL 5.5 on RDS High-availability Edition

Background information

The storage analysis feature allows you to view the storage usage and the number of remaining days for which storage is available of your ApsaraDB RDS for MySQL instance. This feature also allows you to view the storage usage, fragmentation, and exception diagnostic results of a table on the RDS instance.

Usage notes

You can use the storage analysis feature to analyze up to 20,000 tables.

Procedure

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, choose Autonomy Service > Diagnostics.
  3. Click the Storage Analysis tab.
  4. On the Storage Overview and Data Space tabs, view the storage usage of the RDS instance.
    TabSectionDescription
    Storage OverviewStorageYou can view the following storage information: Exception, Avg Daily Increase in Last Week, Available Days of Storage, and Used Storage.
    ExceptionsYou can view the exception information about tables or collections in the RDS instance.

    You can click Automatic Space Optimization to enable the automatic storage expansion feature for the RDS instance. If the storage capacity of the RDS instance is insufficient, the system automatically expands the storage capacity. This ensures business stability.

    You can click Optimization History to view the storage optimization history of the RDS instance.

    DAS can identify the following exceptions:
    Storage TrendYou can view the storage trend of the RDS instance in the most recent week.
    TablespacesYou can view information such as the storage usage of each table on the RDS instance. You can click the name of a table to view the fields and indexes of the table.
    Data SpaceYou can view the storage usage of each database in the RDS instance and the storage usage of tables in the database.

    You can click the name of a table to view the fields and indexes of the table.