mysql 慢日志 逻辑读_查询慢日志统计

示例

请求示例

http(s)://rds.aliyuncs.com/?Action=DescribeSlowLogs

&DBInstanceId=rm-uf6wjk5xxxxxxx

&StartTime=2011-05-01Z

&EndTime=2011-05-30Z

&

正常返回示例

XML 格式

A5409D02-D661-4BF3-8F3D-0A814D0574E7

rm-uf6wjk5xxxxxxx

SQLServer

2011-06-11Z

2011-12-11Z

1

1

1

update test.zxb set id=0 limit 1

178

189

89

90

2013-11-12Z

JSON 格式

{

"DescribeSlowLogs": {

"RequestId": "A5409D02-D661-4BF3-8F3D-0A814D0574E7",

"DBInstanceID": "rm-uf6wjk5xxxxxxx",

"Engine": "SQLServer",

"StartTime": "2011-06-11Z",

"EndTime": "2011-12-11Z",

"TotalRecordCount": "1",

"PageNumber": "1",

"PageRecordCount": "1",

"Items": {

"SQLSlowLog": {

"SQLText": "update test.zxb set id=0 limit 1",

"SQLServerTotalExecutionCounts": "178",

"SQLServerTotalExecutionTimes": "189",

"TotalLogicalReadcounts": "89",

"TotalPhysicalReadcounts": "90",

"ReportTime": "2013-11-12Z"

}

}

}

}