文档

关于 SequoiaDB

快速入门

快速入门之一键清理

安装

基本操作

数据模型

SQL引擎

FileSystem引擎

S3引擎

系统架构

数据库管理

数据库服务

数据库配置

特殊配置项修改

引擎调度工具

数据库工具

集群启停

集群扩容

备份恢复

日志归档重放

监控

安全

查询访问计划

统计信息

连接器

驱动

参考手册

故障排除

SAC 管控中心

Web服务

版本信息

配置快照

描述

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

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

标示

SDB_SNAP_CONFIGS

字段信息

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

快照参数

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

Note:

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

示例

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

> db.snapshot( SDB_SNAP_CONFIGS, { GroupName:'db1', ServiceName:'20000' } )
{
  "NodeName": "ubuntu-zwb:20000"
  "confpath": "/home/sequoiadb/conf/local/20000/",
  "dbpath": "/home/sequoiadb/20000/",
  "indexpath": "/home/sequoiadb/20000/",
  "diagpath": "/home/sequoiadb/20000/diaglog/",
  "auditpath": "/home/sequoiadb/20000/diaglog/",
  "logpath": "/home/sequoiadb/20000/replicalog/",
  "bkuppath": "/home/sequoiadb/20000/bakfile/",
  "wwwpath": "/home/sequoiadb/web/",
  "lobpath": "/home/sequoiadb/20000/",
  "lobmetapath": "/home/sequoiadb/20000/",
  "maxpool": 50,
  "diagnum": 20,
  "auditnum": 20,
  "auditmask": "SYSTEM|DDL|DCL",
  "ServiceName": "20000",
  "replname": "20001",
  "catalogname": "20003",
  "shardname": "20002",
  "httpname": "20004",
  "omname": "20005",
  "diaglevel": 3,
  "role": "data",
  "logfilesz": 64,
  "logfilenum": 20,
  "logbuffsize": 1024,
  "numpreload": 0,
  "maxprefpool": 0,
  "maxsubquery": 0,
  "maxreplsync": 10,
  "replbucketsize": 32,
  "syncstrategy": "KeepNormal",
  "preferedinstance": "M",
  "preferedinstancemode": "random",
  "instanceid": 0,
  "dataerrorop": 1,
  "memdebug": "FALSE",
  "memdebugsize": 0,
  "indexscanstep": 100,
  "dpslocal": "FALSE",
  "traceon": "FALSE",
  "tracebufsz": 256,
  "transactionon": "FALSE",
  "transactiontimeout": 60,
  "sharingbreak": 7000,
  "startshifttime": 600,
  "catalogaddr": "ubuntu-zwb:30003,ubuntu-zwb:30013,ubuntu-zwb:30023",
  "tmppath": "/home/sequoiadb/20000/tmp/",
  "sortbuf": 256,
  "hjbuf": 128,
  "directioinlob": "FALSE",
  "sparsefile": "FALSE",
  "weight": 10,
  "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": "/home/sequoiadb/20000/archivelog/",
  "archivetimeout": 600,
  "archiveexpired": 240,
  "archivequota": 10,
  "omaddr": "",
  "dmschkinterval": 0,
  "cachemergesz": 0,
  "pagealloctimeout": 0,
  "perfstat": "FALSE",
  "optcostthreshold": 20,
  "enablemixcmp": "FALSE",
  "plancachelevel": 3,
  "maxconn": 0
}
Return 1 row(s).

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

> var option = new SdbSnapshotOption().cond( { GroupName:'db1', ServiceName:'20000' } ).options( { "Mode": "local", "Expand": false } )
> db.snapshot( SDB_SNAP_CONFIGS, option )
{
  "NodeName": "ubuntu-zwb:20000",
  "dbpath": "/home/sequoiadb/20000/",
  "ServiceName": "20000",
  "diaglevel": 3,
  "role": "data",
  "catalogaddr": "ubuntu-zwb:30003,ubuntu-zwb:30013,ubuntu-zwb:30023",
  "perfstat": "FALSE",
  "businessname": "yyy",
  "clustername": "xxx"
}
Return 1 row(s).
回到顶部