配置快照

描述

配置快照 SDB_SNAP_CONFIGS 列出数据库中指定节点的配置信息。

每一个节点上的配置信息为一条记录。

标示

SDB_SNAP_CONFIGS

字段信息

字段信息详见数据库配置一节。

快照参数

参数名参数类型描述是否必填
ModeString指定返回配置的模式。在 run 模式下，显示当前运行时配置信息，在 local 模式下，显示配置文件中配置信息。如 { "Mode": "local" }。默认为 run。否
ExpandBool/String是否扩展显示用户未配置的配置项。如 { "Expand": false }。默认为 true。否

Note:

在查询快照时指定快照参数，请参考 SdbSnapshotOption。

示例

查看数据组 db1 中数据节点 20000 上的配置信息

  1. > db.snapshot( SDB_SNAP_CONFIGS, { GroupName:'db1', ServiceName:'20000' } )
  2. {
  3.   "NodeName": "ubuntu-zwb:20000"
  4.   "confpath": "/home/sequoiadb/conf/local/20000/",
  5.   "dbpath": "/home/sequoiadb/20000/",
  6.   "indexpath": "/home/sequoiadb/20000/",
  7.   "diagpath": "/home/sequoiadb/20000/diaglog/",
  8.   "auditpath": "/home/sequoiadb/20000/diaglog/",
  9.   "logpath": "/home/sequoiadb/20000/replicalog/",
  10.   "bkuppath": "/home/sequoiadb/20000/bakfile/",
  11.   "wwwpath": "/home/sequoiadb/web/",
  12.   "lobpath": "/home/sequoiadb/20000/",
  13.   "lobmetapath": "/home/sequoiadb/20000/",
  14.   "maxpool": 50,
  15.   "diagnum": 20,
  16.   "auditnum": 20,
  17.   "auditmask": "SYSTEM|DDL|DCL",
  18.   "ServiceName": "20000",
  19.   "replname": "20001",
  20.   "catalogname": "20003",
  21.   "shardname": "20002",
  22.   "httpname": "20004",
  23.   "omname": "20005",
  24.   "diaglevel": 3,
  25.   "role": "data",
  26.   "logfilesz": 64,
  27.   "logfilenum": 20,
  28.   "logbuffsize": 1024,
  29.   "numpreload": 0,
  30.   "maxprefpool": 0,
  31.   "maxsubquery": 0,
  32.   "maxreplsync": 10,
  33.   "replbucketsize": 32,
  34.   "syncstrategy": "KeepNormal",
  35.   "preferedinstance": "M",
  36.   "preferedinstancemode": "random",
  37.   "instanceid": 0,
  38.   "dataerrorop": 1,
  39.   "memdebug": "FALSE",
  40.   "memdebugsize": 0,
  41.   "indexscanstep": 100,
  42.   "dpslocal": "FALSE",
  43.   "traceon": "FALSE",
  44.   "tracebufsz": 256,
  45.   "transactionon": "FALSE",
  46.   "transactiontimeout": 60,
  47.   "sharingbreak": 7000,
  48.   "startshifttime": 600,
  49.   "catalogaddr": "ubuntu-zwb:30003,ubuntu-zwb:30013,ubuntu-zwb:30023",
  50.   "tmppath": "/home/sequoiadb/20000/tmp/",
  51.   "sortbuf": 256,
  52.   "hjbuf": 128,
  53.   "directioinlob": "FALSE",
  54.   "sparsefile": "FALSE",
  55.   "weight": 10,
  56.   "auth": "TRUE",
  57.   "planbuckets": 500,
  58.   "optimeout": 300000,
  59.   "overflowratio": 12,
  60.   "extendthreshold": 32,
  61.   "signalinterval": 0,
  62.   "maxcachesize": 0,
  63.   "maxcachejob": 10,
  64.   "maxsyncjob": 10,
  65.   "syncinterval": 10000,
  66.   "syncrecordnum": 0,
  67.   "syncdeep": "FALSE",
  68.   "archiveon": "FALSE",
  69.   "archivecompresson": "TRUE",
  70.   "archivepath": "/home/sequoiadb/20000/archivelog/",
  71.   "archivetimeout": 600,
  72.   "archiveexpired": 240,
  73.   "archivequota": 10,
  74.   "omaddr": "",
  75.   "dmschkinterval": 0,
  76.   "cachemergesz": 0,
  77.   "pagealloctimeout": 0,
  78.   "perfstat": "FALSE",
  79.   "optcostthreshold": 20,
  80.   "enablemixcmp": "FALSE",
  81.   "plancachelevel": 3,
  82.   "maxconn": 0
  83. }
  84. Return 1 row(s).

查看数据组 db1 中数据节点 20000 上配置文件中的配置信息

  1. > var option = new SdbSnapshotOption().cond( { GroupName:'db1', ServiceName:'20000' } ).options( { "Mode": "local", "Expand": false } )
  2. > db.snapshot( SDB_SNAP_CONFIGS, option )
  3. {
  4.   "NodeName": "ubuntu-zwb:20000",
  5.   "dbpath": "/home/sequoiadb/20000/",
  6.   "ServiceName": "20000",
  7.   "diaglevel": 3,
  8.   "role": "data",
  9.   "catalogaddr": "ubuntu-zwb:30003,ubuntu-zwb:30013,ubuntu-zwb:30023",
  10.   "perfstat": "FALSE",
  11.   "businessname": "yyy",
  12.   "clustername": "xxx"
  13. }
  14. Return 1 row(s).