Configuring the Greenplum parameter

Before you perform a greenplum installation, you need to configure the relevant system parameters, otherwise you will be prone to unexpected errors.

1. Modifying system ParametersEdit/etc/sysctl.conf, the following is the minimum configuration Kernel.shmmax =500000000kernel.shmmni =4096kernel.shmall =4000000000kernel.sem =2505120001002048KERNEL.SYSRQ =1kernel.core_uses_pid =1KERNEL.MSGMNB =65536kernel.msgmax =65536kernel.msgmni =2048net.ipv4.tcp_syncookies =1net.ipv4.ip_forward =0net.ipv4.conf.default.accept_source_route =0net.ipv4.tcp_tw_recycle =1net.ipv4.tcp_max_syn_backlog =4096net.ipv4.conf.all.arp_filter =1net.ipv4.ip_local_port_range =102565535net.core.netdev_max_backlog =10000net.core.rmem_max =2097152net.core.wmem_max =2097152vm.overcommit_memory =2reboot required after modification2. Change the number of open files and other restrictionsEdit/etc/security/limits.conf* Soft Nofile65536* Hard Nofile65536* Soft Nproc131072* Hard Nproc131072 Edit/etc/security/limits.d/90-nproc.conf* Soft Nofile65536* Hard Nofile65536* Soft Nproc131072* Hard Nproc1310723. Modify Scheduler  Edit Scheduler, formerly Cfqecho deadline > Span class= "regexp" >/sys/block/vda/queue/scheduler[[email  Protected] ~]# more/sys/block/vda/queue/scheduler noop anticipatory [ Deadline] CFQ 4. Edit/boot/grub/grub.conf  New elevator= Deadline[root  @bigdata03 ~]# more/boot/grub/grub.conf...elevator= Deadline Crashkernel=auto ... 5. Edit device block size  [root @bigdata03 ~]< span class= "comment" >#/sbin/blockdev--setra 16384/dev/vda[root @bigdata03 ~]#/sbin/blockdev--getra/dev/vda16384       

Specific reference: HTTP://GPDB.DOCS.PIVOTAL.IO/4370/PREP_OS-SYSTEM-PARAMS.HTML#TOPIC3

In fact, before I changed the system parameters, the most error encountered was "insufficient disk space on the device."

The modification plan given by the official website is feasible, but it is more convenient to modify the scheme:

For the first article: Modify system Parameters

<<eofKernel.shmmax = 500000000kernel.shmmni = 4096kernel.shmall = 4000000000kernel.sem = 250 512000 100 20 48KERNEL.SYSRQ = 1kernel.core_uses_pid = 1KERNEL.MSGMNB = 65536kernel.msgmax = 65536kernel.msgmni = 2048net.ipv4.tcp_ Syncookies = 1net.ipv4.ip_forward = 0net.ipv4.conf.default.accept_source_route = 0net.ipv4.tcp_tw_recycle = 1net.ipv4.tcp_max_syn_backlog = 4096net.ipv4.conf.all.arp_filter = 1net.ipv4.ip_local_port_range = 1025 65535net.core.netdev_max_backlog = 10000net.core.rmem_max = 2097152net.core.wmem_max = 2097152vm.overcommit_memory = 2EOF
This can be modified without reboot.

Configuring the Greenplum parameter