#The file(check_list.conf) is the gs_check and gs_checkos configuration file. #The file is placed in $GPHOME/script/util # the system control parameter [/etc/sysctl.conf] net.ipv4.tcp_max_tw_buckets = 10000 net.ipv4.tcp_tw_reuse = 1 net.ipv4.tcp_tw_recycle = 1 net.ipv4.tcp_keepalive_time = 30 net.ipv4.tcp_keepalive_intvl = 30 net.ipv4.tcp_keepalive_probes = 9 net.ipv4.tcp_retries2 = 80 net.core.wmem_max = 21299200 net.core.rmem_max = 21299200 net.core.wmem_default = 21299200 net.core.rmem_default = 21299200 kernel.sem = 250 6400000 1000 25600 net.ipv4.tcp_rmem = 8192 250000 16777216 net.ipv4.tcp_wmem = 8192 250000 16777216 # vm.min_free_kbytes would set to 5% of total system memory real time, total system memory get with cmd: free -k|grep Mem|awk '{print $2}'. vm.min_free_kbytes = total_system_memory*5% net.core.netdev_max_backlog = 65535 net.ipv4.tcp_max_syn_backlog = 65535 net.core.somaxconn = 65535 net.ipv4.tcp_syncookies = 1 vm.overcommit_memory = 0 vm.panic_on_oom = 0 vm.oom_kill_allocating_task = 0 kernel.shmall = 1152921504606846720 kernel.shmmax = 18446744073709551615 # if parameter value is not equal to ths OS's value, print the waring, and not error [SUGGEST:/etc/sysctl.conf] net.ipv4.tcp_fin_timeout = 60 net.ipv4.tcp_sack = 1 net.ipv4.tcp_timestamps = 1 net.ipv4.tcp_retries1 = 5 net.ipv4.tcp_syn_retries = 5 net.ipv4.tcp_synack_retries = 5 vm.extfrag_threshold = 500 vm.overcommit_ratio = 90 # open file number, please set it to set '1000000' [/etc/security/limits.conf] open files = 1000000 stack size = 3072 # network parameter # if the level of network is greater or equal to 10000Mb/s, please set RX/TX to 4096; # we will check if the MTU is greater or equal to 1500, but gs_checkos dose not set it. # else, skip it. [/sbin/ifconfig] MTU = 8192 RX = 4096 TX = 4096 #gs_check CheckGucConsistent guc parameter ignore list [guc_ignore] listen_addresses = 0 local_bind_address = 0 port = 0 cstore_buffers = 0 max_connections = 0 shared_buffers = 0 work_mem = 0 maintenance_work_mem = 0 data_replicate_buffer_size = 0 pooler_port = 0 log_directory = 0 audit_directory = 0 pgxc_node_name = 0 ssd_cache_dir = 0 enable_adio_function = 0 enable_cstore_ssd_cache = 0 unix_socket_directory = 0 unix_socket_permissions = 0 log_file_mode = 0 max_coordinators = 0 max_datanodes = 0 enable_nestloop = 0 enable_mergejoin = 0 comm_tcp_mode = 0 explain_perf_mode = 0 log_line_prefix = 0 max_active_statements = 0 # Ip and port related comm_control_port = 0 comm_sctp_port = 0 replconninfo2 = 0 replconninfo1 = 0 # Instance directory related ident_file = 0 config_file = 0 hba_file = 0 data_directory = 0 archive_command = 0 xc_maintenance_mode = 0 [guc_logic] allow_concurrent_tuple_update = 0 prefetch_quantity = 0 backwrite_quantity = 0 cstore_prefetch_quantity = 0 cstore_backwrite_max_threshold = 0 cstore_backwrite_quantity = 0 fast_extend_file_size = 0 bgwriter_delay = 0 bgwriter_lru_maxpages = 0 bgwriter_flush_after = 0 autovacuum_naptime = 0 autovacuum_vacuum_threshold = 0 autovacuum_analyze_threshold = 0 autovacuum_vacuum_scale_factor = 0 autovacuum_analyze_scale_factor = 0 enable_stream_operator = 0 enable_data_replicate = 0 wal_keep_segments = 0 wal_sender_timeout = 0 wal_writer_delay = 0 checkpoint_segments = 0 checkpoint_timeout = 0 checkpoint_warning = 0 checkpoint_flush_after = 0 checkpoint_wait_timeout = 0 vacuum_cost_page_hit = 0 vacuum_cost_page_miss = 0 vacuum_cost_page_dirty = 0 vacuum_cost_limit = 0 vacuum_cost_delay = 0 autovacuum_vacuum_cost_delay = 0 autovacuum_vacuum_cost_limit = 0 full_page_writes = 0 fsync = 0 io_limits = 0 io_priority = 0 bulk_write_ring_size = 0 bulk_read_ring_size = 0 partition_mem_batch = 0 partition_max_cache_size = 0 temp_file_limit = 0 query_mem = 0 maintenance_work_mem = 0 synchronous_commit = 0 work_mem = 0 dynamic_memory_quota = 0 temp_buffers = 0 max_loaded_cudesc = 0 wal_receiver_status_interval = 0 wal_receiver_timeout = 0 wal_receiver_connect_timeout = 0 wal_receiver_connect_retries = 0 wal_receiver_buffer_size = 0 data_replicate_buffer_size = 0 max_connections = 0 max_files_per_process = 0 shared_buffers = 0 memorypool_size = 0 cstore_buffers = 0 UDFWorkerMemHardLimit = 0 walsender_max_send_size = 0 wal_buffers = 0 max_wal_senders = 0 autovacuum_freeze_max_age = 0 autovacuum_max_workers = 0 track_activity_query_size = 0 event_source = 0 zhparser_dict_in_memory = 0 memorypool_enable = 0 enable_memory_limit = 0