#openGauss #入门 #安装 #数据库 #开源
知识来源:docs-opengauss.osinfra.cn/zh/
示例
使用tune命令对参数进行调整
-
1、默认业务场景(预设场景类似)
[root@openGauss34 script]# python3 gs_perfconfig tune -t all --apply --env /home/carrot/opengauss.source LOG: source env: GAUSSHOME=/data1/carrot/gausshome/5.1.0 LOG: source env: PGDATA=/data1/carrot/gausshome/5.1.0/sgnode LOG: read environ: GAUSSHOME=/data1/carrot/gausshome/5.1.0 LOG: read environ: PGDATA=/data1/carrot/gausshome/5.1.0/sgnode LOG: read environ: PGHOST= LOG: read environ: GAUSSLOG= LOG: read environ: GAUSS_VERSION= LOG: workspace1: /data1/carrot/openGauss-OM/script/impl/perf_config LOG: workspace2: LOG: read environ: GS_PERFCONFIG_OPTIONS= 2023-11-07 10:07:23.669867 [NOTICE]: Anti Log (/data1/carrot/openGauss-OM/script/impl/perf_config/anti.log) init done *[ yesOrNot ] Certainly, we will make adjustments to the configuration of operating system parameters, database parameters, and also perform a database restart during the optimization process. Are you accepting of the aforementioned circumstances?(y/n)? y 2023-11-07 10:07:25.097719 [NOTICE]: Start probe detect. Now we need to do some research to understand your business scenario. *[ Single Answer Question ] What kind of way to choose? A. Default case B. Preset C. Customization Single answer: a 2023-11-07 10:07:26.676511 [NOTICE]: stop openGauss...... 2023-11-07 10:07:26.676547 [NOTICE]: stop openGauss finish. 2023-11-07 10:07:26.676574 [NOTICE]: Prepare tune plan. 2023-11-07 10:07:26.750048 [NOTICE]: Adjustments are being made(do apply)... 2023-11-07 10:07:34.159237 [NOTICE]: Report: /data1/carrot/openGauss-OM/script/impl/perf_config/report-1699322843.6666596-1453806.md 2023-11-07 10:07:34.159306 [NOTICE]: Tune finish. 2023-11-07 10:07:34.159338 [NOTICE]: start openGauss..... 2023-11-07 10:07:34.159363 [NOTICE]: start openGauss finish.
#openGauss #入门 #安装 #数据库 #开源