The diagnosis feature of PolarDB for MySQL integrates with Database Autonomy Service (DAS). This allows you to view database diagnostics and optimization results on multiple tabs. On the Storage Analysis tab, you can check the storage overview for a cluster. For example, you can view the number of available days of storage, tablespace usage status, fragmentation percentage, and exception analysis results.

Precautions

The storage analysis feature can analyze up to 20,000 tables.

Procedure

  1. Log on to the PolarDB console.
  2. In the upper-left corner of the console, select the region in which the cluster that you want to manage is deployed.
  3. On the Clusters page, find the cluster for which you want to enable the autonomy service, and click the cluster ID.
  4. In the left-side navigation pane, choose Diagnostics and Optimization > Diagnosis.
  5. Click the Storage Analysis tab.
    Storage Analysis
  6. On the Storage Analysis tab, you can view the following information.
    • By default, the Space Overview tab appears. On this tab, you can check tablespaces, storage trend, and other related storage data. Space Overview
    • Click the Data Space tab. On this tab, you can check the storage conditions for individual databases and tables. Click a table name to view the fields and indexes of the table. Data Space