Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->

Start on Cloud

OceanBase

A unified distributed database ready for your transactional, analytical, and AI workloads.

Product Overview

DEPLOY YOUR WAY

OceanBase Cloud

The best way to deploy and scale OceanBase

OceanBase Enterprise

Run and manage OceanBase on your infra

TRY OPEN SOURCE

OceanBase Community Edition

The free, open-source distributed database

OceanBase seekdb

Open source AI native search database

Customer Stories

Real-world success stories from enterprises across diverse industries.

View All

BY USE CASES

Mission-Critical Transactions

Global & Multicloud Application

Elastic Scaling for Peak Traffic

Real-time Analytics

Active Geo-redundancy

Database Consolidation

Comprehensive knowledge hub for OceanBase.

Blog

Live Demos

Training & Certification

Documentation

Official technical guides, tutorials, API references, and manuals for all OceanBase products.

View All

PRODUCTS

OceanBase Cloud

OceanBase Database

Tools Connectors and Middleware

QUICK START

OceanBase Cloud OceanBase Database

BEST PRACTICES

Practical guides for utilizing OceanBase more effectively and conveniently

Learn more about OceanBase – our company, partnerships, and trust and security initiatives.

About OceanBase

Partner

Trust Center

OceanBase Database Proxy

V4.3.6

What is ODP?
Installation and deployment
- Deployment modes
- Overview
- Deploy ODP by using obd
- Deploy ODP by using OCP
- Deploy ODP by using the CLI
Basic operations
Configuration parameter
- Parameter summary
- View and modify parameters
- Global parameters
  - cluster_count_high_water_mark
  - rpc_client_net_write_timeout
  - proxy_hot_upgrade_check_interval
  - rpc_sub_request_isolation_mode
  - enable_compression_protocol
  - enable_standby
  - enable_syslog_file_compress
  - check_tenant_locality_change
  - sequence_entry_expire_time
  - max_syslog_file_time
  - rpc_client_net_read_timeout
  - client_max_memory_size
  - server_tcp_init_cwnd
  - sql_table_cache_mem_limited
  - enable_single_leader_node_routing
  - hot_upgrade_failure_retries
  - client_tcp_user_timeout
  - rpc_partition_calc_max_retries
  - enable_congestion
  - rpc_enable_retry_request_info_log
  - session_pool_idle_timeout
  - default_inactivity_timeout
  - rpc_enable_requestsm_info
  - enable_syslog_wf
  - client_session_id_version
  - congestion_failure_threshold
  - rpc_max_server_table_entry_num
  - log_dir_size_threshold
  - ldg_info_refresh_interval
  - cache_cleaner_clean_interval
  - grpc_thread_num
  - rpc_async_pull_batch_max_size
  - enable_flow_control
  - server_state_refresh_interval
  - sock_option_flag_out
  - sock_recv_buffer_size_out
  - normal_pl_update_threshold
  - rpc_redis_operation_timeout
  - delay_update_entry_interval
  - rpc_request_server_entry_max_retries
  - enable_transaction_internal_routing
  - client_max_connections
  - tunnel_request_size_threshold
  - partition_location_expire_relative_time
  - detect_server_timeout
  - enable_scan_all_request
  - listen_port
  - rpc_enable_lower_case_table_names
  - enable_extra_prometheus_metric
  - enable_cpu_topology
  - stat_table_sync_interval
  - cluster_expire_time
  - refresh_idc_list
  - skip_proxy_sys_private_check
  - enable_global_ps_cache
  - client_tcp_keepintvl
  - monitor_stat_high_threshold
  - rpc_async_task_thread_num
  - ip_listen_mode
  - rpc_request_timeout
  - digest_sql_length
  - tenant_location_valid_time
  - sequence_prefetch_threshold
  - config_server_refresh_interval
  - enable_get_rslist_remote
  - qos_stat_clean_interval
  - enable_primary_zone
  - local_bound_ipv6_ip
  - enable_index_route
  - flow_event_queue_threshold
  - table_entry_retry_build_limit
  - sql_table_cache_expire_relative_time
  - server_tcp_keepidle
  - min_keep_congestion_interval
  - session_pool_thread_num
  - rpc_request_max_retries
  - enable_connection_diagnosis
  - rpc_support_key_partition_shard_request
  - server_detect_fail_threshold
  - net_accept_threads
  - congestion_fail_window
  - server_tcp_user_timeout
  - fetch_proxy_bin_random_time
  - rpc_enable_reroute
  - monitor_item_limit
  - enable_reroute
  - rpc_redis_default_database_name
  - refresh_rslist
  - proxy_mem_limited
  - monitor_stat_middle_threshold
  - rpc_force_use_original_redis_protocol
  - is_need_skip_delay_interval_schema_changed
  - hot_upgrade_exit_timeout
  - rpc_listen_port
  - refresh_json_config
  - ignore_local_config
  - enable_crash_error_log
  - enable_full_username
  - enable_partition_table_route
  - automatic_match_work_thread
  - scan_buffered_rows_warning_threshold
  - request_buffer_length
  - enable_sharding
  - sqlaudit_mem_limited
  - enable_auto_restart
  - monitor_item_max_idle_period
  - rpc_sub_request_weight
  - rpc_enable_direct_expire_route_entry
  - enable_monitor_stat
  - rpc_server_net_handler_expire_time
  - enable_cpu_isolate
  - rpc_enable_global_index
  - rpc_ctx_expire_time
  - sock_packet_tos_out
  - rpc_net_timeout_base
  - rpc_server_entry_expire_time
  - mem_leak_check_mod_name
  - enable_pl_route
  - fetch_proxy_bin_timeout
  - rpc_enable_congestion
  - local_bound_ip
  - rpc_enable_force_srv_black_list
  - need_convert_vip_to_tname
  - enable_bad_route_reject
  - enable_stat
  - enable_async_log
  - enable_async_pull_location_cache
  - rpc_redis_max_monitor_num
  - server_tcp_keepintvl
  - proxy_cluster
  - long_async_task_timeout
  - syslog_io_bandwidth_limit
  - enable_xa_route
  - enable_sequence_prefetch
  - shard_scan_thread_num
  - routing_cache_mem_limited
  - enable_abort_conn_info
  - rpc_max_request_batch_size
  - enable_obproxy_rpc_service
  - connection_pool_mode
  - enable_trans_detail_stats
  - task_thread_num
  - monitor_cost_ms_unit
  - rpc_enable_async_analyze
  - rpc_srv_session_pool_inactive_timeout
  - short_async_task_timeout
  - monitor_stat_low_threshold
  - proxy_id
  - rootservice_list
  - proxy_info_check_interval
  - client_tcp_keepidle
  - rpc_period_task_interval
  - block_thread_num
  - connect_observer_max_retries
  - prometheus_sync_interval
  - proxy_local_cmd
  - skip_proxyro_check
  - enable_trace
  - client_tcp_keepcnt
  - session_pool_thread_schedule_interval
  - rpc_enable_sub_req_log
  - server_protocol
  - session_pool_reset_interval
  - enable_proxy_scramble
  - monitor_log_level
  - enable_causal_order_read
  - monitor_stat_dump_interval
  - log_cleanup_interval
  - enable_ob_protocol_v2
  - enable_cross_shard_txn
  - delay_exit_time
  - qos_stat_item_limit
  - rpc_enable_parallel_handler
  - rpc_service_mode
  - rpc_enable_async_pull_batch_tablets
  - slow_transaction_time_threshold
  - rpc_async_pull_batch_max_times
  - rpc_async_pull_batch_wait_interval
  - internal_cmd_mem_limited
  - congestion_retry_interval
  - server_detect_refresh_interval
  - net_config_poll_timeout
  - enable_trace_stats
  - grpc_client_num
  - enable_client_connection_lru_disconnect
  - enable_full_link_trace
  - stat_dump_interval
  - max_syslog_file_count
  - rpc_request_timeout_delta
  - idc_list_refresh_interval
  - default_buffer_water_mark
  - obproxy_sys_password
  - rpc_server_net_max_pending_request
  - rpc_redis_default_user_name
  - min_congested_connect_timeout
  - mem_leak_check_class_name
  - server_tcp_keepcnt
  - enable_cluster_checkout
  - obproxy_config_server_url
  - enable_sync_all_stats
  - rpc_request_retry_waiting_time
  - flow_consumer_reenable_threshold
  - enable_client_ip_checkout
  - max_log_file_size
  - rpc_max_response_batch_size
  - syslog_level
  - work_thread_num
  - enable_cached_server
  - sequence_fail_retry_count
  - enable_binlog_service
  - connection_diagnosis_option
  - sock_packet_mark_out
  - enable_report_session_stats
  - protocol_diagnosis_level
  - username_separator
  - rpc_sub_req_max_retries
  - hot_upgrade_rollback_timeout
  - server_detect_mode
  - slow_proxy_process_time_threshold
  - sock_send_buffer_size_out
  - flow_high_water_mark
  - rpc_force_srv_black_list
  - flow_low_water_mark
  - session_pool_stat_log_interval
  - log_file_percentage
  - enable_strict_stat_time
  - current_local_config_version
  - client_sock_option_flag_out
  - xflush_log_level
  - server_routing_mode
  - enable_performance_mode
  - qa_mode_mock_public_cloud_slb_addr
  - rpc_server_net_invalid_time_us
  - metadb_server_state_refresh_interval
  - enable_strict_kernel_release
  - prometheus_listen_port
  - enable_prometheus
  - stack_size
  - enable_qos
  - enable_qa_mode
  - prometheus_cost_ms_unit
- Multi-level parameters
  - obproxy_force_parallel_query_dop
  - proxy_primary_zone_name
  - read_stale_retry_interval
  - proxy_route_policy
  - init_sql
  - proxy_tenant_name
  - proxy_idc_name
  - enable_rpc_throttle
  - binlog_service_ip
  - enable_server_ssl
  - compression_algorithm
  - obproxy_read_only
  - route_target_replica_type
  - observer_query_timeout_delta
  - enable_check_cluster_name
  - rpc_throttle_limit_qps_qa
  - target_db_server
  - slow_query_time_threshold
  - mysql_version
  - rpc_throttle_trigger_percentage
  - ob_max_read_stale_time
  - ssl_attributes
  - enable_read_write_split
  - enable_client_ssl
  - enable_transaction_split
  - weakread_weight_zone
  - obproxy_read_consistency
  - sql_firewall_config
  - rootservice_cluster_name
  - route_diagnosis_level
  - enable_standby_read_write_split
  - query_digest_time_threshold
  - enable_cloud_full_username
  - enable_weak_reroute
  - observer_sys_password
  - rpc_request_throttle_waiting_time
  - observer_sys_password1
Connection management
- Principles
- Network connection
- Client session
- Session status synchronization
- Server session
- Session connection pool
- Configure a globally unique client session ID
Data routing
- Factors affecting data routing
- Partitioning key types supported for routing by ODP
- Character set-based routing
- ODP routing
- Follower latency threshold
- Automatic routing to the primary/standby tenants
- Read/Write separation
- Function partition key routing
  - String functions
  - FAQ
  - Date calculation functions
  - Numeric calculation functions
  - Overview
- Intra-tenant routing
  - IP address-based routing
  - Partitioned table-based routing for strong-consistency reads
  - Strategy-based routing
  - Distributed transaction routing
  - Equality derivation for partition calculation
  - Primary zone-based routing for strong-consistency reads
  - Forcible routing
  - Weight-based load-balanced routing
  - Overview
  - Rerouting
  - Global index table-based routing for strong-consistency reads
  - Replicated table-based routing for strong-consistency reads
Logs
- obproxy_stat.log
- obproxy_error.log
- Overview
- obproxy.log
- obproxy_diagnosis.log
- obproxy_digest.log
- obproxy_slow.log
Commands
- Overview
- Compatible MySQL commands
  - SHOW RELAYLOG EVENTS
  - SHOW PROCESSLIST
  - SHOW SLAVE HOSTS
  - KILL
  - BINLOG
- Dedicated ODP commands
  - ALTER
  - ping
  - KILL
    - KILL PROXYSESSION
    - KILL GLOBALSESSION
  - SHOW
    - SHOW
    - SHOW PROXYPS
    - SHOW GLOBALSESSION
High availability mechanism
- High availability testing
- High availability of ODP services
- Overview
- High availability of OceanBase Database
OBKV
- OBKV-Redis
- Throttling
- RPC service port
Security and protocols
Operation and maintenance
- Troubleshooting logic
- Performance analysis
- Show Trace
- Routing diagnostics
  - Overview
  - Examples
  - Obtain diagnostic information
  - Diagnostic point troubleshooting
    - PARTITION_ID_CALC_DONE
    - ROUTE_INFO
    - EXPR_PARSE
    - Overview
    - CONGESTION_CONTROL
    - RESOLVE_TOKEN
    - RESOLVE_EXPR
    - CALC_PARTITION_ID
    - RETRY
    - PARTITION_ENTRY_LOOKUP_DONE
    - ROUTE_POLICY
    - HANDLE_RESPONSE
    - SQL_PARSE
    - FETCH_TABLE_RELATED_DATA
    - LOCATION_CACHE_LOOKUP
    - ROUTINE_ENTRY_LOOKUP_DONE
    - CALC_ROWID
    - TABLE_ENTRY_LOOKUP_DONE
- Memory leak diagnostics
- Connection diagnostics
- Prometheus monitoring
- SQL firewall
Release Notes
- Version number rules
- Enterprise Edition
  - V3.2
    - ODP Enterprise Edition V3.2.11
    - ODP Enterprise Edition V3.2.3.5
  - V4.2
    - ODP Enterprise Edition V4.2.3
    - ODP Enterprise Edition V4.2.2
    - ODP Enterprise Edition V4.2.1
  - V4.3
    - ODP Enterprise Edition V4.3.3
    - ODP Enterprise Edition V4.3.2
    - OceanBase Database Enterprise Edition V4.3.4
    - OceanBase Database Proxy Enterprise Edition V4.3.6
    - ODP Enterprise Edition V4.3.0
    - ODP Enterprise Edition V4.3.1
    - OceanBase Database Proxy Enterprise Edition V4.3.5
  - V4.0
    - ODP Enterprise Edition V4.0.0
  - V4.1
    - ODP Enterprise Edition V4.1.0
- Community Edition
  - V4.3
    - OceanBase Database Proxy Community Edition V4.3.5
    - ODP Community Edition V4.3.1
    - ODP Community Edition V4.3.2
    - ODP Community Edition V4.3.3
    - OceanBase Database Proxy Community Edition V4.3.4
    - OceanBase Database Proxy Community Edition V4.3.6
  - V4.2
    - ODP Community Edition V4.2.0
    - ODP Community Edition V4.2.3
    - ODP Community Edition V4.2.1
  - V4.1
    - ODP Community Edition V4.1.0
  - V4.0
    - ODP Community Edition V4.0.0

Download PDF

Document Feedback

automatic_match_work_thread

Last Updated：2026-04-13 03:40:45 Updated

automatic_match_work_thread specifies whether to automatically create worker threads based on the number of CPU cores.

Attribute	Description
Parameter type	Boolean
Default value	True
Value range	`True`: specifies to automatically create worker threads. `False`: specifies not to automatically create worker threads.
Effective only after ODP restart	Yes

Note

If the value is set to True, the maximum number of worker threads in the environment is the value of work_thread_num. For more information about work_thread_num, see work_thread_num.

Previous topic

Parameter summary

Last

Next topic

block_thread_num