gbase数据、南大通用产品文档：GBase8a业务调优

业务调优最为复杂，只有熟悉和掌握应用业务流程，才能找到正确的优化点和优
化方法。业务调优一定要与现场人员充分配合，确保优化后的业务逻辑和优化前
的业务逻辑是等价的。

如果导出数据的内容中包含字段包围符，则orato8a 会使用字段包围符对数据内容
进行转义，导出方法如下：
$ ./orato8a --user='ssbm/ssbm@maya' --table_name='message' --file='./message.tbl' --format=3
--field='|@|' --string_qualifier="\""
export columns: 3
export rows: 10
export time: 0 sec
process ok!
$ cat message.tbl
"1"|@|"Tom"|@|"I am Tom"
"2"|@|"小明"|@|"HHHH""KKKK"
"3"|@|"Peter"|@|"Hello!Hello!"
"4"|@|"Yama"|@|"send mail"
"5"|@|"Hellen"|@|
"6"|@||@|
"7"|@|"Seven"|@|"a book store"
"8"|@|"MMEE"|@|"yes"
"9"|@|"George"|@|"Thank you."

GBase 8a MPP Cluster 产品手册
4 管理员指南
文档版本953（2022-09-15）
南大通用数据技术股份有限公司
549
"10"|@|"Lastman"|@|"no message"
查看导出的数据内容发现，第二行数据的最后一列本来的内容为'HHHH"KKKK'，
由于其中包含的双引号(")与字段包围符相同，因此被使用字段包围符进行了转义。

示例
使用非交互方式进行GBase 8c 环境准备：
[root@gbasehost ~]$ gs_preinstall -U gbase -G gbase -X
/opt/software/gbase/clusterconfig.xml --non-interactive
Parsing the configuration file.
Successfully parsed the configuration file.
Installing the tools on the local node.
Successfully installed the tools on the local node.
Distributing package.
Successfully distributed package.
Installing the tools in the cluster.
Successfully installed the tools in the cluster.
Checking hostname mapping.
Successfully checked hostname mapping.
Checking OS version.
Successfully checked OS version.

GBase 8c 工具参考手册
南大通用数据技术股份有限公司
235
Creating cluster's path.
Successfully created cluster's path.
Set and check OS parameter.
Setting OS parameters.
Successfully set OS parameters.
Warning: Installation environment contains some warning messages.
Please get more details by "/package_r8/sudo/gs_checkos -i A -h
host179174,host179175,host179176".
Set and check OS parameter completed.
Preparing CRON service.
Successfully prepared CRON service.
Preparing SSH service.
Successfully prepared SSH service.
Setting user environmental variables.
Successfully set user environmental variables.
Configuring alarms on the cluster nodes.
Successfully configured alarms on the cluster nodes.
Setting the dynamic link library.
Successfully set the dynamic link library.
Setting finish flag.
Successfully set finish flag.
Preinstallation succeeded.
使用交互模式进行GBase 8c 环境准备：
[root@gbasehost ~]$ gs_preinstall -U gbase -G gbase -X
/opt/software/gbase/clusterconfig.xml
Parsing the configuration file.
Successfully parsed the configuration file.
Installing the tools on the local node.
Successfully installed the tools on the local node.
Are you sure you want to create trust for root (yes/no)? yes
Please enter password for root.
Password:
Creating SSH trust for the root permission user.
Please enter password for current user[root].
Password:
Checking network information.
All nodes in the network are Normal.
Successfully checked network information.
Creating SSH trust.
Creating the local key file.

GBase 8c 工具参考手册
南大通用数据技术股份有限公司
236
Successfully created the local key files.
Appending local ID to authorized_keys.
Successfully appended local ID to authorized_keys.
Updating the known_hosts file.
Successfully updated the known_hosts file.
Appending authorized_key on the remote node.
Successfully appended authorized_key on all remote node.
Checking common authentication file content.
Successfully checked common authentication content.
Distributing SSH trust file to all node.
Successfully distributed SSH trust file to all node.
Verifying SSH trust on all hosts.
Successfully verified SSH trust on all hosts.
Successfully created SSH trust.
Successfully created SSH trust for the root permission user.
Distributing package.
Successfully distributed package.
Are you sure you want to create the user[gbase] and create trust for it (yes/no)?
yes
Please enter password for cluster user.
Password:
Please enter password for cluster user again.
Password:
Creating [gbase] user on all nodes.
Successfully created [gbase] user on all nodes.
Installing the tools in the cluster.
Successfully installed the tools in the cluster.
Checking hostname mapping.
Successfully checked hostname mapping.
Creating SSH trust for [gbase] user.
Please enter password for current user[gbase].
Password:
Checking network information.
All nodes in the network are Normal.
Successfully checked network information.
Creating SSH trust.
Creating the local key file.
Successfully created the local key files.
Appending local ID to authorized_keys.
Successfully appended local ID to authorized_keys.
Updating the known_hosts file.

GBase 8c 工具参考手册
南大通用数据技术股份有限公司
237
Successfully updated the known_hosts file.
Appending authorized_key on the remote node.
Successfully appended authorized_key on all remote node.
Checking common authentication file content.
Successfully checked common authentication content.
Distributing SSH trust file to all node.
Successfully distributed SSH trust file to all node.
Verifying SSH trust on all hosts.
Successfully verified SSH trust on all hosts.
Successfully created SSH trust.
Successfully created SSH trust for [omm] user.
Checking OS version.
Successfully checked OS version.
Creating cluster's path.
Successfully created cluster's path.
Set and check OS parameter.
Setting OS parameters.
Successfully set OS parameters.
Warning: Installation environment contains some warning messages.
Please get more details by "/package_r8/sudo/gs_checkos -i A -h
host179174,host179175,host179176".
Set and check OS parameter completed.
Preparing CRON service.
Successfully prepared CRON service.
Preparing SSH service.
Successfully prepared SSH service.
Setting user environmental variables.
Successfully set user environmental variables.
Configuring alarms on the cluster nodes.
Successfully configured alarms on the cluster nodes.
Setting the dynamic link library.
Successfully set the dynamic link library.
Setting finish flag.
Successfully set finish flag.
Preinstallation succeeded.