The diagnostics feature provided by PolarDB for MySQL integrates some features of Database Autonomy Service (DAS), including storage analysis. You can use the storage analysis feature to view information about storage usage in a cluster. For example, you can view the number of available storage days, the storage usage and fragmentation percentage of a table, and the exception statistics.
Precautions
The storage analysis feature can analyze up to 20,000 tables.
Statistics such as the fragmentation percentage on the Data Space tab, except for the physical file size, are generated based on the
information_schema.tablestable. Therefore, some information may not be up to date.After you execute the
OPTIMIZE TABLEstatement, the fragmentation percentage of the table is not immediately updated on the Data Space tab.The
information_schema_stats_expiryparameter specifies the expiration time of cached statistics. The default value is 86,400 seconds, which is 24 hours.You can modify this parameter or execute the
ANALYZE TABLEstatement to view the latest fragmentation percentage.
Procedure
Log on to the PolarDB console.
In the upper-left corner, select the region where the cluster is deployed.
On the Clusters page, click the ID of the cluster.
In the left-side navigation pane, choose .
Click the Storage Analysis tab.
On the Storage Analysis tab, you can view the following information.
By default, you are placed on the Space Overview tab. On this tab, you can view information about storage usage and trends.
Click the Data Space tab. On this tab, you can view the storage usage of individual databases and tables. To view the fields and indexes of a table, click the name of the table.
