tpcc.yaml 4.3 KB
Newer Older
F
v1.6.0  
frf12 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182
build:
  variables:
  - name: ob_plan_cache_percentage
    value: 20
  - name: autocommit
    value: 1
  - name: ob_query_timeout
    value: 36000000000
  - name: ob_trx_timeout
    value: 36000000000
  - name: max_allowed_packet
    value: 67108864
  - name: ob_sql_work_area_percentage
    value: 100
  - name: parallel_servers_target
    value: int(max_cpu * server_num * 8)
    expression: true
  - name: binlog_row_image
    value: MINIMAL
  system_config:
  - name: memory_chunk_cache_size
    value: '0'
    value_type: STRING
  - name: trx_try_wait_lock_timeout
    value: 0ms
  - name: large_query_threshold
    value: 1s
  - name: syslog_io_bandwidth_limit
    value: 30m
  - name: enable_async_syslog
    value: 'true'
  - name: merger_warm_up_duration_time
    value: 0
  - name: merger_switch_leader_duration_time
    value: 0
  - name: large_query_worker_percentage
    value: 10
  - name: builtin_db_data_verify_cycle
    value: 0
  - name: enable_merge_by_turn
    value: false
    value_type: BOOL
  - name: minor_merge_concurrency
    value: 30
  - name: memory_limit_percentage
    value: 85
  - name: memstore_limit_percentage
    value: 80
  - name: freeze_trigger_percentage
    value: 60
  - name: enable_syslog_recycle
    value: true
    value_type: BOOL
  - name: max_syslog_file_count
    value: 100
  - name: minor_freeze_times
    value: 500
  - name: minor_compact_trigger
    value: 0
  - name: max_kept_major_version_number
    value: 1
  - name: sys_bkgd_io_high_percentage
    value: 90
  - name: sys_bkgd_io_low_percentage
    value: 70
  - name: merge_thread_count
    value: 45
  - name: merge_stat_sampling_ratio
    value: 1
  - name: writing_throttling_trigger_percentage
    value: 75
    optimizer: tenant
  - name: writing_throttling_maximum_duration
    value: 15m
  - name: enable_sql_audit
    value: 'false'
  - name: enable_early_lock_release
    value: 'false'
    optimizer: tenant
  - name: enable_auto_leader_switch
    value: 'false'
  - name: sleep
    value: 2
    optimizer: sleep
  - name: enable_perf_event
    value: false
    value_type: BOOL
  - name: use_large_pages
    value: 'true'
    need_restart: true
  - name: micro_block_merge_verify_level
    value: 0
  - name: builtin_db_data_verify_cycle
    value: 0
  - name: net_thread_count
    value: 6
    need_restart: true
  - name: _clog_aggregation_buffer_amount
    value: 4
    optimizer: tenant
  - name: _flush_clog_aggregation_buffer_timeout
    value: 2ms
    optimizer: tenant
test:
  system_config:
  - name: writing_throttling_trigger_percentage
    value: 100
    optimizer: tenant
  - name: writing_throttling_maximum_duration
    value: 1h
  - name: memstore_limit_percentage
    value: 80
  - name: freeze_trigger_percentage
    value: 30
  - name: large_query_threshold
    value: 200s
  - name: trx_try_wait_lock_timeout
    value: 0ms
  - name: cpu_quota_concurrency
    value: 4
  - name: minor_warm_up_duration_time
    value: 0
  - name: minor_freeze_times
    value: 500
  - name: minor_compact_trigger
    value: 3
  - name: sys_bkgd_io_high_percentage
    value: 90
  - name: sys_bkgd_io_low_percentage
    value: 70
  - name: minor_merge_concurrency
    value: 20
  - name: builtin_db_data_verify_cycle
    value: 0
  - name: trace_log_slow_query_watermark
    value: 10s
  - name: gts_refresh_interval
    value: 500us
  - name: server_permanent_offline_time
    value: 36000s
  - name: _ob_get_gts_ahead_interval
    value: 1ms
  - name: bf_cache_priority
    value: 10
  - name: user_block_cache_priority
    value: 5
  - name: merge_stat_sampling_ratio
    value: 1
  - name: enable_sql_audit
    value: 'false'
  - name: bf_cache_miss_count_threshold
    value: 1
  - name: __easy_memory_limit
    value: 20G
  - name: _enable_defensive_check
    value: 0
  - name: sleep
    value: 2
    optimizer: sleep
  - name: syslog_level
    value: PERF
  - name: max_syslog_file_count
    value: 100
  - name: enable_syslog_recycle
    value: true
    value_type: BOOL
  - name: ob_enable_batched_multi_statement
    value: true
    optimizer: tenant
    value_type: BOOL
  - name: _cache_wash_interval
    value: 1m
  - name: cache_wash_threshold
    value: 10G
  - name: plan_cache_evict_interval
    value: 30s
  - name: enable_one_phase_commit
    value: 'false'
  - name: use_large_pages
    value: 'true'
  - name: enable_monotonic_weak_read
    value: 'false'