This topic provides an overview of the Storage Analysis function in RDS for MySQL. With this function, you can view the space overview, change trend, exception list, table space, and data space.

CloudDBA in RDS for MySQL helps you to detect database space exceptions in a timely manner and hence guarantee database stability.

Prerequisites

The MySQL version and RDS edition are as follows:

  • MySQL 8.0 High-availability Edition
  • MySQL 5.7 High-availability Edition/Enterprise Edition
  • MySQL 5.6
  • MySQL 5.5

View the Storage Analysis page

  1. Log on to the RDS console.
  2. Select the target region.Select a region
  3. Find the target RDS instance and click the instance ID.
  4. In the left-side navigation pane, choose CloudDBA > Storage Analysis.
  5. In the upper-left corner, click Reanalyse. Then, wait until the analysis is complete.
  6. Select the Overview or Data Space tab to view the analysis results.

Obtain an overview of space usage

  • Storage
    Parameter Description
    Anomaly

    The number of space exceptions in your RDS instance. Space exceptions come in the following types:

    • The space usage exceeds 90%.
    • The number of days within which space is available is less than 7.
    • The recyclable space is greater than 60 GB, and the fragmentation rate is greater than 5%.
    • A single table takes more than 6 GB, and the fragmentation rate is greater than 30%.
    • A single table takes more than 50 GB.
    • The number of rows in a single table exceeds 5 million, and the average row length exceeds 10 KB.
    Avg Daily Growth in Last Week

    The average daily growth in database space within the last seven days. This average daily growth is calculated by using the following formula: Average daily growth = (Current space size – Space size seven days ago)/7.

    Note
    • 0 B indicates that the space size has not increased or even decreased.
    • This parameter is used as a reference when your business is running stably. It may be inaccurate in the event of abrupt space changes due to operations such as batch import, deletion of historical data , instance migration, and instance reconstruction.
    Available Days of Storage

    The estimated number of days during which space is available. This number of days is calculated by using the following formula: Number of days = Size of available space/Average daily growth in database space within the last seven days.

    Note
    • 90+ indicates that the system predicts that disk space remains available for a long period of time.
    • This parameter is used as a reference when your business is running stably. It may be inaccurate in the event of abrupt space changes due to operations such as batch import, deletion of historical data , instance migration, and instance reconstruction.
    Used Storage

    The total size of used space in all space.

    Storage
  • Anomalies
    This section displays exception details. You can locate space exceptions based on the exception details.Anomalies section
  • Storage Trend
    This section displays the space trends within the last seven days, including the trends of the used space, data space, log space, and temporary space.Storage Trend section
  • Tablespaces
    This section displays the space usage for all tables, including the tables pace size, proportion of tablespace, index space, and data space.
    Note You can click the name of a table to view the fields and indexes in the table.
    Tablespaces section

View data space

This tab displays the space size and tablespace of each database in your RDS for MySQL instance.
Note
  • You can click a database to view its tablespace information.
  • You can click the name of a table to view the fields and indexes in the table.
Data Space tab