文档

关于 SequoiaDB

快速入门

安装

基本操作

数据模型

SQL引擎

FileSystem引擎

S3引擎

系统架构

数据库管理

连接器

驱动

参考手册

SequoiaDB Shell方法

概述

Global

Sdb

SecureSdb

SdbCS

SdbCollection

SdbCursor

SdbQuery

SdbReplicaGroup

SdbNode

SdbDomain

Oma

File

FileContent

Cmd

Remote

Hash

IniFile

Sdbtool

Ssh

System

辅助类型对象

特殊类型对象

操作符

SQL语法

SQL to SequoiaDB 映射表

限制

错误码

故障排除

SAC 管控中心

Web服务

版本信息

resetSnapshot()

语法

db.resetSnapshot( [options] )

重置快照。主要针对一些统计信息,比如TotalDataRead、TotalDataWrite等。它的作用是清空之前的统计,重新开始统计。

参数描述

参数名 参数类型 描述 是否必填
options Json 对象 设定快照类型、会话号、命令位置参数
  1. options 格式

    属性名 描述 默认值 格式
    Type 指定重置的快照类型。取值:
    "sessions"
    "sessions current"
    "database"
    "health"
    "collections"
    "all"
    "all" Type: "sessions"
    SessionID 指定重置的会话ID。 所有会话 SessionID: 1
    CollectionSpace 指定需要重置快照统计信息的集合空间名称,字符串类型。 CollectionSpace : "foo"
    Collection 指定需要重置快照统计信息的集合名称,字符串类型。需要为集合全名。 Collection : "foo.bar"
    Location Elements 命令位置参数 所有节点 GroupName:"db1"

    Note:

    • Type: "all" 表示重置所有快照。
    • SessionID 字段只在 Type: "sessions" 才生效。
    • CollectionSpace 字段和 Collection 字段只在 Type : "collections" 时生效;CollectionSpace 字段和 Collection 字段不能同时指定;Collection 字段和 CollectionSpace 字段不指定时为清空所有所有集合的快照统计信息。
  2. 重置项

    快照类型 重置项
    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","totalLobRead","TotalDataWrite"
    "svcNetOut","totalReadTime","totalWriteTime","resetTimestamp"
    "TotalIndexWrite","totalLobWrite","totalUpdate","totalDelete"
    "totalInsert","totalSelect","totalRead","receiveNum"
    "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"

返回值

无返回值,出错抛异常,并输出错误信息。可以通过 getLastErrObj()getLastErrMsg() 获取错误信息 或 通过 getLastError() 获取错误码。

关于错误处理可以参考常见错误处理指南

示例

  • 重置 SessionID 为22的快照。

    重置前:

    >db.snapshot(SDB_SNAP_CONTEXTS,{"SessionID":22})
    {
    "NodeName": "u1604-nzb:31820",
    "SessionID": 22,
    "TID": 11076,
    "Status": "Waiting",
    "Type": "ShardAgent",
    "Name": "Type:Shard,NetID:1,R-TID:12930,R-IP:192.168.20.53,R-Port:11810",
    "QueueSize": 0,
    "ProcessEventCount": 32,
    "RelatedID": "c0a814352e2200003282",
    "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 : "session", SessionID: 22})
    Takes 0.001436s.

    重置后:

    >db.snapshot(SDB_SNAP_CONTEXTS,{"SessionID":22})
    {
    "NodeName": "u1604-nzb:31820",
    "SessionID": 22,
    "TID": 11076,
    "Status": "Waiting",
    "Type": "ShardAgent",
    "Name": "Type:Shard,NetID:1,R-TID:12930,R-IP:192.168.20.53,R-Port:11810",
    "QueueSize": 0,
    "ProcessEventCount": 32,
    "RelatedID": "c0a814352e2200003282",
    "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
    }
回到顶部