文档中心
v3.4

SequoiaDB 简介

安装部署

数据库实例

分布式引擎

SAC 管控中心

参考手册

常见问题及解答(FAQ)

版本信息

配置快照

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

标识

SDB_SNAP_CONFIGS

字段信息

字段信息详见数据库配置

扩展参数

构造扩展参数,可参考 SdbSnapshotOption

参数名 参数类型 描述 是否必填
Mode string 指定返回配置的模式,默认为"run"
在 run 模式下,显示当前运行时配置信息;在 local 模式下,显示配置文件中配置信息
Expand boolean 是否扩展显示用户未配置的配置项,默认为 true

示例

  • 构造扩展参数进行快照查询

    > var option = new SdbSnapshotOption().options( { "Mode": "local", "Expand": false } )
    > db.snapshot( SDB_SNAP_CONFIGS, option )

    输出结果如下:

    {
     "NodeName": "sdbserver1:11830",
     "dbpath": "/opt/sequoiadb/database/data/11830/",
     "svcname": "11830",
     "role": "data",
     "catalogaddr": "sdbserver1:11823,sdbserver2:11823,sdbserver3:11823",
     "omaddr": "sdbserver1:11785",
     "businessname": "myService1",
     "clustername": "myCluster1"
    }
    ...
  • 指定服务名和组名进行快照查询

    > db.snapshot( SDB_SNAP_CONFIGS, { GroupName:'group1', SvcName:'11830' } )

    输出结果如下:

    {
     "NodeName": "sdbserver1:11830",
     "confpath": "/opt/sequoiadb/conf/local/11830/",
     "dbpath": "/opt/sequoiadb/database/data/11830/",
     "indexpath": "/opt/sequoiadb/database/data/11830/",
     "diagpath": "/opt/sequoiadb/database/data/11830/diaglog/",
     "auditpath": "/opt/sequoiadb/database/data/11830/diaglog/",
     "logpath": "/opt/sequoiadb/database/data/11830/replicalog/",
     "bkuppath": "/opt/sequoiadb/database/data/11830/bakfile/",
     "wwwpath": "/opt/sequoiadb/web/",
     "lobpath": "/opt/sequoiadb/database/data/11830/",
     "lobmetapath": "/opt/sequoiadb/database/data/11830/",
     "maxpool": 50,
     "diagnum": 20,
     "auditnum": 20,
     "auditmask": "SYSTEM|DDL|DCL",
     "svcname": "11830",
     "replname": "11831",
     "catalogname": "11833",
     "shardname": "11832",
     "httpname": "11834",
     "omname": "11835",
     "diaglevel": 3,
     "role": "data",
     "logfilesz": 64,
     "logfilenum": 20,
     "logbuffsize": 1024,
     "numpreload": 0,
     "maxprefpool": 0,
     "maxsubquery": 0,
     "maxreplsync": 10,
     "replbucketsize": 32,
     "syncstrategy": "KeepNormal",
     "preferredinstance": "M",
     "preferredinstancemode": "random",
     "instanceid": 0,
     "dataerrorop": 1,
     "memdebug": "FALSE",
     "memdebugsize": 0,
     "indexscanstep": 100,
     "dpslocal": "FALSE",
     "traceon": "FALSE",
     "tracebufsz": 256,
     "transactionon": "FALSE",
     "transactiontimeout": 60,
     "transisolation": 0,
     "translockwait": "FALSE",
     "translrbinit": 524288,
     "translrbtotal": 268435456,
     "sharingbreak": 7000,
     "startshifttime": 600,
     "catalogaddr": "sdbserver1:11823,sdbserver2:11823,sdbserver3:11823",
     "tmppath": "/opt/sequoiadb/database/data/11830/tmp/",
     "sortbuf": 256,
     "hjbuf": 128,
     "directioinlob": "FALSE",
     "sparsefile": "FALSE",
     "weight": 10,
     "usessl": "FALSE",
     "auth": "TRUE",
     "planbuckets": 500,
     "optimeout": 300000,
     "overflowratio": 12,
     "extendthreshold": 32,
     "signalinterval": 0,
     "maxcachesize": 0,
     "maxcachejob": 10,
     "maxsyncjob": 10,
     "syncinterval": 10000,
     "syncrecordnum": 0,
     "syncdeep": "FALSE",
     "archiveon": "FALSE",
     "archivecompresson": "TRUE",
     "archivepath": "/opt/sequoiadb/database/data/11830/archivelog/",
     "archivetimeout": 600,
     "archiveexpired": 240,
     "archivequota": 10,
     "omaddr": "sdbserver1:11785",
     "dmschkinterval": 0,
     "cachemergesz": 0,
     "pagealloctimeout": 0,
     "perfstat": "FALSE",
     "optcostthreshold": 20,
     "enablemixcmp": "FALSE",
     "plancachelevel": 2,
     "maxconn": 0,
     "svcscheduler": 0,
     "svcmaxconcurrency": 0,
     "businessname": "myService1",
     "clustername": "myCluster1",
     "usertag": ""
    }
    ...
回到顶部