查看慢日志列表的方法

描述


用户可以查询某日期范围内、某个用户实例下、某个DB的慢查询汇总情况，支持分页查询。对于SQL Server和MySQL两种实例类型，慢查询返回的SQLSlowLog参数值是不一样的，详情请见下面的SQLSlowLog参数表。

请求参数

• 
  请求示例
  1. [backcolor=transparent] https[backcolor=transparent] :[backcolor=transparent] //rds.aliyuncs.com/?Action=DescribeSlowLogs
  2. [backcolor=transparent]&[backcolor=transparent]DBInstanceId[backcolor=transparent]=[backcolor=transparent]riauvjz6zajfiq6ba1370329449201
  3. [backcolor=transparent]&[backcolor=transparent]StartTime[backcolor=transparent]=[backcolor=transparent]2011[backcolor=transparent]-[backcolor=transparent]06[backcolor=transparent]-[backcolor=transparent]11Z
  4. [backcolor=transparent]&[backcolor=transparent]EndTime[backcolor=transparent]=[backcolor=transparent]2011[backcolor=transparent]-[backcolor=transparent]12[backcolor=transparent]-[backcolor=transparent]11Z
  5. [backcolor=transparent]&[backcolor=transparent]SortKey[backcolor=transparent]=[backcolor=transparent] [backcolor=transparent]TotalExecutionCounts
  6. [backcolor=transparent]&<公共请求参数>
• 
  返回示例
  XML格式：
  1. [backcolor=transparent] <DescribeSlowLogsResponse>[backcolor=transparent]
  2. [backcolor=transparent]  [backcolor=transparent]<RequestId>[backcolor=transparent]A5409D02-D661-4BF3-8F3D-0A814D0574E7[backcolor=transparent]</RequestId>
  3. [backcolor=transparent]  [backcolor=transparent]<DBInstanceID>[backcolor=transparent]riauvjz6zajfiq6ba1370329449201[backcolor=transparent]</DBInstanceID>[backcolor=transparent]
  4. [backcolor=transparent]  [backcolor=transparent]<Engine>[backcolor=transparent]SQLServer[backcolor=transparent]</Engine>
  5. [backcolor=transparent]  [backcolor=transparent]<StartTime>[backcolor=transparent]2011-06-11Z[backcolor=transparent]</StartTime>[backcolor=transparent]
  6. [backcolor=transparent]  [backcolor=transparent]<EndTime>[backcolor=transparent]2011-12-11Z[backcolor=transparent]</EndTime>[backcolor=transparent]
  7. [backcolor=transparent]  [backcolor=transparent]<TotalRecordCount>[backcolor=transparent]1[backcolor=transparent]</TotalRecordCount>
  8. [backcolor=transparent]  [backcolor=transparent]<PageNumber>[backcolor=transparent]1[backcolor=transparent]</PageNumber>
  9. [backcolor=transparent]  [backcolor=transparent]<PageRecordCount>[backcolor=transparent]1[backcolor=transparent]</PageRecordCount>
  10. [backcolor=transparent]  [backcolor=transparent]<Items>
  11. [backcolor=transparent]    [backcolor=transparent]<SQLSlowLog>
  12. [backcolor=transparent]    [backcolor=transparent]<SQLText>[backcolor=transparent]update test.zxb set id=0 limit 1[backcolor=transparent]</SQLText>
  13. [backcolor=transparent]    [backcolor=transparent]<SQLServerTotalExecutionCounts>[backcolor=transparent]178[backcolor=transparent]</SQLServerTotalExecutionCounts>
  14. [backcolor=transparent]    [backcolor=transparent]<SQLServerTotalExecutionTimes>[backcolor=transparent]189[backcolor=transparent]</SQLServerTotalExecutionTimes>
  15. [backcolor=transparent]    [backcolor=transparent]<TotalLogicalReadcounts>[backcolor=transparent]89[backcolor=transparent]</TotalLogicalReadcounts>
  16. [backcolor=transparent]    [backcolor=transparent]<TotalPhysicalReadcounts>[backcolor=transparent]90[backcolor=transparent]</TotalPhysicalReadcounts>
  17. [backcolor=transparent]    [backcolor=transparent]<ReportTime>[backcolor=transparent]2013-11-12Z[backcolor=transparent]</ReportTime>
  18. [backcolor=transparent]   [backcolor=transparent]</SQLSlowLog>
  19. [backcolor=transparent]  [backcolor=transparent]</Items>
  20. [backcolor=transparent]</DescribeSlowLogsResponse>
  
  JSON格式：
  1. [backcolor=transparent]{
  2. [backcolor=transparent]    [backcolor=transparent]"RequestId"[backcolor=transparent]:[backcolor=transparent]"A5409D02-D661-4BF3-8F3D-0A814D0574E7"
  3. [backcolor=transparent]"StartTime"[backcolor=transparent]:[backcolor=transparent]"2011-06-11Z "[backcolor=transparent],
  4. [backcolor=transparent]"EndTime"[backcolor=transparent]:[backcolor=transparent]"2011-12-11Z "[backcolor=transparent],
  5. [backcolor=transparent]"Engine"[backcolor=transparent]:[backcolor=transparent]"SQLServer"[backcolor=transparent],
  6. [backcolor=transparent]"PageNumber"[backcolor=transparent]:[backcolor=transparent]1[backcolor=transparent],
  7. [backcolor=transparent]"PageRecordCount"[backcolor=transparent]:[backcolor=transparent]1[backcolor=transparent],
  8. [backcolor=transparent]"TotalRecordCount"[backcolor=transparent]：[backcolor=transparent]1[backcolor=transparent],
  9. [backcolor=transparent]"Items"[backcolor=transparent]:
  10. [backcolor=transparent]{[backcolor=transparent]"SQLSlowLog"[backcolor=transparent]:
  11. [backcolor=transparent][
  12. [backcolor=transparent]{[backcolor=transparent] [backcolor=transparent]"SQLText"[backcolor=transparent]:”[backcolor=transparent]update test[backcolor=transparent].[backcolor=transparent]zxb [backcolor=transparent]set[backcolor=transparent] id[backcolor=transparent]=[backcolor=transparent]0[backcolor=transparent] limit [backcolor=transparent]1[backcolor=transparent]”
  13. [backcolor=transparent]"SQLServerTotalExecutionCounts"[backcolor=transparent]:[backcolor=transparent]178
  14. [backcolor=transparent]"SQLServerTotalExecutionTimes"[backcolor=transparent]:[backcolor=transparent]189
  15. [backcolor=transparent]"TotalLogicalReadcounts"[backcolor=transparent]:[backcolor=transparent]89
  16. [backcolor=transparent]"TotalPhysicalReadcounts"[backcolor=transparent]:[backcolor=transparent]90
  17. [backcolor=transparent]"ReportTime"[backcolor=transparent]:[backcolor=transparent]"2013-11-12Z "
  18. [backcolor=transparent]}
  19. [backcolor=transparent]]
  20. [backcolor=transparent]}
  21. [backcolor=transparent]}