flush_log_at_trx_commit | OceanBase 文档中心

文档反馈

分布式版-V3.2.3企业版LTS

V3.2.3 文档更新记录
文档概览
使用指南
- 介绍
- 部署数据库
- 数据迁移
- 数据库连接和路由
- 集群和多租户管理
- 数据库对象管理
- 分布式存储管理
- 性能调优
- 高可用和容灾
- 数据库安全
- 运维操作
- 系统参考
  - 系统配置项
    - 系统配置项概述
    - 系统配置项总览
    - 集群级配置项
      - all_cluster_list
      - auto_broadcast_location_cache_rate_limit
      - auto_delete_expired_backup
      - auto_leader_switch_interval
      - auto_refresh_location_cache_rate_limit
      - autoinc_cache_refresh_interval
      - backup_backup_archive_log_batch_count
      - backup_backup_archivelog_retry_interval
      - backup_backup_dest
      - backup_backupset_batch_count
      - backup_backup_dest_option
      - backup_backupset_retry_interval
      - backup_concurrency
      - backup_dest
      - backup_dest_option
      - backup_log_archive_option
      - backup_net_limit
      - backup_recovery_window
      - backup_region
      - backup_zone
      - balance_blacklist_failure_threshold
      - balance_blacklist_retry_interval
      - balancer_emergency_percentage
      - balancer_idle_time
      - balancer_log_interval
      - balancer_task_timeout
      - balancer_timeout_check_interval
      - balancer_tolerance_percentage
      - bf_cache_miss_count_threshold
      - bf_cache_priority
      - builtin_db_data_verify_cycle
      - cache_wash_threshold
      - clog_cache_priority
      - clog_disk_usage_limit_percentage
      - clog_disk_utilization_threshold
      - clog_expire_days
      - clog_sync_time_warn_threshold
      - clog_transport_compress_all
      - clog_transport_compress_func
      - cluster
      - cluster_id
      - config_additional_dir
      - cpu_count
      - cpu_quota_concurrency
      - cpu_reserved
      - data_copy_concurrency
      - data_dir
      - data_disk_usage_limit_percentage
      - data_storage_error_tolerance_time
      - data_storage_warning_tolerance_time
      - datafile_disk_percentage
      - datafile_size
      - dead_socket_detection_timeout
      - debug_sync_timeout
      - default_compress
      - default_compress_func
      - default_row_format
      - default_transport_compress_func
      - devname
      - disk_io_thread_count
      - dtl_buffer_size
      - election_blacklist_interval
      - election_cpu_quota
      - enable_async_syslog
      - enable_auto_leader_switch
      - enable_auto_refresh_location_cache
      - enable_ddl
      - enable_election_group
      - enable_global_freeze_trigger
      - enable_log_archive
      - enable_major_freeze
      - enable_manual_merge
      - enable_merge_by_turn
      - enable_ob_ratelimit
      - enable_one_phase_commit
      - enable_perf_event
      - enable_pg
      - enable_rebalance
      - enable_record_trace_id
      - enable_record_trace_log
      - enable_rereplication
      - enable_rich_error_msg
      - enable_rootservice_standalone
      - enable_separate_sys_clog
      - enable_smooth_leader_switch
      - enable_sql_audit
      - enable_sql_operator_dump
      - enable_sys_unit_standalone
      - enable_syslog_recycle
      - enable_syslog_wf
      - enable_tcp_keepalive
      - enable_unit_balance_resource_weight
      - enable_upgrade_mode
      - fast_recovery_concurrency
      - flush_log_at_trx_commit
      - force_refresh_location_cache_interval
      - force_refresh_location_cache_threshold
      - freeze_trigger_percentage
      - fuse_row_cache_priority
      - gc_wait_archive
      - get_leader_candidate_rpc_timeout
      - global_index_build_single_replica_timeout
      - global_major_freeze_residual_memory
      - global_write_halt_residual_memory
      - high_priority_net_thread_count
      - ignore_replay_checksum_error
      - ignore_replica_checksum_error
      - ilog_index_expire_time
      - index_cache_priority
      - index_clog_cache_priority
      - index_info_block_cache_priority
      - internal_sql_execute_timeout
      - large_query_threshold
      - large_query_worker_percentage
      - leak_mod_to_check
      - lease_time
      - location_cache_cpu_quota
      - location_cache_expire_time
      - location_cache_priority
      - location_cache_refresh_min_interval
      - location_cache_refresh_rpc_timeout
      - location_cache_refresh_sql_timeout
      - location_fetch_concurrency
      - location_refresh_thread_count
      - log_archive_batch_buffer_limit
      - log_archive_checkpoint_interval
      - log_archive_concurrency
      - log_restore_concurrency
      - major_compact_trigger
      - major_freeze_duty_time
      - max_kept_major_version_number
      - max_px_worker_count
      - max_string_print_length
      - max_syslog_file_count
      - memory_chunk_cache_size
      - memory_limit
      - memory_limit_percentage
      - memory_reserved
      - memstore_limit_percentage
      - merge_stat_sampling_ratio
      - merge_thread_count
      - merger_check_interval
      - merger_completion_percentage
      - merger_switch_leader_duration_time
      - merger_warm_up_duration_time
      - micro_block_merge_verify_level
      - migrate_concurrency
      - migration_disable_time
      - min_observer_version
      - minor_compact_trigger
      - minor_deferred_gc_time
      - minor_freeze_times
      - minor_merge_concurrency
      - minor_warm_up_duration_time
      - multiblock_read_gap_size
      - multiblock_read_size
      - mysql_port
      - net_thread_count
      - ob_event_history_recycle_interval
      - ob_ratelimit_stat_period
      - obconfig_url
      - ofs_list
      - partition_table_check_interval
      - partition_table_scan_batch_count
      - plan_cache_evict_interval
      - plan_cache_high_watermark
      - plan_cache_low_watermark
      - px_task_size
      - px_workers_per_cpu_quota
      - rebuild_replica_data_lag_threshold
      - recyclebin_object_expire_time
      - replica_safe_remove_time
      - resource_hard_limit
      - resource_soft_limit
      - restore_concurrency
      - role_change_timeout
      - rootservice_async_task_queue_size
      - rootservice_async_task_thread_count
      - rootservice_list
      - rootservice_memory_limit
      - rootservice_ready_check_interval
      - row_compaction_update_limit
      - row_purge_thread_count
      - rpc_port
      - rpc_timeout
      - schema_history_expire_time
      - schema_history_recycle_interval
      - server_balance_cpu_mem_tolerance_percent
      - server_balance_critical_disk_waterlevel
      - server_balance_disk_tolerance_percent
      - server_check_interval
      - server_cpu_quota_max
      - server_cpu_quota_min
      - server_data_copy_in_concurrency
      - server_data_copy_out_concurrency
      - server_permanent_offline_time
      - server_temporary_offline_time
      - sql_audit_memory_limit
      - sql_audit_queue_size
      - ssl_client_authentication
      - ssl_external_kms_info
      - stack_size
      - switchover_process_thread_count
      - sys_bkgd_io_high_percentage
      - sys_bkgd_io_low_percentage
      - sys_bkgd_migration_change_member_list_timeout
      - sys_bkgd_migration_retry_num
      - sys_bkgd_net_percentage
      - sys_cpu_limit_trigger
      - syslog_io_bandwidth_limit
      - syslog_level
      - system_cpu_quota
      - system_memory
      - system_trace_level
      - tableapi_transport_compress_func
      - tablet_size
      - tcp_keepcnt
      - tcp_keepidle
      - tcp_keepintvl
      - tenant_cpu_variation_per_server
      - tenant_groups
      - tenant_task_queue_size
      - token_reserved_percentage
      - trace_log_sampling_interval
      - trace_log_slow_query_watermark
      - trx_2pc_retry_interval
      - trx_force_kill_threshold
      - trx_try_wait_lock_timeout
      - unit_balance_resource_weight
      - use_large_pages
      - user_block_cache_priority
      - user_iort_up_percentage
      - user_row_cache_priority
      - user_tab_col_stat_cache_priority
      - virtual_table_location_cache_expire_time
      - wait_leader_batch_count
      - weak_read_version_refresh_interval
      - workers_per_cpu_quota
      - zone
      - zone_merge_concurrency
      - zone_merge_order
      - zone_merge_timeout
      - ob_esi_rpc_port
      - enable_ob_esi_process
      - ob_esi_session_timeout
      - ob_esi_io_concurrency
      - ob_esi_memory_limit
      - ob_esi_syslog_level
      - ob_esi_max_syslog_file_count
      - max_trx_2pc_retry_interval
    - 租户级配置项
  - 系统变量（MySQL 模式）
  - 系统变量（Oracle 模式）
  - 系统视图（MySQL 模式）
  - 系统视图（Oracle 模式）
  - 常见统计事件说明
  - 常见等待事件说明
  - 错误码（MySQL 模式）
  - 错误码（Oracle 模式）
  - 预留关键字（MySQL 模式）
  - 预留关键字（Oracle 模式）
开发指南
系统架构
版本发布记录
术语

flush_log_at_trx_commit

更新时间：2023-07-18 17:25:59

分享

flush_log_at_trx_commit 用于设置事务提交时写事务日志策略。

属性	描述
参数类型	整型
默认值	1
取值范围	[0, 2]
是否重启 OBServer 生效	否

flush_log_at_trx_commit 配置项的取值含义如下：

取值为 0 表示不等待日志写入缓冲区。
取值为 1 表示等待日志写入磁盘。
取值为 2 表示等待日志写入缓冲区而不等落盘。

有帮助

无帮助