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

--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

example: # echo deadline > /sys/block/sbd/queue/scheduler One method to set the I/O scheduler policy at boot time is with the elevator kernel parameter. Add the parameter elevator=deadline to the kernel command vary based on your system. VMware Greenplum v6.17 Documentation VMware, Inc. 180 /boot/grub/grub.conf, the GRUB boot loader configuration file. This is an example kernel command from a grub.conf file transparent_hugepage=never initrd /initrd-2.6.18-274.3.1.el5.img 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

--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 reboots. How to run the command will vary based on your system. 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

For example: # echo deadline > /sys/block/sbd/queue/scheduler To specify the I/O scheduler at boot time on systems that use grub2, use the system utility grubby. This command adds the parameter when 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