329      windows

查看慢日誌列表__日誌管理_API 參考_雲數據庫 RDS 版-阿裏雲

描述

說明：用戶可以查詢某日期範圍內、某個用戶實例下、某個DB的慢查詢匯總情況。
支持分頁查詢。SQLServer和MySQL兩種數據庫實例類型，慢查詢返回的SQLs參數值是不一樣的，詳情請見下麵的SQLs參數表

請求參數

返回參數

MySQL的SQLSlowLog參數

SQL Server的SQLSlowLog參數

示例

• 請求示例

https://rds.aliyuncs.com/?Action=DescribeSlowLogs
&DBInstanceId=riauvjz6zajfiq6ba1370329449201
&StartTime=2011-06-11Z
&EndTime=2011-12-11Z
&SortKey= TotalExecutionCounts
&<公共請求參數>

• 返回示例

XML格式：

<DescribeSlowLogsResponse> 
    <RequestId>A5409D02-D661-4BF3-8F3D-0A814D0574E7</RequestId>
    <DBInstanceID>riauvjz6zajfiq6ba1370329449201</DBInstanceID> 
    <Engine>SQLServer</Engine>
    <StartTime>2011-06-11Z</StartTime> 
    <EndTime>2011-12-11Z</EndTime> 
    <TotalRecordCount>1</TotalRecordCount>
    <PageNumber>1</PageNumber>
    <PageRecordCount>1</PageRecordCount>
    <Items>
      <SQLSlowLog>
      <SQLText>update test.zxb set id=0 limit 1</SQLText>
      <SQLServerTotalExecutionCounts>178</SQLServerTotalExecutionCounts>
      <SQLServerTotalExecutionTimes>189</SQLServerTotalExecutionTimes>
      <TotalLogicalReadcounts>89</TotalLogicalReadcounts>
      <TotalPhysicalReadcounts>90</TotalPhysicalReadcounts>
      <ReportTime>2013-11-12Z</ReportTime>
     </SQLSlowLog>
    </Items>
</DescribeSlowLogsResponse>

JSON格式：

{
      "RequestId":"A5409D02-D661-4BF3-8F3D-0A814D0574E7"
"StartTime":"2011-06-11Z ",
"EndTime":"2011-12-11Z ",
"Engine":"SQLServer",
"PageNumber":1,
"PageRecordCount":1,
"TotalRecordCount"：1,
"Items":
{"SQLSlowLog":
[
{ "SQLText":”update test.zxb set id=0 limit 1”
  "SQLServerTotalExecutionCounts":178
  "SQLServerTotalExecutionTimes":189
  "TotalLogicalReadcounts":89
  "TotalPhysicalReadcounts":90
  "ReportTime":"2013-11-12Z "
 }
]
}
}

最後更新：2016-11-23 16:03:53

  上一篇： 修改數據庫參數列表__參數管理_API 參考_雲數據庫 RDS 版-阿裏雲

  下一篇： 查看慢日誌明細__日誌管理_API 參考_雲數據庫 RDS 版-阿裏雲