文档

关于 SequoiaDB

快速入门

安装

基本操作

数据模型

SQL引擎

FileSystem引擎

S3引擎

系统架构

数据库管理

连接器

驱动

参考手册

SequoiaDB Shell方法

操作符

SQL语法

SQL to SequoiaDB 映射表

限制

错误码

故障排除

SAC 管控中心

Web服务

版本信息

$SNAPSHOT_CONFIGS

描述

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

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

标示

$SNAPSHOT_CONFIGS

字段信息

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

快照参数

可以使用 use_option 进行指定。

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

示例

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

> db.exec( "select * from $SNAPSHOT_CONFIGS where GroupName = 'db1' and SvcName = '20000'" )
{
  "NodeName": "hostname:20000",
  "confpath": "/opt/trunk/conf/local/20000/",
  "dbpath": "/opt/test/20000/",
  "indexpath": "/opt/test/20000/",
  "diagpath": "/opt/test/20000/diaglog/",
  "auditpath": "/opt/test/20000/diaglog/",
  "logpath": "/opt/test/20000/replicalog/",
  "bkuppath": "/opt/test/20000/bakfile/",
  "wwwpath": "/opt/trunk/web/",
  "lobpath": "/opt/test/20000/",
  "lobmetapath": "/opt/test/20000/",
  "maxpool": 50,
  "diagnum": 20,
  "auditnum": 20,
  "auditmask": "SYSTEM|DDL|DCL",
  "svcname": "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",
  "preferedstrict": "FALSE",
  "instanceid": 0,
  "dataerrorop": 1,
  "memdebug": "FALSE",
  "memdebugsize": 0,
  "indexscanstep": 100,
  "dpslocal": "FALSE",
  "traceon": "FALSE",
  "tracebufsz": 256,
  "transactionon": "TRUE",
  "transactiontimeout": 60,
  "transisolation": 0,
  "translockwait": "FALSE",
  "transautocommit": "FALSE",
  "transautorollback": "TRUE",
  "transuserbs": "TRUE",
  "translrbinit": 524288,
  "sharingbreak": 7000,
  "startshifttime": 600,
  "catalogaddr": "hostname:30003,hostname:30013,hostname:30023",
  "tmppath": "/opt/test/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": "/opt/test/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,
  "svcscheduler": 0,
  "svcmaxconcurrency": 0,
  "logwritemod": "increment",
  "logtimeon": "FALSE",
  "enablesleep": "FALSE",
  "recyclerecord": "FALSE",
  "maxsocketpernode": 1,
  "maxsocketperthread": 0,
  "maxsocketthread": 1,
  "businessname": "yyy",
  "clustername": "xxx"
}

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

> db.exec('select * from $SNAPSHOT_CONFIGS where GroupName = "db1" and SvcName = "20000" /*+use_option(Mode, local)use_option(Expand, false)*/') 
{
  "NodeName": "hostname:20000",
  "dbpath": "/opt/test/20000/",
  "svcname": "20000",
  "diaglevel": 3,
  "role": "data",
  "catalogaddr": "hostname:30003,hostname:30013,hostname:30023",
  "sparsefile": "TRUE",
  "plancachelevel": 3,
  "businessname": "yyy",
  "clustername": "xxx"
}
回到顶部