Document Feedback

default_buffer_water_mark

Last Updated：2024-03-07 08:37:59 Updated

default_buffer_water_mark specifies the watermark for controlling the internal buffer size of OceanBase Database Proxy (ODP). ODP processes the requests only after their size exceeds this threshold.

Attribute	Description
Parameter type	Capacity
Default value	32KB
Value range	[4B, 64KB]

Previous topic

current_local_config_version

Last

Next topic

default_inactivity_timeout

OceanBase Database Proxy

V4.2.2

What is ODP?
Installation and deployment
- Overview
- Use OBD to deploy ODP
- Deploy ODP by using OCP
- Deploy ODP by using the CLI
- Deployment modes
Basic operations
Configuration parameter
- View and modify parameters
- Parameter summary
- Parameters that take effect dynamically
  - binlog_service_ip
  - cache_cleaner_clean_interval
  - check_tenant_locality_change
  - client_max_connections
  - client_max_memory_size
  - client_sock_option_flag_out
  - client_tcp_keepcnt
  - client_tcp_keepidle
  - client_tcp_keepintvl
  - client_tcp_user_timeout
  - cluster_count_high_water_mark
  - cluster_expire_time
  - config_server_refresh_interval
  - congestion_fail_window
  - congestion_failure_threshold
  - congestion_retry_interval
  - connection_diagnosis_option
  - connect_observer_max_retries
  - current_local_config_version
  - default_buffer_water_mark
  - default_inactivity_timeout
  - delay_exit_time
  - delay_update_entry_interval
  - detect_server_timeout
  - digest_sql_length
  - enable_abort_conn_info
  - enable_async_log
  - enable_async_pull_location_cache
  - enable_bad_route_reject
  - enable_binlog_service
  - enable_cached_server
  - enable_causal_order_read
  - enable_client_connection_lru_disconnect
  - enable_client_ip_checkout
  - enable_client_ssl
  - enable_cloud_full_username
  - enable_cluster_checkout
  - enable_compression_protocol
  - enable_congestion
  - enable_connection_diagnosis
  - enable_extra_prometheus_metric
  - enable_flow_control
  - enable_full_username
  - enable_get_rslist_remote
  - enable_index_route
  - enable_monitor_stat
  - enable_ob_protocol_v2
  - enable_ob_protocol_v2_with_client
  - enable_partition_table_route
  - enable_performance_mode
  - enable_pl_route
  - enable_primary_zone
  - enable_prometheus
  - enable_proxy_scramble
  - enable_qa_mode
  - enable_qos
  - enable_read_write_split
  - enable_report_session_stats
  - enable_reroute
  - enable_sequence_prefetch
  - enable_server_ssl
  - enable_sharding
  - enable_standby
  - enable_stat
  - enable_strict_stat_time
  - enable_sync_all_stats
  - enable_syslog_file_compress
  - enable_trace
  - enable_trace_stats
  - enable_trans_detail_stats
  - enable_transaction_internal_routing
  - enable_transaction_split
  - enable_weak_reroute
  - enable_xa_route
  - fetch_proxy_bin_random_time
  - fetch_proxy_bin_timeout
  - flow_consumer_reenable_threshold
  - flow_event_queue_threshold
  - flow_high_water_mark
  - flow_low_water_mark
  - hot_upgrade_exit_timeout
  - hot_upgrade_failure_retries
  - hot_upgrade_rollback_timeout
  - idc_list_refresh_interval
  - ignore_local_config
  - internal_cmd_mem_limited
  - ldg_info_refresh_interval
  - log_cleanup_interval
  - log_dir_size_threshold
  - log_file_percentage
  - long_async_task_timeout
  - max_log_file_size
  - max_syslog_file_count
  - max_syslog_file_time
  - metadb_server_state_refresh_interval
  - min_congested_connect_timeout
  - min_keep_congestion_interval
  - monitor_cost_ms_unit
  - monitor_item_limit
  - monitor_item_max_idle_period
  - monitor_log_level
  - monitor_stat_dump_interval
  - monitor_stat_high_threshold
  - monitor_stat_low_threshold
  - monitor_stat_middle_threshold
  - mysql_version
  - need_convert_vip_to_tname
  - net_config_poll_timeout
  - normal_pl_update_threshold
  - ob_max_read_stale_time
  - obproxy_force_parallel_query_dop
  - obproxy_read_consistency
  - obproxy_read_only
  - obproxy_sys_password
  - observer_query_timeout_delta
  - observer_sys_password
  - observer_sys_password1
  - partition_location_expire_relative_time
  - prometheus_sync_interval
  - proxy_hot_upgrade_check_interval
  - proxy_idc_name
  - proxy_info_check_interval
  - proxy_local_cmd
  - proxy_mem_limited
  - proxy_primary_zone_name
  - proxy_route_policy
  - proxy_tenant_name
  - qa_mode_mock_public_cloud_slb_addr
  - qos_stat_clean_interval
  - qos_stat_item_limit
  - query_digest_time_threshold
  - read_stale_retry_interval
  - refresh_idc_list
  - refresh_json_config
  - refresh_rslist
  - request_buffer_length
  - route_diagnosis_level
  - routing_cache_mem_limited
  - sequence_entry_expire_time
  - sequence_fail_retry_count
  - sequence_prefetch_threshold
  - server_detect_fail_threshold
  - server_detect_mode
  - server_detect_refresh_interval
  - server_routing_mode
  - server_state_refresh_interval
  - server_tcp_init_cwnd
  - server_tcp_keepcnt
  - server_tcp_keepidle
  - server_tcp_keepintvl
  - server_tcp_user_timeout
  - short_async_task_timeout
  - skip_proxy_sys_private_check
  - skip_proxyro_check
  - slow_proxy_process_time_threshold
  - slow_query_time_threshold
  - slow_transaction_time_threshold
  - sock_option_flag_out
  - sock_packet_mark_out
  - sock_packet_tos_out
  - sock_recv_buffer_size_out
  - sock_send_buffer_size_out
  - sql_table_cache_expire_relative_time
  - sql_table_cache_mem_limited
  - sqlaudit_mem_limited
  - ssl_attributes
  - stat_dump_interval
  - stat_table_sync_interval
  - syslog_level
  - target_db_server
  - tenant_location_valid_time
  - tunnel_request_size_threshold
  - username_separator
  - xflush_log_level
- Parameters that take effect after a restart
  - automatic_match_work_thread
  - block_thread_num
  - enable_cpu_isolate
  - enable_cpu_topology
  - enable_global_ps_cache
  - enable_strict_kernel_release
  - grpc_client_num
  - grpc_thread_num
  - ip_listen_mode
  - listen_port
  - local_bound_ip
  - local_bound_ipv6_ip
  - net_accept_threads
  - obproxy_config_server_url
  - prometheus_cost_ms_unit
  - prometheus_listen_port
  - rootservice_cluster_name
  - rootservice_list
  - shard_scan_thread_num
  - stack_size
  - task_thread_num
  - work_thread_num
Connection management
- Principles
- Session status synchronization
- Client session
- Server session
- Connection diagnostics
Data routing
- Factors affecting data routing
- ODP routing
- Intra-tenant routing
  - Overview
  - IP address-based routing
  - Partitioned table-based routing for strong-consistency reads
  - Global index table-based routing for strong-consistency reads
  - Replication table-based routing for strong-consistency reads
  - Primary zone-based routing for strong-consistency reads
  - Strategy-based routing
  - Distributed transaction routing
  - Rerouting
  - Forcible routing
- Read/Write separation
- Follower latency threshold
High availability mechanism
- Overview
- High availability of ODP services
- High availability of OceanBase Database
- High availability testing
Security and protocols
Operation and maintenance
- Troubleshooting
  - Troubleshooting logic
  - Monitoring logs
- Performance analysis
- Show Trace
- Routing diagnostics
  - Overview
  - Obtain diagnostic information
  - Diagnostic point troubleshooting
    - Overview
    - SQL_PARSE
    - ROUTE_INFO
    - LOCATION_CACHE_LOOKUP
    - ROUTINE_ENTRY_LOOKUP_DONE
    - FETCH_TABLE_RELATED_DATA
    - TABLE_ENTRY_LOOKUP_DONE
    - EXPR_PARSE
    - CALC_ROWID
    - RESOLVE_TOKEN
    - RESOLVE_EXPR
    - CALC_PARTITION_ID
    - PARTITION_ID_CALC_DONE
    - PARTITION_ENTRY_LOOKUP_DONE
    - ROUTE_POLICY
    - CONGESTION_CONTROL
    - RETRY
    - HANDLE_RESPONSE
  - Examples
Release Notes
- Versioning rules
- Enterprise Edition
  - V4.2
    - ODP Enterprise Edition V4.2.2
    - ODP Enterprise Edition V4.2.1
  - V4.1
    - ODP Enterprise Edition V4.1.0
  - V4.0
    - ODP Enterprise Edition V4.0.0
  - V3.2
    - ODP V3.2.11
    - ODP Enterprise Edition V3.2.3.5
- Community Edition
  - V4.2
    - ODP Community Edition V4.2.1
    - ODP Community Edition V4.2.0
  - V4.1
    - ODP Community Edition V4.1.0
  - V4.0
    - ODP Community Edition V4.0.0