This topic describes the list of parameters for cluster instances.
| Parameter | Description |
|---|---|
| sys_bkgd_io_low_percentage | The minimum percentage of I/O resources occupied by the system in the background. If the value is 0, the system automatically adjusts the I/O resources based on the environment. |
| clog_transport_compress_all | Specifies whether to compress transaction logs for transfer. |
| enable_rebalance | Specifies whether to enable automatic load balancing among partitions. |
| location_refresh_thread_count | The number of threads for refreshing the location cache. |
| location_cache_expire_time | The retention period of cached objects in the location cache. |
| force_refresh_location_cache_threshold | The maximum number of location cache refreshes allowed in one second. Throttling is triggered when this threshold is reached. |
| max_stale_time_for_weak_consistency | The maximum delay allowed in weak consistency reads. |
| multiblock_read_gap_size | The maximum size of data that can be read from the block cache in one I/O aggregate read. |
| user_tab_col_stat_cache_priority | The priority of the statistics cache in the cache system. |
| location_cache_priority | The retention period of cached objects in the location cache. |
| user_row_cache_priority | The priority of the baseline data row cache in the cache system. |
| multiblock_read_size | The I/O aggregate throughput in data access. |
| sys_bkgd_io_high_percentage | The maximum percentage of system background I/O. |
| fuse_row_cache_priority | The priority of the fuse row cache in the cache system. |
| force_refresh_location_cache_interval | The maximum interval for refreshing the location cache. |
| sys_bkgd_net_percentage | The percentage of network bandwidth that can be used by background system tasks. |
| index_cache_priority | The priority of the index in the cache system. |
| clog_cache_priority | The caching priority of transaction logs. |
| large_query_threshold | The execution time threshold at which a query is deemed a large query. When this threshold is reached, large query scheduling strategies are implemented. |
| micro_block_merge_verify_level | The validation level of macroblocks in a major compaction. |
| bf_cache_priority | The caching priority of the Bloom filter. |
| bf_cache_miss_count_threshold | The number of macroblock retrieval failures that triggers the creation of the Bloom filter cache. When the value is set to 0, this feature is disabled. |
| user_block_cache_priority | The priority of the block index in the cache system. |
| memory_reserved | The size of the reserved memory. |
| builtin_db_data_verify_cycle | The cycle of bad block check in the unit of days. The value 0 specifies not to perform bad block check. |
| partition_table_scan_batch_count | The number of replicas that can be pre-read in a batch during a partition table traversal. |
| sys_cpu_limit_trigger | The CPU utilization threshold at which background tasks are suspended. |
| location_fetch_concurrency | The maximum number of concurrent location cache information updates. |
| index_clog_cache_priority | The priority of the transaction log index in the cache system. |
| virtual_table_location_cache_expire_time | The expiration time of the location cache of the virtual table. |
| location_cache_refresh_min_interval | The minimum interval for sending location cache refresh requests to prevent excessive refresh requests from overloading the system. |
| clog_transport_compress_func | The algorithm for compressing transaction logs for internal transfer. |
| trx_try_wait_lock_timeout | The maximum amount of time that a statement waits for a locked row to be unlocked. |