All Products
Search
Document Center

ApsaraDB RDS:Analyze the storage of an ApsaraDB RDS for MySQL instance

Last Updated:Feb 22, 2024

During database O&M, you need to identify and resolve storage-related issues at the earliest opportunity. You can use the storage analysis feature to view the storage usage and the number of remaining days for which storage is available on an ApsaraDB RDS for MySQL instance. This feature also allows you to view the storage usage of a specified table, tablespace fragments, and exception diagnostic results on the RDS instance. This feature helps you identify storage exceptions at the earliest opportunity to ensure database stability.

Prerequisites

The RDS instance runs RDS High-availability Edition or RDS Cluster Edition.

Note

If your RDS instance runs RDS Basic Edition, you can perform storage analysis in the Database Autonomy Service (DAS) console. For more information, see Storage analysis.

Background information

The storage analysis feature allows you to view the storage usage and the number of remaining days for which storage is available on an RDS instance. This feature also allows you to view the storage usage of a specified table, tablespace fragments, and exception diagnostic results 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 Services > 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.Storage Analysis

    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 move your pointer over image.png to view the details of 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 database instance and the usage of tablespaces in the database.

    You can click the name of a table to view the Field and Index of the table.

References