文档反馈

分布式版-V3.1.4社区版

文档概览
使用指南
- 数据库简介
- 快速入门
- 安装部署
- 数据迁移
- 数据库连接和路由
- 集群和多租户管理
- 数据库对象管理
- 分布式存储管理
- 性能调优
- 数据高可用
- 运维管理
- 参考指南
  - 系统视图
  - 常用内部表
  - 系统变量
  - 系统配置项
    - 系统配置项概述
    - auto_leader_switch_interval
    - auto_delete_expired_backup
    - autoinc_cache_refresh_interval
    - backup_zone
    - balancer_idle_time
    - balancer_log_interval
    - balancer_timeout_check_interval
    - balancer_task_timeout
    - balancer_tolerance_percentage
    - balancer_emergency_percentage
    - balance_blacklist_failure_threshold
    - balance_blacklist_retry_interval
    - backup_concurrency
    - backup_dest
    - backup_dest_option
    - backup_net_limit
    - backup_recovery_window
    - backup_region
    - builtin_db_data_verify_cycle
    - bf_cache_miss_count_threshold
    - bf_cache_priority
    - cache_wash_threshold
    - clog_cache_priority
    - clog_sync_time_warn_threshold
    - clog_disk_usage_limit_percentage
    - clog_max_unconfirmed_log_count
    - cluster
    - cluster_id
    - cpu_count
    - cpu_quota_concurrency
    - cpu_reserved
    - config_additional_dir
    - data_copy_concurrency
    - data_dir
    - datafile_disk_percentage
    - dtl_buffer_size
    - datafile_size
    - debug_sync_timeout
    - default_compress_func
    - default_compress
    - default_progressive_merge_num
    - default_row_format
    - devname
    - data_disk_usage_limit_percentage
    - disk_io_thread_count
    - dead_socket_detection_timeout
    - election_cpu_quota
    - enable_one_phase_commit
    - enable_sys_unit_standalone
    - enable_smooth_leader_switch
    - election_blacklist_interval
    - enable_election_group
    - enable_auto_leader_switch
    - enable_global_freeze_trigger
    - enable_manual_merge
    - enable_merge_by_turn
    - enable_perf_event
    - enable_rebalance
    - enable_record_trace_log
    - enable_record_trace_id
    - enable_early_lock_release
    - enable_rereplication
    - enable_rich_error_msg
    - enable_rootservice_standalone
    - enable_sql_audit
    - enable_sql_operator_dump
    - enable_async_syslog
    - enable_syslog_recycle
    - enable_syslog_wf
    - enable_upgrade_mode
    - enable_separate_sys_clog
    - enable_ddl
    - enable_major_freeze
    - enable_rebuild_on_purpose
    - enable_log_archive
    - enable_monotonic_weak_read
    - freeze_trigger_percentage
    - flush_log_at_trx_commit
    - fuse_row_cache_priority
    - force_refresh_location_cache_interval
    - force_refresh_location_cache_threshold
    - gc_wait_archive
    - get_leader_candidate_rpc_timeout
    - global_major_freeze_residual_memory
    - global_write_halt_residual_memory
    - ignore_replay_checksum_error
    - global_index_build_single_replica_timeout
    - high_priority_net_thread_count
    - ignore_replica_checksum_error
    - index_cache_priority
    - index_clog_cache_priority
    - index_info_block_cache_priority
    - internal_sql_execute_timeout
    - large_query_worker_percentage
    - large_query_threshold
    - leak_mod_to_check
    - lease_time
    - location_cache_cpu_quota
    - location_cache_expire_time
    - location_cache_priority
    - location_cache_refresh_min_interval
    - location_fetch_concurrency
    - location_refresh_thread_count
    - log_archive_checkpoint_interval
    - log_archive_concurrency
    - log_restore_concurrency
    - major_freeze_duty_time
    - max_kept_major_version_number
    - max_string_print_length
    - max_syslog_file_count
    - merge_stat_sampling_ratio
    - major_compact_trigger
    - memory_chunk_cache_size
    - memory_limit
    - memory_limit_percentage
    - memory_reserved
    - merge_thread_count
    - merger_check_interval
    - merger_completion_percentage
    - merger_switch_leader_duration_time
    - merger_warm_up_duration_time
    - max_px_worker_count
    - migration_disable_time
    - min_observer_version
    - minor_deferred_gc_time
    - minor_freeze_times
    - minor_warm_up_duration_time
    - mysql_port
    - minor_merge_concurrency
    - multiblock_read_gap_size
    - multiblock_read_size
    - micro_block_merge_verify_level
    - migrate_concurrency
    - minor_compact_trigger
    - memstore_limit_percentage
    - net_thread_count
    - obconfig_url
    - ob_enable_batched_multi_statement
    - partition_table_check_interval
    - partition_table_scan_batch_count
    - plan_cache_evict_interval
    - px_task_size
    - px_workers_per_cpu_quota
    - replica_safe_remove_time
    - resource_hard_limit
    - resource_soft_limit
    - rootservice_async_task_queue_size
    - rootservice_async_task_thread_count
    - rootservice_list
    - rootservice_ready_check_interval
    - row_compaction_update_limit
    - row_purge_thread_count
    - rpc_port
    - rpc_timeout
    - restore_concurrency
    - rootservice_memory_limit
    - rebuild_replica_data_lag_threshold
    - schema_history_expire_time
    - schema_history_recycle_interval
    - ssl_client_authentication
    - server_check_interval
    - server_data_copy_in_concurrency
    - server_data_copy_out_concurrency
    - server_permanent_offline_time
    - stack_size
    - server_balance_critical_disk_waterlevel
    - server_balance_disk_tolerance_percent
    - system_memory
    - server_balance_cpu_mem_tolerance_percent
    - server_cpu_quota_max
    - server_cpu_quota_min
    - sql_audit_memory_limit
    - sys_bkgd_io_high_percentage
    - sys_bkgd_io_low_percentage
    - sys_bkgd_net_percentage
    - sys_bkgd_migration_change_member_list_timeout
    - sys_bkgd_migration_retry_num
    - syslog_level
    - switchover_process_thread_count
    - system_cpu_quota
    - sys_cpu_limit_trigger
    - syslog_io_bandwidth_limit
    - tablet_size
    - tableapi_transport_compress_func
    - tenant_task_queue_size
    - tenant_groups
    - trace_log_slow_query_watermark
    - trace_log_sampling_interval
    - trx_2pc_retry_interval
    - trx_force_kill_threshold
    - token_reserved_percentage
    - unit_balance_resource_weight
    - user_block_cache_priority
    - user_row_cache_priority
    - user_tab_col_stat_cache_priority
    - user_iort_up_percentage
    - use_large_pages
    - virtual_table_location_cache_expire_time
    - workers_per_cpu_quota
    - wait_leader_batch_count
    - writing_throttling_maximum_duration
    - writing_throttling_trigger_percentage
    - weak_read_version_refresh_interval
    - workarea_size_policy
    - zone
    - zone_merge_concurrency
    - zone_merge_order
    - zone_merge_timeout
    - ob_ssl_invited_common_names
    - ssl_external_kms_info
    - ob_event_history_recycle_interval
    - plsql_ccflags
    - plsql_code_type
    - plsql_debug
    - plsql_optimize_level
    - plsql_v2_compatibility
    - plsql_warnings
    - recyclebin_object_expire_time
    - log_archive_batch_buffer_limit
    - clog_disk_utilization_threshold
    - open_cursors
    - fast_recovery_concurrency
    - enable_auto_refresh_location_cache
    - auto_refresh_location_cache_rate_limit
    - auto_broadcast_location_cache_rate_limit
    - data_storage_warning_tolerance_time
    - data_storage_error_tolerance_time
    - ob_proxy_readonly_transaction_routing_policy
    - enable_tcp_keepalive
    - tcp_keepidle
    - tcp_keepintvl
    - tcp_keepcnt
    - backup_log_archive_option
    - datafile_maxsize
    - datafile_next
    - enable_kv_ttl
    - kv_ttl_duty_duration
    - kv_ttl_history_recycle_interval
    - query_response_time_flush
    - query_response_time_range_base
    - query_response_time_stats
  - 常见隐藏配置项
  - 错误码
  - 预留关键字
在线教程
开发者指南
系统架构
版本发布记录
生态工具
教程
术语

log_archive_batch_buffer_limit

更新时间：2023-08-03 17:20:32

分享

当物理备份开启时，log_archive_batch_buffer_limit 用于控制日志归档单机的最大内存使用量。

描述

属性	描述
参数类型	容量类型
默认值	1G
取值范围	[4M, +∞)
是否重启 OBServer 生效	否

示例

obclient> ALTER SYSTEM SET log_archive_batch_buffer_limit = 1GB;

有帮助

无帮助

log_archive_batch_buffer_limit | OceanBase 文档中心