暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

民生银行测试用例参数

原创 Cabbage 2025-03-05
27
gs_guc reload -N all -I all -c "authentication_timeout=15s" && 
gs_guc reload -N all -I all -c "cstore_buffers = 32MB" && 
gs_guc reload -N all -I all -c "enable_alarm = off" && 
gs_guc reload -N all -I all -c "enable_delta_store = on" && 
gs_guc reload -N all -I all -c "enable_double_write = on" && 
gs_guc reload -N all -I all -c "enable_incremental_checkpoint = on" && 
gs_guc reload -N all -I all -c "enable_wdr_snapshot = off" && 
gs_guc reload -N all -I all -c "enable_xlog_prune = on" && 
gs_guc reload -N all -I all -c "log_min_duration_statement = 1s" && 
gs_guc reload -N all -I all -c "maintenance_work_mem=2GB" && 
gs_guc reload -N all -I all -c "max_connections = 2000" && 
gs_guc reload -N all -I all -c "max_files_per_process = 10000" && 
gs_guc reload -N all -I all -c "max_prepared_transactions = 2000" && 
gs_guc reload -N all -I all -c "modify_initial_password = off" && 
gs_guc reload -N all -I all -c "password_effect_time = 0" && 
gs_guc reload -N all -I all -c "password_lock_time = 0" && 
gs_guc reload -N all -I all -c "password_reuse_time=0" && 
gs_guc reload -N all -I all -c "password_min_digital=1" && 
gs_guc reload -N all -I all -c "password_min_length=8" && 
gs_guc reload -N all -I all -c "password_min_lowercase=1" && 
gs_guc reload -N all -I all -c "password_min_special=1" && 
gs_guc reload -N all -I all -c "password_min_uppercase=1" && 
gs_guc reload -N all -I all -c "password_policy=1" && 
gs_guc reload -N all -I all -c "session_timeout = 0" && 
gs_guc reload -N all -I all -c "shared_buffers = 20GB" && 
gs_guc reload -N all -I all -c "synchronous_commit = remote_receive" && 
gs_guc reload -N all -I all -c "temp_buffers = 1GB" && 
gs_guc reload -N all -I all -c "update_lockwait_timeout = 30s" && 
gs_guc reload -N all -I all -c "wal_buffers = 64MB" && 
gs_guc reload -N all -I all -c "wdr_snapshot_interval = 10min" && 
gs_guc reload -N all -I all -c "work_mem = 512MB" && 
gs_guc reload -N all -I all -c "log_temp_files = 100MB" && 
gs_guc reload -N all -I all -c "most_available_sync = ON" && 
gs_guc reload -N all -I all -c "enable_mergejoin = ON" && 
gs_guc reload -N all -I all -c "enable_nestloop = ON" && 
gs_guc reload -N all -I all -c "advance_xlog_file_num = 10" && 
gs_guc reload -N all -I all -c "pagewriter_sleep = 1000ms" && 
gs_guc reload -N all -I all -c "xloginsert_locks = 50" && 
gs_guc reload -N all -I all -c "lockwait_timeout = 30s" && 
gs_guc reload -N all -I all -c "enable_opfusion = off" && 
gs_guc reload -N all -I all -c "max_process_memory=60GB" && 
gs_guc reload -N all -I all -c "log_file_mode = 0755" && 
gs_guc reload -N all -I all -c "catchup2normal_wait_time = 0" && 
gs_guc reload -N all -I all -c "audit_enabled=on" && 
gs_guc reload -N all -I all -c "audit_resource_policy=on" && 
gs_guc reload -N all -I all -c "audit_space_limit=10GB" && 
gs_guc reload -N all -I all -c "audit_set_parameter=0" && 
gs_guc reload -N all -I all -c "audit_system_object=524287" && 
gs_guc reload -N all -I all -c "audit_grant_revoke=1" && 
gs_guc reload -N all -I all -c "audit_database_process=1" && 
gs_guc reload -N all -I all -c "audit_user_locked=1" && 
gs_guc reload -N all -I all -c "audit_login_logout=2" && 
gs_guc reload -N all -I all -c "max_size_for_xlog_prune=10GB" && 
gs_guc reload -N all -I all -c "wal_sender_timeout=180s" && 
gs_guc reload -N all -I all -c "wal_receiver_timeout=180s" && 
gs_guc reload -N all -I all -c "log_hostname=off" && 
gs_guc reload -N all -I all -c "instr_unique_sql_count=20000" && 
gs_guc reload -N all -I all -c "track_activity_query_size=10240" && 
gs_guc reload -N all -I all -c "enable_asp=on" && 
gs_guc reload -N all -I all -c "listen_addresses='*'" && 
gs_guc reload -N all -I all -c "wal_keep_segments=640" && 
gs_guc reload -N all -I all -c "pagewriter_sleep=500ms" && 
gs_guc reload -N all -I all -c "bgwriter_delay=1s" && 
gs_guc reload -N all -I all -c "enable_auto_clean_unique_sql=on" && 
gs_guc reload -N all -I all -c "autoanalyze_timeout=1200" && 
gs_guc reload -N all -I all -c "autovacuum_max_workers=10" && 
gs_guc reload -N all -I all -c "autovacuum_naptime=300" && 
gs_guc reload -N all -I all -c "autovacuum_vacuum_threshold=1000" && 
gs_guc reload -N all -I all -c "autovacuum_analyze_threshold=1000" && 
gs_guc reload -N all -I all -c "autovacuum_vacuum_scale_factor=0.05" && 
gs_guc reload -N all -I all -c "autovacuum_vacuum_cost_delay=0" && 
gs_guc reload -N all -I all -c "autovacuum_vacuum_cost_limit=10000" && 
gs_guc reload -N all -I all -c "vacuum_cost_delay=0" && 
gs_guc reload -N all -I all -c "vacuum_cost_limit=10000" && 
gs_guc reload -N all -I all -c "log_lock_waits=on" && 
gs_guc reload -N all -I all -c "wal_level=logical" && 
gs_guc reload -I all -N all -c "enable_recyclebin=on" && 
gs_guc reload -I all -N all -c "recyclebin_retention_time=3600" && 
gs_guc reload -I all -N all -c "undo_space_limit_size=256GB" && 
gs_guc reload -I all -N all -c "undo_limit_size_per_transaction=32GB" && 
gs_guc reload -I all -N all -c "enable_ustore=off" && 
gs_guc reload -I all -N all -c "recovery_max_workers=4" && 
gs_guc reload -I all -N all -c "local_syscache_threshold=32MB" && 
gs_guc reload -I all -N all -c "idle_in_transaction_session_timeout=3600" && 
gs_guc reload -I all -N all -c "enable_save_confirmed_lsn=on" &&
gs_guc reload -I all -N all -c "hot standby = off" &&
gs_guc reload -I all -N all -c "enable_double_write = off" &&gs_guc reload -I all -N all -c "enable_recyclebin = off" 
最后修改时间:2025-03-07 09:43:42
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论