resetSnapshot - 重置快照
db.resetSnapshot([options])
Sdb
该函数用于清空之前的统计信息,使统计重新进行。主要针对的统计信息包括 TotalDataRead、TotalDataWrite 等。
| 参数名 | 参数类型 | 描述 | 是否必填 |
|---|---|---|---|
| options | object | 指定快照类型、会话 ID、集合空间、集合、命令位置参数 | 否 |
options 格式
| 属性名 | 描述 | 默认值 | 格式 |
|---|---|---|---|
| Type | 指定重置的快照类型,取值如下: "sessions":会话快照 "sessions current":当前会话快照 "database":数据库快照 "health":节点健康检测快照 "collections":集合快照 "all":所有快照 |
"all" | Type:"sessions" |
| SessionID | 指定重置的会话 ID,该参数只在 Type 为"sessions"时有效 | 所有会话 | SessionID: 1 |
| CollectionSpace | 指定需要重置快照统计信息的集合空间名称 | 空 | CollectionSpace:"sample" |
| Collection | 指定需要重置快照统计信息的集合名称 | 空 | Collection:"sample.employee" |
| Location Elements | 命令位置参数 | 所有节点 | GroupName:"db1" |
Note:
CollectionSpace 字段和 Collection 字段只在 Type 为"collections"时有效,且不能同时指定;两个字段都不指定时,默认清空所有集合的快照统计信息。
Type 重置项
| 快照类型 | 重置项 |
|---|---|
| sessions | "TotalDataRead","TotalIndexRead","TotalDataWrite","TotalIndexWrite" "WriteTimeSpent","ResetTimestamp","LastOpType","LastOpBegin" "TotalRead","TotalReadTime","TotalWriteTime","ReadTimeSpent" "LastOpEnd","LastOpInfo","ReadTimeSpent","WriteTimeSpent" "TotalUpdate","TotalDelete","TotalInsert","TotalSelect" |
| sessions current | 与"sessions"重置项相同 |
| database | "TotalDataRead","TotalIndexRead","TotalDataWrite" "svcNetOut","TotalReadTime","TotalWriteTime","TotalIndexWrite", "TotalUpdate","TotalDelete","TotalInsert","TotalSelect","TotalRead" "ReplUpdate","ReplInsert","ReplDelete","svcNetIn" |
| health | "ErrNum":{"SDB_OOM","SDB_NOSPC","SDB_TOO_MANY_OPEN_FD"} |
| collections | "TotalDataRead","TotalIndexRead","TotalDataWrite","TotalIndexWrite" "TotalUpdate","TotalDelete","TotalInsert","TotalSelect" "TotalRead","TotalWrite","TotalTbScan","TotalIxScan" "ResetTimestamp" |
| all | 除了重置上述所有的项,还包括: "TotalTime","TotalContexts" |
函数执行成功时,无返回值。
函数执行失败时,将抛出异常并输出错误信息。
当异常抛出时,可以通过 getLastErrMsg() 获取错误信息或通过 getLastError() 获取错误码。更多错误处理可以参考常见错误处理指南。
v2.0 及以上版本
查看 SessionID 为 22 的会话快照
> db.snapshot(SDB_SNAP_SESSIONS,{"SessionID":22})
{
"NodeName": "sdbserver:31820",
"SessionID": 22,
"TID": 11076,
"Status": "Waiting",
"IsBlocked": false,
"Type": "ShardAgent",
"Name": "Type:Shard,NetID:1,R-TID:12930,R-IP:192.168.20.53,R-Port:11810",
"Doing": "",
"Source": "",
"QueueSize": 0,
"ProcessEventCount": 32,
"RelatedID": "c0a814352e220000000000000016",
"Contexts": [
200
],
"TotalDataRead": 27577,
"TotalIndexRead": 0,
"TotalDataWrite": 0,
"TotalIndexWrite": 0,
"TotalUpdate": 0,
"TotalDelete": 0,
"TotalInsert": 0,
"TotalSelect": 27577,
"TotalRead": 27577,
"TotalReadTime": 0,
"TotalWriteTime": 0,
"ReadTimeSpent": 0,
"WriteTimeSpent": 0,
"ConnectTimestamp": "2019-06-20-13.55.52.646730",
"ResetTimestamp": "2019-06-20-13.55.52.646730",
"LastOpType": "GETMORE",
"LastOpBegin": "--",
"LastOpEnd": "2019-06-20-14.20.22.223637",
"LastOpInfo": "ContextID:200, NumToRead:-1",
"UserCPU": 0.38,
"SysCPU": 0.29
}重置快照
> db.resetSnapshot({Type:"sessions",SessionID:22})查看重置后的会话快照
> db.snapshot(SDB_SNAP_SESSIONS,{"SessionID":22})
{
"NodeName": "sdbserver:31820",
"SessionID": 22,
"TID": 11076,
"Status": "Waiting",
"IsBlocked": false,
"Type": "ShardAgent",
"Name": "Type:Shard,NetID:1,R-TID:12930,R-IP:192.168.20.53,R-Port:11810",
"Doing": "",
"Source": "",
"QueueSize": 0,
"ProcessEventCount": 32,
"RelatedID": "c0a814352e220000000000000016",
"Contexts": [
200
],
"TotalDataRead": 0,
"TotalIndexRead": 0,
"TotalDataWrite": 0,
"TotalIndexWrite": 0,
"TotalUpdate": 0,
"TotalDelete": 0,
"TotalInsert": 0,
"TotalSelect": 0,
"TotalRead": 0,
"TotalReadTime": 0,
"TotalWriteTime": 0,
"ReadTimeSpent": 0,
"WriteTimeSpent": 0,
"ConnectTimestamp": "2019-06-20-13.55.52.646730",
"ResetTimestamp": "2019-06-20-14.23.42.059988",
"LastOpType": "UNKNOW",
"LastOpBegin": "--",
"LastOpEnd": "--",
"LastOpInfo": "",
"UserCPU": 0.38,
"SysCPU": 0.3
}