#openGauss #入门 #安装 #数据库 #开源
知识来源：docs-opengauss.osinfra.cn/zh/
-
2、自定义场景。需要一步步进行业务相关内容的调查。
[root@openGauss34 script]# python3 gs_perfconfig tune -t all --apply --env /home/carrot/text.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:21:57.386969 [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:21:59.328462 [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: c *[ Single Answer Question ] What are the main scenarios for using databases? A. OLTP performance first B. OLTP produce first Single answer: a *[ Input number ] What is the average number of concurrent transactions? Please answer: 1000 *[ Input number ] Approximately how many tables you have? Please answer: 100 *[ Multiple Answer Question ] What kind of table you used? A. common heap table B. partition heap table C. column table D. partition column table Multiple answer: abc *[ Input number ] Approximately how many partitions you have? Please answer: 10000 *[ Input number ] Approximately how many index you have? Please answer: 200 *[ Input number ] How much data is there, unit by MB? Please answer: 102400 [ Input path ] Storing wal on a separate disk helps improve performance. Do you need to move them? Here is some disk information: device=/dev/mapper/openeuler00-root, mountpoint=/, fstype=ext4 size=(free 43.5234375GB / total 48.9658203125GB) device=/dev/sdb2, mountpoint=/boot, fstype=ext4 size=(free 0.78125GB / total 0.953125GB) device=/dev/sdb1, mountpoint=/boot/efi, fstype=vfat size=(free 0.189453125GB / total 0.1953125GB) device=/dev/mapper/openeuler00-home, mountpoint=/home, fstype=ext4 size=(free 4632.44140625GB / total 4930.955078125GB) device=/dev/sdc1, mountpoint=/data1, fstype=ext4 size=(free 931.486328125GB / total 1006.9287109375GB)
Please input the path: 2023-11-07 10:22:42.989728 [NOTICE]: stop openGauss...... 2023-11-07 10:22:42.989771 [NOTICE]: stop openGauss finish. 2023-11-07 10:22:42.989806 [NOTICE]: Prepare tune plan. 2023-11-07 10:22:43.064604 [NOTICE]: Adjustments are being made(do apply)... 2023-11-07 10:22:50.535352 [NOTICE]: Report: /data1/carrot/openGauss-OM/script/impl/perf_config/report-1699323717.3838584-1458686.md 2023-11-07 10:22:50.535428 [NOTICE]: Tune finish. 2023-11-07 10:22:50.535460 [NOTICE]: start openGauss..... 2023-11-07 10:22:50.535486 [NOTICE]: start openGauss finish.
#openGauss #入门 #安装 #数据库 #开源
