171 lines
4.3 KiB
Plaintext
171 lines
4.3 KiB
Plaintext
#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
|
|
|