焦作市网站建设_网站建设公司_服务器部署_seo优化

1.下载安装包

https://opengauss.org/zh/download/?version=lts

下载之后上传到 /opt 目录

2.创建用户和目录（root用户执行）

# 创建用户组和用户groupaddoggroupuseradd-g oggroup -m -d /home/omm -s /bin/bash ommecho"openGauss@123"|passwd--stdin omm# 在 /home 下创建安装目录mkdir-p /home/opengauss/{app,data,logs,tmp,backup}chown-R omm:oggroup /home/opengausschmod-R755/home/opengauss# 设置 omm 用户的环境变量cat>>/home/omm/.bashrc<<'EOF' # openGauss 环境变量 export GAUSSHOME=/home/opengauss/app export PATH=$GAUSSHOME/bin:$PATH export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH export PGDATA=/home/opengauss/data export PGLOG=/home/opengauss/logs export PGHOST=localhost export PGPORT=5432 export PGDATABASE=postgres export LANG=en_US.UTF-8 export LC_ALL=en_US.UTF-8 EOF# 立即生效source/home/omm/.bashrc

3.系统参数优化

# 配置内核参数cat>>/etc/sysctl.conf<<EOF # openGauss 内核参数优化 kernel.sem = 250 6400000 1000 25600 kernel.shmall = 1073741824 kernel.shmmax = 68719476736 kernel.shmmni = 8192 kernel.shmall = 1073741824 fs.file-max = 7672460 fs.aio-max-nr = 1048576 net.core.rmem_default = 262144 net.core.wmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_max = 4194304 net.core.netdev_max_backlog = 10000 net.core.somaxconn = 4096 net.ipv4.tcp_max_syn_backlog = 262144 net.ipv4.tcp_tw_reuse = 1 net.ipv4.tcp_tw_recycle = 1 net.ipv4.tcp_keepalive_time = 30 net.ipv4.tcp_keepalive_probes = 3 net.ipv4.tcp_keepalive_intvl = 30 net.ipv4.tcp_fin_timeout = 60 net.ipv4.tcp_syncookies = 1 vm.overcommit_memory = 0 vm.swappiness = 0 vm.dirty_ratio = 10 vm.dirty_background_ratio = 5 vm.dirty_expire_centisecs = 500 EOF# 生效参数sysctl -p# 配置用户限制cat>>/etc/security/limits.conf<<EOF omm soft stack 3072 omm hard stack 3072 omm soft nofile 1000000 omm hard nofile 1000000 omm soft nproc unlimited * soft nproc 65536 * hard nproc 65536 * soft nofile 65536 * hard nofile 65536 EOF# 关闭透明大页echonever>/sys/kernel/mm/transparent_hugepage/enabledechonever>/sys/kernel/mm/transparent_hugepage/defragecho'echo never > /sys/kernel/mm/transparent_hugepage/enabled'>>/etc/rc.localecho'echo never > /sys/kernel/mm/transparent_hugepage/defrag'>>/etc/rc.localchmod+x /etc/rc.d/rc.local