Database Autonomy Service (DAS) provides the storage analysis feature. This feature allows you to view the storage usage of a database instance and the number of days for which the remaining storage of a database instance is available. The storage analysis feature also provides the storage information about each table in a database, such as the storage usage, information about tablespace fragments, and diagnostic reports on storage exceptions.

Procedure

  1. Log on to the DAS console.
  2. In the left-side navigation pane, click Instance Monitoring.
  3. Find the database instance that you want to manage and click the instance ID. The instance details page appears.
  4. In the left-side navigation pane, click Storage Analysis. On the Storage Overview and Data Space tabs, you can view information such as Exceptions and the Storage Trend. The following table describes the parameters on the Storage Analysis tab.
    ss
    Parameter Description
    Storage Overview You can view information such as Average Daily Increase in Last Week, Available Days of Storage, and Used Storage.
    Data Space You can view the usage of each Data Space and each Table Storage. You can click the name of a table to view the fields and indexes of the table.
    Storage Trend You can view the changing trend of Local Binlog Size, Data Space Used, Log Space Used, Other Log Space, Local Redo Log Size, System Space Used, Temporary Space Used, Average Undolog Size, Total Instance Space.
    Exceptions
    • Potential auto-increment primary key overflows: DAS can automatically identify potential overflows of auto-increment primary keys 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.
    • Abnormal SQL requests: For more information, see Abnormal SQL request identification.