配置文件
在$GBASE_BASE/config/gbase_8a_gbase.cnf 配置文件中,可以查看和修改GNode
的基本配置。
在$GBASE_BASE/config/cluster_common.cnf 中记录了会话超时等信息以供查看。
说明
若无特殊说明,GNode 的配置修改都是在gbase_8a_gbase.cnf 内[gbased]
组件中。
配置文件格式说明
[TagName]
Variable_name = Value
表4- 6 参数说明
参数名称
描
述
TagName
要设置的变量所生效的组件。
Client:客户端
Gbased:GNode 服务的相关配置
Gbasedump:gbasedump 服务的相关配置
Gbase:gbase 的相关配置
Variable_name
设置的变量名
Value
设置的变量值
示例
GNode 的配置文件$GBASE_BASE/config/gbase_8a_gbase.cnf 内容参考如下:
$ cat $GBASE_BASE/config/gbase_8a_gbase.cnf
[client]
port=5050
socket = /opt/192.168.146.22/gbase_8a_5050.sock
#default_character_set=gbk
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
148
[gbased]
basedir = /opt/192.168.146.22/gnode/server
datadir = /opt/192.168.146.22/gnode/userdata/gbase
skip_file_check = 1
bind_address = 192.168.146.22
socket = /opt/192.168.146.22/gbase_8a_5050.sock
pid_file = /opt/192.168.146.22/gnode/log/gbase/gbased.pid
#default_character_set=gbk
log_error
port=5050
#core_file
gcluster_node
default_storage_engine=express
default_time_zone='+8:00'
_gbase_query_path=0
gbase_parallel_execution=1
#thread_cache_size = 32
query_cache_type = 0
query_cache_size = 0M
event_scheduler=0
skip_name_resolve
sql_mode=PAD_CHAR_TO_FULL_LENGTH,PIPES_AS_CONCAT,ANSI_QU
OTES,IGNORE_SPACE,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON
_ZERO,NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES,NO_ZERO_I
N_DATE,NO_ZERO_DATE
lower_case_table_names=1
max_connections = 10000
max_connect_errors=1000000
max_allowed_packet = 64M
net_write_timeout = 1000000
net_read_timeout = 1000000
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
149
connect_timeout = 1000000
interactive_timeout
=1000000
wait_timeout = 1000000
open_files_limit = 65535
#gbase_memory_pct_target=0.8
#gbase_heap_data=512M
#gbase_heap_temp=256M
#gbase_heap_large=256M
#gbase_buffer_insert=256M
#gbase_buffer_hgrby=10M
#gbase_buffer_distgrby=10M
#gbase_buffer_hj=10M
#gbase_buffer_sj=10M
#gbase_buffer_sort=10M
#gbase_buffer_rowset=10M
#gbase_buffer_result=10M
#gbase_compression_sampling=1
gbase_compression_str_method=5
gbase_compression_num_method=5
gbase_sql_trace_level=3
#gbase_sql_trace=1
#enable_node_regist = 0
#gbase_check_param_str =
#gbase_parallel_max_thread_in_pool
#_gbase_parallel_aggr_mode=0
thread_pool_size = 512
thread_handling = pool-of-threads
back_log = 65535
max_heap_table_size = 160000000000
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
150
gbase_express_log = 1
_gbase_optimizer_in_subselect = 1
#_gbase_enable_hash_index_join = 0
#gbase_parallel_auto_estimate_optimize = 0
#gbase_parallel_auto_estimate_number = 16
#gbase_insertselect_parallel_forever = 0
#_gbase_enable_hashtree = 1
#_gbase_update_oneformany
=
1
[gbasedump]
max_allowed_packet = 64M
[gbase]
no_auto_rehash
GNode 的配置文件$GBASE_BASE/config/cluster_common.cnf 内容参考如下:
{
"cluster": {
"uuid":"a7777256-7bf5-11eb-b80f-000c29b37bff",
"nodeIPtype":"0",
"nodes": [
{
"memberaddr":"192.168.146.22"
},
{
"memberaddr":"192.168.146.23"
}
]
},
"datanode": {
"localdatanode":"192.168.146.22",
"sessiontimeout":20,
"nodes": [
{
"memberaddr":"192.168.146.22"
GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
151
},
{
"memberaddr":"192.168.146.23"
}
]
},
"gcware": {
"nodes": [
{
"memberaddr":"192.168.146.22"
},
{
"memberaddr":"192.168.146.23"
}
],
"client_port":"5919"
}
}