关于 SequoiaDB 
快速入门
安装
基本操作
数据模型
SQL引擎
S3引擎
系统架构
数据库管理
连接器
驱动
参考手册
故障排除
SAC 管控中心
Web服务
版本信息
配置快照 $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",
"indexcoveron": "TRUE",
"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"
}
展开
