Queries the performance data of a node in a PolarDB cluster.

  • The monitoring data is collected once every 5 seconds:
    • If the query time range is less than or equal to 1 hour, the data is displayed at intervals of 5 seconds.
    • If the query time range is less than or equal to 1 day, the data is displayed at intervals of 1 minute.
    • If the query time range is less than or equal to 7 days, the data is displayed at intervals of 10 minutes.
    • If the query time range is less than or equal to 30 days, the data is displayed at intervals of 1 hour.
    • If the query time range is greater than 30 days, the data is displayed at intervals of 1 day.
  • The monitoring data is collected once every 60 seconds:
    • If the query time range is less than or equal to 1 day, the data is displayed at intervals of 1 minute.
    • If the query time range is less than or equal to 7 days, the data is displayed at intervals of 10 minutes.
    • If the query time range is less than or equal to 30 days, the data is displayed at intervals of 1 hour.
    • When the query time range is greater than 30 days, the data is displayed at intervals of 1 day.
Note By default, the monitoring data is collected once every 60 seconds. You can call the ModifyDBClusterMonitor operation to set the data collection interval to every 5 seconds.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Request parameters

Parameter Type Required Example Description
Action String No DescribeDBNodePerformance

The operation that you want to perform. Set the value to DescribeDBNodePerformance.

DBNodeId String Yes pi-*************

The ID of the cluster node.
EndTime String Yes 2020-09-23T01:01Z

The end of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mmZ format. The time must be in UTC.

Key String Yes PolarDBDiskUsage

The performance indicators that you want to query. Separate multiple indicators with commas (,). For more information, see Performance parameters.

Note You can specify a maximum of five performance indicators.
StartTime String Yes 2020-09-23T01:00Z

The beginning of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mmZ format. The time must be in UTC.

DBClusterId String No pc-****************

The ID of the cluster.

Response parameters

Parameter Type Example Description
DBNodeId String pi-*****************

The ID of the cluster node.
DBType String MySQL

The engine of the database.
DBVersion String 8.0

The version of the database engine.
EndTime String 2020-09-23T01:01:00Z

The end of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time must be in UTC.

PerformanceKeys Array of PerformanceItem

The list of cluster performance indicators.
PerformanceItem
Measurement String PolarDBDiskUsage

The performance indicator.
MetricName String mean_sys_dir_size

The name of the metric.
Points Array of PerformanceItemValue

The array of performance metrics.
PerformanceItemValue
Timestamp Long 1600822800000

The timestamp of the metric. This value is a UNIX timestamp. Unit: millisecond.
Value String 9.33

The value of the metric data.
RequestId String E2FDB684-751D-424D-98B9-704BEA******

The ID of the request.
StartTime String 2020-09-23T01:00:00Z

The beginning of the time range to query. Specify the time in the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time must be in UTC.

Examples

Sample request

http(s)://polardb.aliyuncs.com/? Action=DescribeDBNodePerformance
&DBNodeId=pi-*************
&EndTime=2020-09-23T01:01Z
&Key=PolarDBDiskUsage
&StartTime=2020-09-23T01:00Z
&<Common request parameters>

Sample success responses

XML format 

<DescribeDBNodePerformanceResponse>
  <PerformanceKeys>
        <PerformanceItem>
              <Measurement>PolarDBDiskUsage</Measurement>
              <MetricName>mean_binlog_size</MetricName>
              <Points>
                    <PerformanceItemValue>
                          <Value>0.00</Value>
                          <Timestamp>1600822800000</Timestamp>
                    </PerformanceItemValue>
              </Points>
        </PerformanceItem>
        <PerformanceItem>
              <Measurement>PolarDBDiskUsage</Measurement>
              <MetricName>mean_data_size</MetricName>
              <Points>
                    <PerformanceItemValue>
                          <Value>42.38</Value>
                          <Timestamp>1600822800000</Timestamp>
                    </PerformanceItemValue>
              </Points>
        </PerformanceItem>
        <PerformanceItem>
              <Measurement>PolarDBDiskUsage</Measurement>
              <MetricName>mean_log_size</MetricName>
              <Points>
                    <PerformanceItemValue>
                          <Value>4393.63</Value>
                          <Timestamp>1600822800000</Timestamp>
                    </PerformanceItemValue>
              </Points>
        </PerformanceItem>
        <PerformanceItem>
              <Measurement>PolarDBDiskUsage</Measurement>
              <MetricName>mean_other_log_size</MetricName>
              <Points>
                    <PerformanceItemValue>
                          <Value>1.63</Value>
                          <Timestamp>1600822800000</Timestamp>
                    </PerformanceItemValue>
              </Points>
        </PerformanceItem>
        <PerformanceItem>
              <Measurement>PolarDBDiskUsage</Measurement>
              <MetricName>mean_redolog_size</MetricName>
              <Points>
                    <PerformanceItemValue>
                          <Value>4096.00</Value>
                          <Timestamp>1600822800000</Timestamp>
                    </PerformanceItemValue>
              </Points>
        </PerformanceItem>
        <PerformanceItem>
              <Measurement>PolarDBDiskUsage</Measurement>
              <MetricName>mean_sys_dir_size</MetricName>
              <Points>
                    <PerformanceItemValue>
                          <Value>9.33</Value>
                          <Timestamp>1600822800000</Timestamp>
                    </PerformanceItemValue>
              </Points>
        </PerformanceItem>
        <PerformanceItem>
              <Measurement>PolarDBDiskUsage</Measurement>
              <MetricName>mean_tmp_dir_size</MetricName>
              <Points>
                    <PerformanceItemValue>
                          <Value>0.00</Value>
                          <Timestamp>1600822800000</Timestamp>
                    </PerformanceItemValue>
              </Points>
        </PerformanceItem>
        <PerformanceItem>
              <Measurement>PolarDBDiskUsage</Measurement>
              <MetricName>mean_undolog_size</MetricName>
              <Points>
                    <PerformanceItemValue>
                          <Value>296.00</Value>
                          <Timestamp>1600822800000</Timestamp>
                    </PerformanceItemValue>
              </Points>
        </PerformanceItem>
  </PerformanceKeys>
  <DBVersion>8.0</DBVersion>
  <RequestId>E2FDB684-751D-424D-98B9-704BEA******</RequestId>
  <EndTime>2020-09-23T01:01:00Z</EndTime>
  <StartTime>2020-09-23T01:00:00Z</StartTime>
  <DBNodeId>pi-*****************</DBNodeId>
  <DBType>MySQL</DBType>
</DescribeDBNodePerformanceResponse>

JSON format 

{
	"PerformanceKeys": {
		"PerformanceItem": [
			{
				"Measurement": "PolarDBDiskUsage",
				"MetricName": "mean_binlog_size",
				"Points": {
					"PerformanceItemValue": [
						{
							"Value": "0.00",
							"Timestamp": 1600822800000
						}
					]
				}
			},
			{
				"Measurement": "PolarDBDiskUsage",
				"MetricName": "mean_data_size",
				"Points": {
					"PerformanceItemValue": [
						{
							"Value": "42.38",
							"Timestamp": 1600822800000
						}
					]
				}
			},
			{
				"Measurement": "PolarDBDiskUsage",
				"MetricName": "mean_log_size",
				"Points": {
					"PerformanceItemValue": [
						{
							"Value": "4393.63",
							"Timestamp": 1600822800000
						}
					]
				}
			},
			{
				"Measurement": "PolarDBDiskUsage",
				"MetricName": "mean_other_log_size",
				"Points": {
					"PerformanceItemValue": [
						{
							"Value": "1.63",
							"Timestamp": 1600822800000
						}
					]
				}
			},
			{
				"Measurement": "PolarDBDiskUsage",
				"MetricName": "mean_redolog_size",
				"Points": {
					"PerformanceItemValue": [
						{
							"Value": "4096.00",
							"Timestamp": 1600822800000
						}
					]
				}
			},
			{
				"Measurement": "PolarDBDiskUsage",
				"MetricName": "mean_sys_dir_size",
				"Points": {
					"PerformanceItemValue": [
						{
							"Value": "9.33",
							"Timestamp": 1600822800000
						}
					]
				}
			},
			{
				"Measurement": "PolarDBDiskUsage",
				"MetricName": "mean_tmp_dir_size",
				"Points": {
					"PerformanceItemValue": [
						{
							"Value": "0.00",
							"Timestamp": 1600822800000
						}
					]
				}
			},
			{
				"Measurement": "PolarDBDiskUsage",
				"MetricName": "mean_undolog_size",
				"Points": {
					"PerformanceItemValue": [
						{
							"Value": "296.00",
							"Timestamp": 1600822800000
						}
					]
				}
			}
		]
	},
	"DBVersion": "8.0",
	"RequestId": "E2FDB684-751D-424D-98B9-704BEA******",
	"EndTime": "2020-09-23T01:01:00Z",
	"StartTime": "2020-09-23T01:00:00Z",
	"DBNodeId": "pi-*****************",
	"DBType": "MySQL"
}

Error codes

For a list of error codes, visit the API Error Center.