Redhat 6.2以后，内核增加了hugepage大页内存管理，关闭hugepage可以提高混合负载管理性能 设置办法：修改local脚本 For SUSE /etc/init.d/boot.local For RHLE /etc/rc.d/rc.local 追加内容： blockdev --setra 16384 /dev/sd* for i in /sys/bl deadline > $i;done echo never > /sys/kernel/mm/transparent_hugepage/enabled 一般不建议直接修改/boot/grub/grub.conf文件或者/boot/grub/menu.lst 常用数据库参数 参数名 Master节点值 Segment节点值 checkpoint_segments 32 32 max_connections

Apps BI / Reporting Machine Learning AI On-Premises NEXT GENERATION DATA PLATFORM Kafka ETL Spring Cloud Data Flow Massively Parallel (MPP) PostgreSQL Kernel Petabyte Scale Loading Query

Private Clouds Fully Managed Clouds NEXT GENERATION DATA PLATFORM Kafka ETL Spring Cloud Data Flow Massively Parallel (MPP) PostgreSQL Kernel Petabyte Scale Loading

的 PostgreSQL 9.X 和 10）中纳入 PostgreSQL 新增功能。 新一代 数据平台 IT 人员 开发 人员 业务 分析师 数据 科学家 灵活 部署 数据源和数据管道 Spring Cloud Data Flow ETL 本地存储 HDFSS 云对象 存储 GemFire Spark 其他 RDBMSes 多结构数据 PIVOTAL GREENPLUM 平台 原生接口

--now chronyd 4. Back up the boot files: $ cp /etc/default/grub /etc/default/grub-backup $ cp /boot/grub2/grub.cfg /boot/grub2/grub.cfg-backup 5. Add the following boot parameters: 1. Disable Transparent Verify that the parameters transparent_hugepage=never and elevator=deadline exist: $ cat /proc/cmdline BOOT_IMAGE=/vmlinuz-3.10.0-1160.el7.x86_64 root=/dev/mapper/centos-root ro cras hkernel=auto spectre_v2=retpoline --now chronyd 4. Back up the boot files: $ cp /etc/default/grub /etc/default/grub-backup $ cp /boot/grub2/grub.cfg /boot/grub2/grub.cfg-backup 5. Add the following boot parameters: 1. Disable Transparent

Master类主机的Raid划分参考示例： 磁盘 Raid 类型 磁盘数量 设备号 可用容量 挂载点 用途 本 地 Raid 1 2 /dev/sda 2048MB /boot 操作系统 剩余尺寸 / Greenplum Database 管理员指南 V6.2.1 版权所有：Esena(陈淼 +86 18616691889) 编写：陈淼 - 271 - 计算节点类主机的Raid划分参考示例： 磁盘 Raid 类型 磁盘数量 设备号 可用容量 挂载点 用途 本 地 盘 Raid 1 2 /dev/sda 2048MB /boot 操作系统 剩余尺寸 / Raid 5 Y+1+1 /dev/sdb 内存尺寸/2 swap SWAP /dev/sdc 剩余尺寸 /data1 GP 数据盘 7操作系统，这也是目前的主流选择： 选项 要求 操作系统版本 rhel-server-7.4-x86_64 目录及尺寸要求 挂载点 设备名 文件系统格式 尺寸 /boot /sda1 XFS 2048MB / /sda2 XFS 剩余全部 SWAP /sdb SWAP 内存尺寸/2 SWAP /sdd SWAP 内存尺寸/2

For example: # echo deadline > /sys/block/sbd/queue/scheduler To specify the I/O scheduler at boot time on systems that use grub2 such as RHEL 7.x or CentOS 7.x and later, use the system utility grubby adding the parameter transparent_hugepage=never to the kernel command in the file /boot/grub/grub.conf, the GRUB boot loader configuration file. This is an example kernel command from a grub.conf file Y="true" 2. As root, run the grub2-mkconfig command to update the kernels. # grub2-mkconfig -o /boot/grub2/grub.cfg 3. Reboot the system. Synchronizing System Clocks You must use NTP (Network Time

--now chronyd 4. Back up the boot files: $ cp /etc/default/grub /etc/default/grub-backup $ cp /boot/grub2/grub.cfg /boot/grub2/grub.cfg-backup 5. Add the following boot parameters: 1. Disable Transparent Verify that the parameters transparent_hugepage=never and elevator=deadline exist: $ cat /proc/cmdline BOOT_IMAGE=/vmlinuz-3.10.0-1160.el7.x86_64 root=/dev/mapper/centos-root ro cras hkernel=auto spectre_v2=retpoline --now chronyd 4. Back up the boot files: $ cp /etc/default/grub /etc/default/grub-backup $ cp /boot/grub2/grub.cfg /boot/grub2/grub.cfg-backup 5. Add the following boot parameters: 1. Disable Transparent

--now chronyd 4. Back up the boot files: $ cp /etc/default/grub /etc/default/grub-backup $ cp /boot/grub2/grub.cfg /boot/grub2/grub.cfg-backup 5. Add the following boot parameters: 1. Disable Transparent that the parameters transparent_hugepage=never and elevator=deadline exist: $ cat /proc/cmdline BOOT_IMAGE=/vmlinuz-3.10.0-1160.el7.x86_64 root=/dev/mapper/centos-root ro cras hkernel=auto spectre_v2=retpoline --now chronyd 4. Back up the boot files: $ cp /etc/default/grub /etc/default/grub-backup $ cp /boot/grub2/grub.cfg /boot/grub2/grub.cfg-backup 5. Add the following boot parameters: 1. Disable Transparent

For example: # echo deadline > /sys/block/sbd/queue/scheduler To specify the I/O scheduler at boot time on systems that use grub2 such as RHEL 7.x or CentOS 7.x, use the system utility grubby. This adding the parameter transparent_hugepage=never to the kernel command in the file /boot/grub/grub.conf, the GRUB boot loader configuration file. This is an example kernel command from a grub.conf file Y="true" 2. As root, run the grub2-mkconfig command to update the kernels. # grub2-mkconfig -o /boot/grub2/grub.cfg 3. Reboot the system. Synchronizing System Clocks You should use NTP (Network Time