数据库快照

数据库快照可以列出数据库的状态和监控信息。

Note:

协调节点通过聚合所有节点的数据（非协调节点字段信息）得到协调节点字段信息。用户可以通过 coord.snapshot(SDB_SNAP_DATABASE,{RawData:true}) 获取聚合前的数据。

标识

SDB_SNAP_DATABASE

非协调节点字段信息

协调节点字段信息

Note:

当存在异常节点时才显示 ErrNodes 字段。

示例

• 通过非协调节点查看快照

  > db.snapshot( SDB_SNAP_DATABASE )

  输出结果如下：

  {
   "NodeName": "hostname1:11810",
   "HostName": "hostname1",
   "ServiceName": "11810",
   "GroupName": "group1",
   "IsPrimary": false,
   "ServiceStatus": true,
   "Status": "Normal",
   "FTStatus": "",
   "BeginLSN": {
     "Offset": 0,
     "Version": 1
   },
   "CurrentLSN": {
     "Offset": -1,
     "Version": 0
   },
   "CommittedLSN": {
     "Offset": -1,
     "Version": 0
   },
   "CompleteLSN": -1,
   "LSNQueSize": 0,
   "TransInfo": {
     "TotalCount": 0,
     "BeginLSN": -1
   },
   "NodeID": [
     1000,
     1000
   ],
   "Version": {
     "Major": 1,
     "Minor": 8,
     "Fix": 0,
     "Release": 13971,
     "GitVersion": "7b21adc4206894102682a621a4b49f17ed96a46f",
     "Build": "2014-08-07-11.04.12(Debug)"
   },
   "CurrentActiveSessions": 18,
   "CurrentIdleSessions": 0,
   "CurrentSystemSessions": 5,
   "CurrentContexts": 1,
   "ReceivedEvents": 0,
   "Role": "data",
   "Disk": {
     "DatabasePath": "/home/users/sdbadmin/sequoiadb",
     "LoadPercent": 46,
     "TotalSpace": 84543193088,
     "FreeSpace": 45332840448
   },
   "TotalNumConnects": 11,
   "TotalDataRead": 0,
   "TotalIndexRead": 0,
   "TotalDataWrite": 0,
   "TotalIndexWrite": 0,
   "TotalUpdate": 0,
   "TotalDelete": 0,
   "TotalInsert": 0,
   "ReplUpdate": 0,
   "ReplDelete": 0,
   "ReplInsert": 0,
   "TotalSelect": 0,
   "TotalRead": 0,
   "TotalReadTime": 0,
   "TotalWriteTime": 0,
   "ActivateTimestamp": "2014-08-07-13.04.16.248083",
   "ResetTimestamp": "2014-08-07-13.04.16.248083",
   "UserCPU": "7.980000",
   "SysCPU": "10.700000",
   "freeLogSpace": 1342177280,
   "vsize": 1745002496,
   "rss": 12929,
   "fault": 12,
   "TotalMapped": 918945792,
   "svcNetIn": 3051,
   "svcNetOut": 9245,
   "shardNetIn": 3054,
   "shardNetOut": 9265,
   "replNetIn": 0,
   "replNetOut": 0
   "MemPoolSize": 56868864
  }

• 通过协调节点查看快照

  > db.snapshot( SDB_SNAP_DATABASE )

  输出结果如下：

  {
   "TotalNumConnects": 0,
   "TotalDataRead": 4,
   "TotalIndexRead": 0,
   "TotalDataWrite": 3,
   "TotalIndexWrite": 3,
   "TotalUpdate": 0,
   "TotalDelete": 0,
   "TotalInsert": 3,
   "ReplUpdate": 0,
   "ReplDelete": 0,
   "ReplInsert": 2,
   "TotalSelect": 606,
   "TotalRead": 4,
   "TotalReadTime": 0,
   "TotalWriteTime": 0,
   "freeLogSpace": 5368709120,
   "vsize": 5660057600,
   "rss": 44765,
   "fault": 25,
   "TotalMapped": 2144206848,
   "svcNetIn": 0,
   "svcNetOut": 0,
   "shardNetIn": 38228,
   "shardNetOut": 393997,
   "replNetIn": 40743956,
   "replNetOut": 40743956,
   "ErrNodes": [
     {
       "NodeName": "hostname1:11850",
       "GroupName": "group2",
       "Flag": -79,
       "ErrInfo": {}
     }
   ]
  }