数据库快照

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

Note:

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

标识

SDB_SNAP_DATABASE

非协调节点字段信息

协调节点字段信息

Note:

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

应用场景

查看快照信息

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

  > db.snapshot( SDB_SNAP_DATABASE )

  输出结果如下：

  {
   "NodeName": "hostname1:11820",
   "HostName": "hostname1",
   "ServiceName": "11820",
   "GroupName": "group1",
   "IsPrimary": true,
   "ServiceStatus": true,
   "Status": "Normal",
   "FTStatus": "",
   "BeginLSN": {
     "Offset": 0,
     "Version": 1
   },
   "CurrentLSN": {
     "Offset": 164,
     "Version": 1
   },
   "CommittedLSN": {
     "Offset": 164,
     "Version": 1
   },
   "CompleteLSN": 1468,
   "LSNQueSize": 0,
   "TransInfo": {
     "TotalCount": 0,
     "BeginLSN": -1
   },
   "NodeID": [
     1000,
     1000
   ],
   "Version": {
     "Major": 3,
     "Minor": 4,
     "Fix": 8,
     "Release": 43597,
     "GitVersion": "6c1922758c5d89ed124f4326122fc32d2a468505",
     "Build": "2022-10-06-10.43.42(Enterprise Debug)"
   },
   "Edition": "Enterprise",
   "CurrentActiveSessions": 26,
   "CurrentIdleSessions": 10,
   "CurrentSystemSessions": 12,
   "CurrentTaskSessions": 6,
   "CurrentContexts": 1,
   "ReceivedEvents": 16,
   "Role": "data",
   "Disk": {
     "DatabasePath": "/opt/sequoiadb/database/data/11820/",
     "LoadPercent": 0,
     "TotalSpace": 754868568064,
     "FreeSpace": 628498378752
   },
   "TotalNumConnects": 2,
   "TotalQuery": 14,
   "TotalSlowQuery": 0,
   "TotalTransCommit": 0,
   "TotalTransRollback": 0,
   "TotalDataRead": 0,
   "TotalIndexRead": 0,
   "TotalDataWrite": 0,
   "TotalIndexWrite": 0,
   "TotalUpdate": 0,
   "TotalDelete": 0,
   "TotalInsert": 0,
   "ReplUpdate": 0,
   "ReplDelete": 0,
   "ReplInsert": 0,
   "TotalSelect": 0,
   "TotalRead": 0,
   "TotalLobGet": 0,
   "TotalLobPut": 1,
   "TotalLobDelete": 0,
   "TotalLobList": 0,
   "TotalLobReadSize": 0,
   "TotalLobWriteSize": 150,
   "TotalLobRead": 0,
   "TotalLobWrite": 1,
   "TotalLobTruncate": 0,
   "TotalLobAddressing": 1,
   "TotalReadTime": 0,
   "TotalWriteTime": 0,
   "ActivateTimestamp": "2022-10-06-18.00.07.588438",
   "ResetTimestamp": "2022-10-06-18.00.07.588438",
   "UserCPU": "0.730000",
   "SysCPU": "2.170000",
   "freeLogSpace": 1342177280,
   "vsize": 3302031360,
   "rss": 56151,
   "fault": 0,
   "TotalMapped": 667385856,
   "svcNetIn": 468,
   "svcNetOut": 6185,
   "shardNetIn": 9939,
   "shardNetOut": 9454,
   "replNetIn": 0,
   "replNetOut": 0,
   "SchdlrType": 0,
   "SchdlrTypeDesp": "NONE",
   "Run": 0,
   "Wait": 0,
   "SchdlrMgrEvtNum": 0,
   "SchdlrTimes": 0,
   "MemPoolSize": 108975104
  }

• 通过协调节点查看快照

  > db.snapshot( SDB_SNAP_DATABASE )

  输出结果如下：

  {
   "TotalNumConnects": 1,
   "TotalQuery": 18,
   "TotalSlowQuery": 0,
   "TotalTransCommit": 21,
   "TotalTransRollback": 0,
   "TotalDataRead": 682,
   "TotalIndexRead": 561,
   "TotalDataWrite": 27,
   "TotalIndexWrite": 24,
   "TotalUpdate": 19,
   "TotalDelete": 0,
   "TotalInsert": 8,
   "ReplUpdate": 0,
   "ReplDelete": 0,
   "ReplInsert": 0,
   "TotalSelect": 307,
   "TotalRead": 403,
   "TotalLobGet": 0,
   "TotalLobPut": 2,
   "TotalLobDelete": 0,
   "TotalLobList": 1,
   "TotalLobReadSize": 0,
   "TotalLobWriteSize": 300,
   "TotalLobRead": 0,
   "TotalLobWrite": 1,
   "TotalLobTruncate": 0,
   "TotalLobAddressing": 1,
   "TotalReadTime": 0,
   "TotalWriteTime": 0,
   "freeLogSpace": 5368709120,
   "vsize": 13657559040,
   "rss": 257087,
   "fault": 9,
   "TotalMapped": 1377402880,
   "svcNetIn": 1536,
   "svcNetOut": 1057,
   "shardNetIn": 33090,
   "shardNetOut": 22375,
   "replNetIn": 0,
   "replNetOut": 0,
   "ErrNodes": []
  }