返回首页

gbase数据、南大通用产品文档:GBase8ctrack_activity_query_size

更新日期:2024年09月11日

参数说明:设置用于跟踪每一个活动会话的当前正在执行命令的字节数。
该参数属于POSTMASTER 类型参数,请参考表15-1 中对应设置方法进行设置。
取值范围:整型,100~102400
默认值:1024

示例
使用gs_expansion 扩容步骤。

GBase 8c 工具参考手册
南大通用数据技术股份有限公司
214
[gbase@gbasehost ~]$ gs_expansion -U gbase -G gbase -X
/home/gbase/cluster_config.xml -h 192.168.5.124
Start to preinstall database on new nodes.
Start to send soft to each standby nodes.
End to send soft to each standby nodes.
Start to preinstall database step.
Preinstall 192.168.5.124 success
End to preinstall database step.
End to preinstall database on new nodes.
Start to install database on new nodes.
Installing database on node 192.168.5.124:
Please enter the password of user [gbase] on node [192.168.5.124]:
Parsing the configuration file.
Check preinstall on every node.
Successfully checked preinstall on every node.
Creating the backup directory.
Successfully created the backup directory.
begin deploy..
Installing the cluster.
begin prepare Install Cluster..
Checking the installation environment on all nodes.
begin install Cluster..
Installing applications on all nodes.
Successfully installed APP.
begin init Instance..
encrypt cipher and rand files for database.
Please enter password for database:
Please repeat for database:
begin to create CA cert files
The sslcert will be generated in /opt/gbase/cluster/app/share/sslcert/om
Cluster installation is completed.
Configuring.
Deleting instances from all nodes.
Successfully deleted instances from all nodes.
Checking node configuration on all nodes.
Initializing instances on all nodes.
Updating instance configuration on all nodes.
Check consistence of memCheck and coresCheck on database nodes.
Configuring pg_hba on all nodes.
Configuration is completed.

GBase 8c 工具参考手册
南大通用数据技术股份有限公司
215
Successfully started cluster.
Successfully installed application.
end deploy..

GBase
8a
MPP
Cluster 中,集群加载功能直接集成在GBase
8a
MPP
Cluster
内部,不需要额外部署外部加载工具。
数据加载具备如下一些特性和优点:
1)与集群高度集成;
2)面向用户的SQL 接口方式更符合用户的使用习惯;
3)
支持单表多数据源并行加载,
支持多加载机对单表的并行加载,
最大化
提升加载性能;
4)支持从通用数据服务器拉取数据,支持
ftp/sftp/hdfs/Kafka/http/https 等多种文件传输协议;
5)支持普通文本、gzip 压缩、snappy 压缩、lzo 压缩等多种格式数据文
件;
6)支持普通文本、定长文本、宽松模式的加载;
7)支持用户自定义列分割符、行分隔符和日期时间格式;
8)支持错误数据溯源功能,可以准确定位错误数据在源文件中的位置;
9)加载性能可以随着集群规模的扩展而持续提升。