AnalyticDB:View and analyze cluster and table data size

View the data size of a cluster

In the Storage Overview section, you can view the following metrics for the current cluster: Total Data Size, Hot Data Size, Cold Data Size, and the Last 24 Hours and Daily Last Week Data Growth .

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Clusters page, find the cluster that you want to manage and click the cluster ID.

2. In the navigation pane on the left, choose Storage Analysis > Storage Overview.

3. In the Storage Overview section, view the Total Data Size, Hot Data Size, Cold Data Size, and Data Growth metrics.

   Metric Category	Metric	Description
   Total Data Size	Total Data Size	The total data size of all tables in the cluster.
   	Hot Data Size	The hot data size of all tables in the cluster. Note For more information about hot data, see Hot and cold data separation.
   	Cold Data Size	The cold data size of all tables in the cluster. Note AnalyticDB for MySQL Data Warehouse Edition clusters in reserved mode do not support hot and cold data separation. Therefore, the cold data size is not displayed. For more information about cold data, see Hot and cold data separation.
   Hot Data Size Note Each table in the cluster has multiple partitions, such as hot partitions and cold partitions. The Total Data Size of each partition is categorized by data type: Table Record,Regular Index, Primary Key Index, and Other.	Table Record	The data size of hot partitions in all tables of the cluster, excluding the data of Regular Index and Primary Key Index.
   	Regular Index	The data size of regular indexes in hot partitions of all tables in the cluster. Note When a table is created in the cluster, a full-column index is created by default. If an index contains a large amount of data, delete idle indexes to reduce the data size. For more information, see Schema optimization.
   	Primary Key Index	The data size of primary key indexes in hot partitions of all tables in the cluster. Note If a primary key index contains a large amount of data, find the table that has a high primary key index ratio in the Table Storage Information section and optimize the index. For more information about table storage information, see View the data size of a table.
   	Other	The size of metadata, temporary data, and other data in hot partitions of all tables in the cluster.
   Cold Data Size Note Each table in the cluster has multiple partitions, such as hot partitions and cold partitions. The Total Data Size of each partition is categorized by data type: Table Record,Regular Index, Primary Key Index, and Other.	Table Record	The data size of cold partitions in all tables of the cluster, excluding the data of Regular Index and Primary Key Index.
   	Regular Index	The data size of regular indexes in cold partitions of all tables in the cluster. Note When a table is created in the cluster, a full-column index is created by default. If an index contains a large amount of data, delete idle indexes to reduce the data size. For more information, see Schema optimization.
   	Primary Key Index	The data size of primary key indexes in cold partitions of all tables in the cluster. Note If a primary key index contains a large amount of data, find the table that has a high primary key index ratio in the Table Storage Information section and optimize the index. For more information about table storage information, see View the data size of a table.
   	Other	The size of metadata, temporary data, and other data in cold partitions of all tables in the cluster.
   Data Growth	Last 24 Hours	The growth of the total data size of the cluster in the last 24 hours. Formula: Data growth in the last 24 hours = Data size at the current point in time - Data size 24 hours ago.
   	Daily Last Week	The average daily growth of the total data size of the cluster over the last week. Formula: Daily average growth over the last week = (Data size at the current point in time - Data size at the same point in time 7 days ago) / 7.

View node-level data size and disk usage

In the Storage Trend section, you can view the node-level data size and disk usage for a specific time period.

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Clusters page, find the cluster that you want to manage and click the cluster ID.

2. In the navigation pane on the left, choose Storage Analysis > Storage Overview.

3. In the Storage Trend section, select a time range from the drop-down list on the right. Alternatively, drag the time curve below the Total Data Size and Node Disk Usage charts to specify a time period.

   Important

   • You can view data from the last 30 days. The maximum time range for each query is 7 days.

   • The metrics in the Total Data Size section vary based on the cluster type. Because Reserved mode clusters do not support separating hot and cold data, the Total Data Size section for these clusters shows only the Total Data Size, Average Data Size of Storage Nodes, and Maximum Data Size of Storage Nodes metrics.

   Data Warehouse Edition (Elastic Mode) and Enterprise, Basic, and Data Lakehouse Edition clusters

   Category	Metric	Description
   Total Data Size	Average Hot Data Size of Storage Nodes	The average hot data size of all data nodes in the cluster.
   	Maximum Hot Data Size of Storage Nodes	The maximum hot data size of all data nodes in the cluster.
   	Hot Data Size	The hot data size of all tables in the cluster.
   	Cold Data Size	The cold data size of all tables in the cluster.
   Node Disk Usage	Average Disk Usage	The average disk usage of all data nodes in the cluster.
   	Maximum Disk Usage	The maximum disk usage of all data nodes in the cluster. Formula: Maximum disk usage = Storage space occupied by the node with the most data/(Maximum hot data size of an elastic I/O unit/0.9) × 100%. Important The storage space occupied by the node with the most data is measured in GB. The storage space of Data Warehouse Edition (Elastic Mode) clusters and Enterprise, Basic, and Data Lakehouse Edition clusters scales out automatically. However, the hot data size of an elastic I/O unit (EIU) is limited to 8 TB. When you calculate the maximum disk usage, use a value of 8000 GB. For example, if the hot data size of a node is 8000 GB, the maximum disk usage of the node is 8000/(8000/0.9) × 100% = 90%.
   	Disk Usage Threshold (90%)	If the maximum disk usage exceeds the cluster lock threshold (90%), the cluster is locked. After the cluster is locked, you can query data but cannot write data. Log on to the Cloud Monitor console and set the alert threshold for maximum disk usage to 80%. This lets you handle issues promptly and prevent the cluster from being locked. For more information, see Create an alert rule.

   Data Warehouse Edition (Reserved Mode)

   Category	Metric	Description
   Total Data Size	Total Data Size	The total data size of all tables in the cluster.
   	Average Data Size of Storage Nodes	The average data size of all data nodes in the cluster.
   	Maximum Data Size of Storage Nodes	The maximum data size of all data nodes in the cluster.
   Node Disk Usage	Average Node Disk Usage	The average disk usage of all data nodes in the cluster.
   	Maximum Disk Usage of Node	The maximum disk usage of all data nodes in the cluster. Formula: Maximum disk usage = (Storage space occupied by the node group with the most data/Storage space of a single node group) × 100%. Note The storage space occupied by the node group with the most data and the storage space of a single node group are measured in GB. For example, you purchase two node groups, and each has 200 GB of storage space. The total data size of all tables in the cluster is 140 GB. The data is distributed with 60 GB in one node group and 80 GB in the other. The maximum disk usage is (80/200) × 100% = 40%.
   	Disk Usage Threshold (90%)	If the maximum disk usage exceeds the cluster lock threshold (90%), the cluster is locked. After the cluster is locked, you can query data but cannot write data. Log on to the Cloud Monitor console and set the alert threshold for maximum disk usage to 80%. This lets you handle issues promptly and prevent the cluster from being locked. For more information, see Create an alert rule.

View the data size of a table

The Table Storage Information section displays details for each table in the cluster, such as its Total Data Size, Hot Data Size, Cold Data Size, and the data size of its Regular Index.

1. Log on to the AnalyticDB for MySQL console. In the upper-left corner of the console, select a region. In the left-side navigation pane, click Clusters. On the Clusters page, find the cluster that you want to manage and click the cluster ID.

2. In the navigation pane on the left, choose Storage Analysis > Storage Overview.

3. In the Table Storage Information section, you can view table metrics such as Total Data Size, Hot Data Size, Cold Data Size, Table Rows, and Partitions.

   Metric	Description
   Database	The name of the database.
   Table Name	The name of the table.
   Storage Percentage	The percentage of the total data size of the table to the total data size of the cluster. Formula: Storage percentage = (Total data size of the table / Total data size of the cluster) × 100%.
   Total Data Size	The total data size of the table. It is calculated using one of the following methods: Method 1: Total Data Size = Hot Data Size + Cold Data Size. Method 2: Total Data Size = Data size of table records + Data size of regular indexes + Data size of primary key indexes + Data size of other data.
   Hot Data Size	The data size of all hot partitions in the table. This includes data of the Table Record, Regular Index, Primary Key Index, and Other types.
   Cold Data Size	The data size of all cold partitions in the table. This includes data of the Table Record, Regular Index, Primary Key Index, and Other types.
   Table Record	The data size of all partitions in the table, excluding data of the Regular Index or Primary Key Index type.
   Regular Index	The data size of regular indexes in all partitions of the table.
   Primary Key Index	The data size of the primary key index in all partitions of the table.
   Other	The size of metadata and temporary data in all partitions of the table.
   Table Rows	The number of rows in the table.
   Partitions	The number of partitions in the table.

Related operations