Queries the trend of slow query logs of an AnalyticDB for MySQL cluster.
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | DescribeSlowLogTrend | The operation that you want to perform. Set the value to DescribeSlowLogTrend. |
DBClusterId | String | Yes | rm-uf6wjk5xxxxxxxxxx | The ID of the cluster. |
StartTime | String | Yes | 2019-06-01T16:00Z | The beginning of the time range to query. The time must be in UTC. Format: yyyy-MM-ddTHH:mmZ |
EndTime | String | Yes | 2019-06-20T16:00Z | The end of the time range to query. The end time must be later than the start time. The time span between the start time and end time must be less than seven days. The time must be in UTC. Format: yyyy-MM-ddTHH:mm:ssZ |
DBName | String | No | test_db | The name of the database. |
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
DBClusterId | String | rm-uf6wjk5xxxxxxxxxx | The ID of the cluster. |
StartTime | String | 2019-06-01T16:00Z | The beginning of the time range specified for the query. The time is in UTC. Format: yyyy-MM-ddTHH:mmZ |
EndTime | String | 2019-06-20T16:00Z | The end of the time range specified for the query. The end time is later than the start time. The time span between the start time and end time is less than seven days. The time is in UTC. Format: yyyy-MM-ddTHH:mm:ssZ |
Items | The information about the trend of slow query logs. | ||
└Key | String | AnalyticDB_SlowLogTrend | The key of the trend of slow query logs. The value is fixed to AnalyticDB_SlowLogTrend. |
└Series | String | ||
└Name | String | slow_log_trend | The name of the performance metric. |
└Values | List<String[]> | [
[
"2019-05-06T05:17:46.487Z",
5
],
[
"2019-05-06T05:18:20.784Z",
5
]
] | The values of the performance metric. |
RequestId | String | 1AD222E9-E606-4A42-BF6D-8A4442913CEF | The ID of the request. |
Examples
Sample requests
http(s)://adb.aliyuncs.com/?Action=DescribeSlowLogTrend
&DBInstanceId=am-uf6wjk5xxxxxxx
&StartTime=2011-05-01Z
&EndTime=2011-05-30Z
&<Common request parameters>
Sample success responses
XML
format
<DescribeSlowLogTrendResponse>
<Items>
<SlowLogTrendItem>
<Key>AnalyticDB_SlowLogTrend</Key>
<Series>
<SeriesItem>
<Values>2011-05-06T05:17:46.487Z</Values>
<Values>5</Values>
<Values>2011-05-06T05:18:20.784Z</Values>
<Values>5</Values>
<Name>slow_log_trend</Name>
</SeriesItem>
</Series>
<Unit></Unit>
</SlowLogTrendItem>
</Items>
<RequestId>9BEAD3DA-4CF3-4410-9388-46BD9D34DECB</RequestId>
<EndTime>2011-05-30T00:00:00Z</EndTime>
<StartTime>2011-05-01T00:00:00Z</StartTime>
<DBClusterId>am-xxxxxxxxxx</DBClusterId>
</DescribeSlowLogTrendResponse>
JSON
format
{
"Items": {
"SlowLogTrendItem": [
{
"Key": "AnalyticDB_SlowLogTrend",
"Series": {
"SeriesItem": [
{
"Values": [
[
"2011-05-06T05:17:46.487Z",
5
],
[
"2011-05-06T05:18:20.784Z",
5
]
],
"Name": "slow_log_trend"
}
]
},
"Unit": ""
}
]
},
"RequestId": "9BEAD3DA-4CF3-4410-9388-46BD9D34DECB",
"EndTime": "2011-05-30T00:00:00Z",
"StartTime": "2011-05-01T00:00:00Z",
"DBClusterId": "am-xxxxxxxxxx"
}