All Products
Search
Document Center

DescribeSlowLogTrend

Last Updated: May 29, 2020

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

ParameterTypeExampleDescription
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

ItemsThe information about the trend of slow query logs.
└KeyStringAnalyticDB_SlowLogTrendThe key of the trend of slow query logs. The value is fixed to AnalyticDB_SlowLogTrend.
└SeriesString
└NameStringslow_log_trendThe name of the performance metric.
└ValuesList<String[]>[ [ "2019-05-06T05:17:46.487Z", 5 ], [ "2019-05-06T05:18:20.784Z", 5 ] ]The values of the performance metric.
RequestIdString1AD222E9-E606-4A42-BF6D-8A4442913CEFThe ID of the request.

Examples

Sample requests

  1. http(s)://adb.aliyuncs.com/?Action=DescribeSlowLogTrend
  2. &DBInstanceId=am-uf6wjk5xxxxxxx
  3. &StartTime=2011-05-01Z
  4. &EndTime=2011-05-30Z
  5. &<Common request parameters>

Sample success responses

XML format

  1. <DescribeSlowLogTrendResponse>
  2. <Items>
  3. <SlowLogTrendItem>
  4. <Key>AnalyticDB_SlowLogTrend</Key>
  5. <Series>
  6. <SeriesItem>
  7. <Values>2011-05-06T05:17:46.487Z</Values>
  8. <Values>5</Values>
  9. <Values>2011-05-06T05:18:20.784Z</Values>
  10. <Values>5</Values>
  11. <Name>slow_log_trend</Name>
  12. </SeriesItem>
  13. </Series>
  14. <Unit></Unit>
  15. </SlowLogTrendItem>
  16. </Items>
  17. <RequestId>9BEAD3DA-4CF3-4410-9388-46BD9D34DECB</RequestId>
  18. <EndTime>2011-05-30T00:00:00Z</EndTime>
  19. <StartTime>2011-05-01T00:00:00Z</StartTime>
  20. <DBClusterId>am-xxxxxxxxxx</DBClusterId>
  21. </DescribeSlowLogTrendResponse>

JSON format

  1. {
  2. "Items": {
  3. "SlowLogTrendItem": [
  4. {
  5. "Key": "AnalyticDB_SlowLogTrend",
  6. "Series": {
  7. "SeriesItem": [
  8. {
  9. "Values": [
  10. [
  11. "2011-05-06T05:17:46.487Z",
  12. 5
  13. ],
  14. [
  15. "2011-05-06T05:18:20.784Z",
  16. 5
  17. ]
  18. ],
  19. "Name": "slow_log_trend"
  20. }
  21. ]
  22. },
  23. "Unit": ""
  24. }
  25. ]
  26. },
  27. "RequestId": "9BEAD3DA-4CF3-4410-9388-46BD9D34DECB",
  28. "EndTime": "2011-05-30T00:00:00Z",
  29. "StartTime": "2011-05-01T00:00:00Z",
  30. "DBClusterId": "am-xxxxxxxxxx"
  31. }