DescribeSlowLogTrend - Developer‘s Guide| Alibaba Cloud Documentation Center

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"
}