Category | Metric | Description |
Total Data Size | Total Data Size | The total data size of all tables in the AnalyticDB for MySQL cluster. |
Hot Data Size | The hot data size of all tables in the AnalyticDB for MySQL cluster. |
Cold Data Size | The cold data size of all tables in the AnalyticDB for MySQL cluster. Note AnalyticDB for MySQL Data Warehouse Edition (V3.0) clusters in reserved mode do not support separation of hot and cold data storage. For these clusters, the cold data size is not displayed. For more information about cold data, see Separation of hot and cold data storage.
|
Hot Data Size Note Each table of an AnalyticDB for MySQL cluster contains multiple partitions, such as hot data partitions and cold data partitions. The Total Data Size parameter of each partition is divided into the following data types: Table Record, Regular Index, Primary Key Index, and Other. | Table Record | The data size of hot partitions in all tables of the AnalyticDB for MySQL cluster, excluding data of the Regular Index or Primary Key Index type. |
Regular Index | The data size of regular indexes in hot partitions of all tables of the AnalyticDB for MySQL cluster. Note When you create a table in an AnalyticDB for MySQL cluster, a full-column index is created by default. If indexes contain large amounts of data, you can delete specific 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 of the AnalyticDB for MySQL cluster. Note If specific primary key indexes contain large amounts of data, you can find the tables that contain the primary key indexes in the Table Storage Information section and optimize the indexes. For information about the Table Storage Information section, see the "View the data size of a table" section of this topic. |
Other | The size of metadata and temporary data in hot partitions of all tables of the AnalyticDB for MySQL cluster. |
Cold Data Size Note Each table of an AnalyticDB for MySQL cluster contains multiple partitions, such as hot data partitions and cold data partitions. The Total Data Size parameter of each partition is divided into the following data types: Table Record, Regular Index, Primary Key Index, and Other. | Table Record | The data size of cold partitions in all tables of the AnalyticDB for MySQL cluster, excluding data of the Regular Index or Primary Key Index type. |
Regular Index | The data size of regular indexes in cold partitions of all tables of the AnalyticDB for MySQL cluster. Note When you create a table in an AnalyticDB for MySQL cluster, a full-column index is created by default. If indexes contain large amounts of data, you can delete specific 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 of the AnalyticDB for MySQL cluster. Note If specific primary key indexes contain large amounts of data, you can find the tables that contain the primary key indexes in the Table Storage Information section and optimize the indexes. For information about the Table Storage Information section, see the "View the data size of a table" section of this topic. |
Other | The size of metadata and temporary data in cold partitions of all tables of the AnalyticDB for MySQL cluster. |
Data Growth | Last 24 Hours | The growth of the total data size of the AnalyticDB for MySQL cluster within the last 24 hours. Formula: Data growth within the last 24 hours = Data size collected at the current time - Data size collected 24 hours ago . |
Daily Last Week | The daily growth of the total data size of the AnalyticDB for MySQL cluster within the last week. Formula: Daily growth within the last week = (Data size collected at the current time - Data size collected at the same time seven days ago)/7 . |