1
金仓数据库KingbaseES参数设置介绍.docx
免费下载
金仓数据库
KingbaseES
参数设置介绍
参数级别介绍
KingbaseES
配置参数共包括以下七个级别（由低到高），其中参数属于
sighup
及其后
续级别的可由用户设置：
参数级别 级别说明
internal
仅支持内部使用
kingbase
仅支持启动时设置
sighup
支持修改配置文件后通过
SIGHUP
信号更新参数
superuser-backend
超级用户的后台级参数
backend
普通用户的后台级参数
superuser
支持超级用户在线修改的参数
user
支持普通用户在线修改的参数
查看参数以与所属级别的命令如下：
kingbase=# SELECT name,context,short_desc FROM sys_settings ORDER
BY context,name;
server_version_num | internal |
Shows the server version as an integer.
ssl_library | internal | Name
of the SSL library.
wal_block_size | internal |
Shows the block size in the write ahead log.
wal_segment_size | internal |
Shows the size of write ahead log segments.
allow_system_table_mods | kingbase | Allows
modifications of the structure of system tables.
archive_mode | kingbase | Allows
archiving of WAL files using archive_command.
autovacuum_freeze_max_age | kingbase | Age at
which to autovacuum a table to prevent transaction ID wraparound.
autovacuum_max_workers | kingbase | Sets
the maximum number of simultaneously running autovacuum worker
processes.
autovacuum_multixact_freeze_max_age | kingbase |
Multixact age at which to autovacuum a table to prevent multixact
wraparound.
bonjour | kingbase |
Enables advertising the server via Bonjour.
bonjour_name | kingbase | Sets
the Bonjour service name.
cluster_name | kingbase | Sets
the name of the cluster, which is included in the process title.
config_file | kingbase | Sets
the server's main configuration file.
data_directory | kingbase | Sets
the server's data directory.
data_sync_retry | kingbase |
Whether to continue running after a failure to sync data files.
dynamic_shared_memory_type | kingbase |
Selects the dynamic shared memory implementation used.
event_source | kingbase | Sets
the application name used to identify KingbaseES messages in the
event log.
external_pid_file | kingbase | Writes
the kingbase PID to the specified file.
hba_file | kingbase | Sets
the server's "hba" configuration file.
hot_standby | kingbase | Allows
connections and queries during recovery.
huge_pages | kingbase | Use of
huge pages on Linux or Windows.
ident_file | kingbase | Sets
the server's "ident" configuration file.
jit_provider | kingbase | JIT
provider to use.
listen_addresses | kingbase | Sets
the host name or IP address(es) to listen to.
--More--
参数优先级别
KingbaseES
参数配置的方式可以使用配置文件 、数据库服务启动命令、系统命令等方式
进行配置，不同的配置方式具备不同的优先级。
of 15
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论