px_workers_per_cpu_quota - OceanBase 数据库 V4.5.0 | OceanBase 文档中心

文档反馈

分布式版-V4.5.0

What's New
简介
快速上手
应用开发
部署数据库
数据迁移
管理数据库
AP
AI
生态集成
实践教程
参考指南
- 系统原理
- 系统管理
- 数据库对象管理
- 数据库设计规范和约束
- SQL 参考
- PL 参考
- 系统视图
- 配置项和系统变量
  - 配置项和系统变量概述
  - V3.x 与 V4.x 配置项和系统变量变更
  - 配置项
    - 配置项总览
    - 集群级别配置项
      - alert_log_level
      - all_cluster_list
      - arbitration_degradation_policy
      - all_server_list
      - auto_broadcast_location_cache_rate_limit
      - auto_leader_switch_interval
      - auto_refresh_location_cache_rate_limit
      - autoinc_cache_refresh_interval
      - async_ps_cursor_max_count
      - backup_backup_dest
      - backup_backup_dest_option
      - 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_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_io_isolation_mode
      - clog_sync_time_warn_threshold
      - clog_transport_compress_func
      - cluster
      - cluster_id
      - config_additional_dir
      - cpu_count
      - cpu_reserved
      - data_copy_concurrency
      - data_dir
      - data_disk_usage_limit_percentage
      - data_disk_write_limit_percentage
      - data_storage_error_tolerance_time
      - data_storage_warning_tolerance_time
      - datafile_disk_percentage
      - datafile_maxsize
      - datafile_next
      - datafile_size
      - dead_socket_detection_timeout
      - debug_sync_timeout
      - default_compress
      - default_compress_func
      - default_row_format
      - default_transport_compress_func
      - devname
      - diag_syslog_per_error_limit
      - disk_io_thread_count
      - dtl_buffer_size
      - election_blacklist_interval
      - election_cpu_quota
      - enable_asan_for_memory_context
      - enable_async_syslog
      - enable_auto_leader_switch
      - enable_auto_refresh_location_cache
      - enable_cgroup
      - enable_dblink
      - enable_ddl
      - enable_election_group
      - enable_global_background_resource_isolation
      - enable_global_freeze_trigger
      - enable_log_archive
      - enable_logservice
      - enable_major_freeze
      - enable_manual_merge
      - enable_merge_by_turn
      - enable_ob_esi_process
      - enable_ob_ratelimit
      - enable_one_phase_commit
      - enable_perf_event
      - enable_pg
      - enable_record_trace_id
      - enable_record_trace_log
      - enable_rereplication
      - enable_rich_error_msg
      - enable_rootservice_standalone
      - enable_rpc_authentication_bypass
      - enable_separate_sys_clog
      - enable_smooth_leader_switch
      - enable_sql_audit
      - enable_sql_operator_dump
      - enable_sys_table_ddl
      - enable_sys_unit_standalone
      - enable_syslog_recycle
      - enable_syslog_wf
      - enable_tcp_keepalive
      - enable_upgrade_mode
      - external_table_disk_cache_max_percentage
      - fast_recovery_concurrency
      - flush_log_at_trx_commit
      - fuse_row_cache_priority
      - gc_wait_archive
      - get_leader_candidate_rpc_timeout
      - global_background_cpu_quota
      - 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_block_cache_priority
      - 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
      - local_ip
      - 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_disk_percentage
      - log_disk_size
      - logservice_access_point
      - log_storage_warning_trigger_percentage
      - log_storage_warning_tolerance_time
      - ls_meta_table_check_interval
      - 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_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_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_esi_io_concurrency
      - ob_esi_max_syslog_file_count
      - ob_esi_memory_limit
      - ob_esi_rpc_port
      - ob_esi_session_timeout
      - ob_esi_syslog_level
      - ob_event_history_recycle_interval
      - ob_ratelimit_stat_period
      - ob_startup_mode
      - ob_python_home
      - obconfig_url
      - observer_id
      - ob_storage_s3_url_encode_type
      - ob_enable_java_env
      - ob_enable_utl_tcp
      - ob_java_home
      - ob_java_connector_path
      - ob_java_opts
      - ob_enable_utl_http
      - ofs_list
      - opt_tab_stat_cache_priority
      - partition_table_check_interval
      - 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
      - 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_client_authentication_method
      - rpc_port
      - rpc_server_authentication_method
      - 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
      - sql_audit_memory_limit
      - sql_login_thread_count
      - sql_net_thread_count
      - sql_protocol_min_tls_version
      - ssl_client_authentication
      - ssl_external_kms_info
      - stack_size
      - standby_fetch_log_bandwidth_limit
      - storage_meta_cache_priority
      - strict_check_os_params
      - switchover_process_thread_count
      - sync_io_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_compress_func
      - syslog_disk_size
      - syslog_file_uncompressed_count
      - syslog_io_bandwidth_limit
      - syslog_level
      - system_cpu_quota
      - system_memory
      - system_trace_level
      - kv_transport_compress_func
      - tablet_ls_cache_priority
      - tablet_meta_table_check_interval
      - tablet_meta_table_scan_batch_count
      - 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
      - unit_gc_wait_time
      - 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
    - 租户级别配置项
  - 系统变量
- 错误码
- 性能调优
- 数据库代理
- 驱动
- 平台产品
- 组件 & 工具
- 数据库插件
常见问题
版本发布记录
术语

px_workers_per_cpu_quota

更新时间：2026-03-15 10:58:53

分享

说明

该配置项从 V2.2.50 版本开始引入。

功能描述

px_workers_per_cpu_quota 用于设置在每个 CPU 上可以分配的并行执行线程数。

权限要求

查询配置项

sys 租户和所有用户租户均可以使用 SHOW PARAMETERS 语句或视图 GV$OB_PARAMETERS 查询该配置项。
修改配置项

仅 sys 租户可以修改该配置项，用户租户不能修改该配置项。

属性说明

属性	描述
参数类型	Int
默认值	10
取值范围	[0, 20]
是否可修改	是，支持通过 `ALTER SYSTEM SET` 语句修改。
是否重启 OBServer 节点生效	否，设置后立即生效。

配置示例

设置在每个 CPU 上可以分配的并行执行线程数为 10。

obclient> ALTER SYSTEM SET px_workers_per_cpu_quota =10;

相关文档

设置并行执行参数

有帮助

无帮助