All Products
Search
Document Center

ApsaraDB RDS:Use the storage analysis feature

Last Updated:Aug 25, 2023

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, RDS Enterprise Edition, or RDS Cluster Edition

  • MySQL 5.7 on RDS High-availability Edition, RDS Enterprise Edition, or RDS Cluster 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. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
  2. In the left-side navigation pane, choose Autonomy Service > Diagnostics.

  3. On the page that appears, click the Storage Analysis tab.

  4. On the Storage Overview and Data Space tabs, view the storage usage of the RDS instance.

    Tab

    Section

    Description

    Storage Overview

    Storage

    You can view the following storage information: Exception, Avg Daily Increase in Last Week, Available Days of Storage, and Used Storage.

    Note

    You can click the image.png icon to view details about each item.

    Exceptions

    You can view the exception information about tables or collections in the RDS instance. If the automatic space optimization feature is enabled for the RDS instance, you can also view the space optimization history.Exceptions

    DAS can identify the following exceptions:

    • Potential overflows of auto-increment primary keys: DAS automatically identifies potential overflows of auto-increment primary keys in the RDS instance.

    • Duplicate indexes: DAS automatically identifies duplicate indexes in the RDS instance.

    • Tablespace fragment identification: For more information, see Automatic tablespace fragment recycling.

    Storage Trend

    You can view the storage change trend in a specific period of time.

    Note

    The period of time can span a maximum of seven days.

    Tablespaces

    You 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 Field and Index of the table.

    Data Space

    You 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 Field and Index of the table.