oceanbase ce 3.1.0 ALTER SYSTEM SET 参数超限 启动不起来怎么办

【产品名称】oceanbase ce 3.1.0

【产品版本】oceanbase ce 3.1.0

【问题描述】oceanbase ce 3.1.0 ALTER SYSTEM SET 参数超限 启动不起来怎么办,需要重装吗,还是可以通过修改配置文件解决(修改哪个配置文件)

OceanBase 社区 做tpc-h 测试时 按照这个进行设置的

  • OceanBase 数据库 V3.1.0 参数配置

ALTER SYSTEM SET memory_chunk_cache_size =‘16G’; ALTER SYSTEM SET trx_try_wait_lock_timeout=‘0ms’; ALTER SYSTEM SET large_query_threshold=‘1s’; ALTER SYSTEM SET trace_log_slow_query_watermark=‘500ms’; ALTER SYSTEM SET syslog_io_bandwidth_limit=‘30m’; ALTER SYSTEM SET merger_warm_up_duration_time=‘0’; ALTER SYSTEM SET merger_switch_leader_duration_time=‘0’; ALTER SYSTEM SET large_query_worker_percentage=10; ALTER SYSTEM SET builtin_db_data_verify_cycle = 0; ALTER SYSTEM SET enable_merge_by_turn = False; ALTER SYSTEM SET minor_merge_concurrency=30; ALTER SYSTEM SET system_memory =‘30G’;–可以根据实际环境动态调整 ALTER SYSTEM SET memory_limit_percentage = 85; ALTER SYSTEM SET memstore_limit_percentage = 80; ALTER SYSTEM SET freeze_trigger_percentage = 30; ALTER SYSTEM SET enable_syslog_recycle=‘True’; ALTER SYSTEM SET max_syslog_file_count=100; ALTER SYSTEM SET minor_freeze_times=500; ALTER SYSTEM SET minor_compact_trigger=5; ALTER SYSTEM SET max_kept_major_version_number=1; ALTER SYSTEM SET sys_bkgd_io_high_percentage = 90; ALTER SYSTEM SET sys_bkgd_io_low_percentage = 70; ALTER SYSTEM SET merge_thread_count = 45; ALTER SYSTEM SET merge_stat_sampling_ratio = 1; ALTER SYSTEM SET writing_throttling_trigger_percentage=75 tenant=xxx; ALTER SYSTEM SET writing_throttling_maximum_duration=‘15m’;

参数需要根据自己的机器规格进行对应调整