OceanBase logo

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

Resources

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

Company

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

About OceanBase

Partner

Trust Center

Contact Us

International - English
中国站 - 简体中文
日本 - 日本語
Sign In
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 CloudOceanBase Database
ToolsConnectors and Middleware
QUICK START
OceanBase CloudOceanBase 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

Contact Us

Start on Cloud
编组
All Products
    • Databases
    • iconOceanBase Database
    • iconOceanBase Cloud
    • iconOceanBase Tugraph
    • iconInteractive Tutorials
    • iconOceanBase Best Practices
    • Tools
    • iconOceanBase Cloud Platform
    • iconOceanBase Migration Service
    • iconOceanBase Developer Center
    • iconOceanBase Migration Assessment
    • iconOceanBase Admin Tool
    • iconOceanBase Loader and Dumper
    • iconOceanBase Deployer
    • iconKubernetes operator for OceanBase
    • iconOceanBase Diagnostic Tool
    • iconOceanBase Binlog Service
    • Connectors and Middleware
    • iconOceanBase Database Proxy
    • iconEmbedded SQL in C for OceanBase
    • iconOceanBase Call Interface
    • iconOceanBase Connector/C
    • iconOceanBase Connector/J
    • iconOceanBase Connector/ODBC
    • iconOceanBase Connector/NET
icon

OceanBase Cloud Platform

V4.3.5

  • Document Overview
  • Product Introduction
    • What is OceanBase Cloud Platform?
    • Differences between Enterprise Edition and Community Edition
    • System architecture
    • Features
    • Limits
      • Dependencies
      • System requirements
  • Deploy OceanBase Cloud Platform (OCP)
    • Deploy OceanBase Cloud Platform (OCP) Community Edition
      • Installation process
      • Prepare for the installation
      • Overview
      • Post-deployment check
      • Use Docker to deploy OCP
      • Deploy OCP on the GUI
      • Installation planning
        • Host planning
        • Port planning
        • User planning
        • Disk and directory planning
      • Appendix
        • Install Docker
        • Restart OCP
        • FAQ about deployment
        • Uninstall OCP
    • Deploy OceanBase Cloud Platform (OCP) Enterprise Edition
      • Deploy OCP
        • Check after deployment
        • Deploy OCP
          • Deploying a high availability of OCP
            • Create MetaDB
            • Initialize system parameters
            • Register an OCP cluster
            • Prepare installation media
            • Install OCP
          • Deploying a single point of OCP
            • Initialize system parameters
            • Install OCP
            • Prepare installation media
            • Create MetaDB
        • Plan resources
          • Planning resources of a high availability OCP
            • MonitorDB resources
            • Host resources
            • MetaDB resources
            • OCP-Server specifications
          • Planning resources of a single node OCP
            • MonitorDB resources
            • OCP-Server specifications
            • Host resources
            • MetaDB resources
      • Deployment FAQ
        • Ubuntu deployment FAQ
        • Client requirements
        • Start and stop OCP
        • Optimize MonitorDB parameters
        • EulerOS deployment FAQ
        • F5 Big-IP LTM and alert configuration
          • Monitor the OCP service health
          • Connect OBProxy to F5 Big-IP LTM
          • Connect OCP-Console to F5 Big-IP LTM
      • Prepare the deployment environment
        • Add a server
        • Check the environment
        • Install OAT
      • Appendix
        • Uninstall OCP
        • Check the NTP offset
      • Deployment overview
        • Deploy OCP cluster in the High-availability
        • Deploy OCP cluster in the Single-node
  • Upgrade OceanBase Cloud Platform (OCP)
    • Upgrade OceanBase Cloud Platform (OCP) Enterprise Edition
      • Overview
      • Considerations
      • Preparations
      • Appendix
        • Version mapping
        • Change a user's password
      • Verify after upgrade
        • Verify the task feature
        • Verify the software package feature
        • Verify the password box feature
        • Verify the host feature
        • Verify the cluster feature
        • Verify the OBProxy feature
        • Verify the tenant feature
        • Verify the alert feature
        • Verify the backup and restore feature
      • Upgrade OCP
        • Take over OCP
        • Upgrade OCP
    • Upgrade OceanBase Cloud Platform (OCP) Community Edition
      • Post-upgrade check
      • Upgrade OCP on the GUI
      • Upgrade OCP using Docker containers
  • Quick Start
    • Log on to the OCP console
    • Create a user
    • OCP operations
    • Create an OBProxy cluster
    • Create a tenant
    • Create a cluster
    • Add a host
    • Upload a software package
  • Cluster Management
    • Upgrade an OceanBase cluster
    • View the topology of a cluster
    • Overview of cluster tenant management
    • Overview
    • Manage cluster parameter templates
    • Manage clusters
      • Disable automatic detection of deadlocks
      • Change the password
      • Restart a cluster
      • Delete a cluster
      • Take over a cluster
      • Stop a cluster
      • Move out a cluster
      • Enable automatic detection of deadlocks
      • Create a standby cluster
      • Upgrade a standalone centralized database to a distributed cluster
      • Manage CPU binding configurations
      • View the details of a cluster
      • Manage Arbitration Service of a cluster
        • Add an arbitration service group
        • Remove an arbitration service
        • Add an arbitration service
        • Replace the arbitration service for a cluster
      • Manage O&M configuration
        • Manage parameters
        • Configure resources for OCP Agent
        • Overview
        • View the parameter modification history
    • Manage Service Groups
      • Edit an arbitration service group
      • Create an arbitration service group
      • Delete an arbitration service group
      • Overview
      • Upgrade an arbitration service group
    • Manage OBServers of a cluster
      • Stop the observer process
      • Restart a faulty OBServer node
      • Delete an OBServer
      • Replace an OBServer node
      • Reinstall an OBServer
      • Add an OBServer node
      • Stop an OBServer service
    • Manage zones of a cluster
      • Add a zone
      • Edit a zone
      • Restart a zone
      • Stop a zone
      • Delete a zone
    • Manage Arbitration Services
      • Stop an arbitration service
      • Delete an arbitration service
      • Upgrade an arbitration service
      • Dissociate an arbitration service
      • Restart an arbitration service
      • Arbitration service Overview
      • Migrate an arbitration service
      • Associate a cluster
      • Take over an arbitration service
      • Create an arbitration service
      • Start an arbitration service
      • Replace an arbitration service
    • Manage cluster resource
      • View resource usage
      • View the unit distribution
    • Manage cluster parameters
      • Parameter types
      • View parameters
      • View the history of parameter changes
      • Modify parameters
    • Manage major compaction of a cluster
      • Perform a major compaction
      • View details of a major compaction
      • Modify the major compaction settings of a cluster
      • View the major compaction records
      • View statistics of a major compaction
    • Create a cluster
      • Create a distributed cluster
      • Create a standalone centralized database
  • Tenant Management
    • Tenant and resource management
    • Create a primary tenant
    • Manage tenant parameter templates
    • View OCP resource unit specifications
    • Manage unit specifications
    • Manage databases
    • Manage the resources of a tenant
    • View tenant overview information
    • Manage tenants
      • Copy a tenant
      • Manage the binlog service for a tenant
      • Rename a tenant
      • Lock a tenant
      • Modify zone priorities
      • Change the password of the sys tenant
      • Manage service names
      • Modify the allowlist of a tenant
      • Configure full link tracking for a tenant
      • View the details of a tenant
      • Create a standby tenant
      • Delete a tenant
      • Clone a tenant
    • Manage major compaction under a tenant
      • Perform a major compaction
      • Modify major compaction settings of a tenant
      • View details of tenant major compaction
      • View the major compaction records
    • Manage resource isolation
      • Overview
      • Create a resource isolation plan
      • Delete a resource isolation plan
      • Delete a resource group
      • Modify a resource group
      • Modify a resource isolation plan
      • Enable or disable a resource isolation plan
      • Create a resource group
    • Manage users and permissions under a tenant
      • System privileges in a MySQL tenant
      • Manage users in a MySQL tenant
      • Manage user under an Oracle tenant
        • Create a role under an Oracle tenant
        • Create a user under an Oracle tenant
        • Delete a user under an Oracle tenant
        • User overview under an Oracle tenant
        • Manage roles
        • Manage users
        • Change the password of a user under an Oracle tenant
    • Manage statistical information
      • Collect statistics
      • Manage statistics collection tasks
      • Overview
    • Manage tenant parameters
      • View the parameters
      • Modify a parameter
      • View the parameter modification history
    • Manage replicas of a tenant
      • Edit a tenant replica in a zone
      • Add a replica
      • Delete a tenant replica from a zone
    • Manage topulogy of a tenant
      • View the topology of a tenant
      • View the topology of the primary/standby relationships of a tenant
  • OBProxy Management
    • Parameter management
    • Create an OBProxy cluster
    • View details on the OBProxy page
    • Request analysis
    • OBProxy parameters descpription
    • Client configuration
    • Manage OBProxy parameter templates
    • OBProxy management overview
    • Manage OBProxy Clusters
      • Manage load balancing
      • Upgrade an OBProxy cluster
      • Move out an OBProxy cluster
      • Add a connectable OceanBase cluster
      • Delete a connected OceanBase cluster
      • Manage the proxyro account
      • Change the password of the proxyro user
      • Stop or start an ODP cluster
      • Delete an OBProxy cluster
      • Manage CPU core binding configurations
      • Restart an ODP cluster
      • Change the password of the proxysys user
      • View details on the Overview page of an OBProxy cluster
    • Manage OBProxy Servers
      • Stop or start an OBProxy
      • Take over an OBProxy
      • Refresh OBProxy configurations
      • Upgrade an OBProxy
      • Delete an OBProxy
      • Remove an OBProxy
      • Launch an OBProxy
      • Add an OBProxy
      • Restart an OBProxy
  • Binlog Service Management
    • Binlog service overview
    • Create a binlog cluster
    • Manage binlog cluster parameters
    • Manage binlog parameter templates
    • Manage Binlog Clusters
      • Start and stop a binlog cluster
      • View information about a binlog cluster
      • Upgrade a binlog cluster
      • Restart a binlog cluster
      • Delete a binlog cluster
      • Manage Binlog Server
        • Delete a binlog server
        • Start and stop a binlog server
        • Add a binlog node
        • Clear binlog instances on a host
      • Manage Binlog Instance
        • View a binlog instance
        • Manage binlog instance parameters
        • Restart a binlog instance
        • Start and stop a binlog instance
        • Configure throttling
  • Host Management
    • OCP-Agent processes
    • View details of a host
    • Perform host standardization checks
    • Host standardization check items
    • Reinstall OCP Agent
    • View the details of tasks on a host
    • Add a host
    • Modify a host
    • Host management operations
    • Restart OCP-Agent
    • OCP-Agent O&M Script Instructions
    • Remove a host
  • Alert Management
    • Overview
    • Alert-related concepts
    • Optional monitoring metrics for custom alerts
    • OCP alert template tag
    • View alert events
    • Manage alert push
      • Delete an alert push
      • Edit an alert push
      • View an alert push
      • Create an alert push
    • Manage blocking conditions
      • Edit an alert blocking condition
      • Create a blocking condition
      • Delete an alert blocking condition
    • Manage alert rules
      • Create an alert rule
      • Copy an alert rule
      • View an alert rule
      • Edit an alert rule
      • Export alert rule configurations
      • Alert rule groups
      • Delete an alert rule
    • Manage alert templates
      • Delete an alert template
      • Edit an alert template
      • Create an alert template
      • View an alert template
      • Copy an alert template
      • Set alert objects
      • Export alert templates
    • Manage alert channels
      • Create an alert channel
      • View an alert channel
      • Edit an alert channel
      • Copy an alert channel
      • Delete an alert channel
      • Examples of alert channel configuration
      • Examples of alert channel configuration
  • Dashboard Management
    • Manage dashboards
    • Monitoring dashboard overview
    • Manage groups
    • Manage charts
  • Performance Monitoring
    • Use the custom monitoring feature
      • View collection items
      • Overview
      • OCP metrics
      • Manage indicator items
        • Create a metric
        • Manage metrics
      • Manage charts
        • Create a chart
        • Manage charts
    • Manage monitoring
      • Overview
      • View database performance monitoring data
      • View host performance monitoring data
      • View OBServer node performance monitoring data
      • View performance and SQL monitoring data
      • View transaction performance monitoring data
      • View storage and cache monitoring data
      • View database object monitoring data
      • View OBKV-Table monitoring data
      • View OBKV-HBase monitoring data
      • View OBKV-Redis monitoring data
      • View subscription connection monitoring charts
      • View performance monitoring data of a binlog instance
      • View resource monitoring data of a binlog instance
      • View host resource monitoring data
      • View host process monitoring data
      • View service monitoring data
      • View system monitoring data
      • View performance monitoring
      • Drill-down monitoring
      • Integrate monitoring data to an external time-series system
  • Diagnostics and Tuning
    • SQL Diagnostics
      • SQL Diagnostics Introduction
        • SQL statement execution statistics
        • SQL execution plans
        • SQL diagnostics overview
      • View the OceanBase Autonomy Service page
      • Diagnose suspicious SQL statements
      • Diagnose top SQL statements
      • View Comparison of Top SQL Statements
      • Diagnose slow SQL statements
      • Diagnose parallel SQL statements
      • Diagnose high-risk SQL statements
      • Diagnose new SQL statements
      • View the details of an SQL statement
      • View outlines
      • View the SQL collection enabling/disabling history
      • View SQL request analysis data
      • Parameters related to SQL performance diagnostics
    • Transaction Diagnostics
      • Diagnose transactions
      • Transaction overview
      • Diagnose XA transactions and suspended transactions
    • Manage sessions
      • Manage the sessions of a tenant
      • View session statistics
      • View row lock analytics
      • View the deadlock history
    • View the Optimization Center page
    • View the capacity center
    • View diagnostics reports
      • Manage performance reports
      • Manage ASH reports
  • O&M Management
    • Manage Inspection
      • Inspection
      • Configure inspection items
      • Configure Scheduling Rules
        • Configure a global scheduling rule
        • Configure a scheduling rule for a single object
      • Initiate Inspection
        • Initiate a global inspection
        • Initiate an inspection for a single object
      • View an inspection task
      • Manage Inspection reports
        • View an inspection report
        • Download an inspection report
    • Manage Plans
      • Manage plans
      • Overview
      • View plan execution details
    • Manage Information Collection
      • Download an information collection report
      • Configure information collection items
      • View information collection details
      • Overview
      • Create an information collection task
  • Backup and Recovery
    • Copy a restore task
    • Overview
    • Backup and restore guide
    • Initiate a restore task
    • Overview
    • View restore task information
    • Manage backup tasks
      • View second backup tasks
      • View backup tasks
    • Manage backup and recovery service
      • Copy a service
      • View O\&M tasks
      • Add a node
      • Upgrade the version of a service
      • Delete a service
      • View services
      • Install a service
      • Restart a service on a node
      • Update service configurations
      • Uninstall a service on a node
      • Stop a service on a node
    • Regular backup
      • Manage cluster-level backup strategy
        • View a cluster-level backup stategy
        • Create a cluster-level backup strategy
        • Modify a cluster-level backup strategy
        • Delete a cluster-level backup strategy
        • Pause backup scheduling
      • Manage tenant-level backup strategy
        • Pause backup scheduling
        • Create a tenant-level backup strategy
        • View a tenant-level backup stategy
        • Delete a tenant-level backup strategy
        • Modify a tenant-level backup strategy
    • Regular recovery
      • View sampling strategies
      • View sampling tasks
      • Create a sampling strategy for recovery
    • Backup now
      • Back up a tenant now
      • Back up a cluster now
  • Disaster Recovery
    • Switching primary and standby databases
      • Start the original primary cluster in read-only mode after a failover
      • Decouple a standby cluster from the primary cluster
      • Primary/Standby cluster switchover for disaster recovery
      • Routine primary/standby cluster switchover
    • Switching primary and standby tenants
      • Decouple a standby tenant from its primary tenant
      • Failover
      • Create a standby tenant for a primary tenant managed by another OCP cluster
      • Switchover
    • OCP Manage OCP clusters in the multi-cluster mode
      • Register an OCP cluster
      • Switch an OCP cluster in a failover
      • OCP multi-cluster mode overview
      • Unbind a leader and a follower OCP cluster
      • Manage OCP cluster parameters
      • Switch an OCP cluster in daily maintenance
      • Enable the OCP multi-cluster mode
      • Delete a faulty follower OCP cluster
      • View Leader \& Follower Details
  • Log Management
    • Download logs
    • Configure log retention strategies
    • Trace query
    • Query logs
    • Configure trace query parameters
    • About OpenSearch
  • Software Package Management
    • Delete a software package
    • Download a software package
    • Upload a software package
  • System Management
    • Manage password box
      • Verify a credential
      • Edit a credential
      • Batch operations on credentials
      • Create a credential
      • Import a credential
      • Export a credential
      • Delete a credential
    • Manage users and permissions
      • Overview
      • Manage a organization
        • View the resources of an organization
        • Delete an organization
        • Create an organization
        • Share resource configurations
        • Rename an organization
      • Manage a user
        • Copy a user
        • View a user
        • Delete a user
        • Change the password of a user
        • Edit a user
        • View the login history
        • Create a user
      • Manage a role
        • View a role
        • Edit a role
        • Default OCP roles
        • Copy a role
        • Delete a role
        • Create a role
    • Manage tags
      • Overview
      • Delete a tag
      • Edit a tag
      • Create a tag
      • Modify objects bound to a tag
    • View operation records
    • Manage external integration
      • Overview
      • Create an SSO integration task
      • Enable/Disable an SSO integration task
      • Edit an SSO integration task
      • Delete an SSO integration task
    • Manage system parameters
      • OCP configuration parameters
      • Modify system parameters
      • View system parameters
    • Manage tasks
    • User center management
      • Log off the OCP console
      • Configure personal information
      • Change your logon password
  • SQL Tuning Practices
    • General SQL Performance Tuning Scenarios
      • Execution Plan Optimization
        • SQL statement performance deterioration caused by plan changes
      • Index Optimization
        • Inappropriate index of an SQL statement
        • No suitable indexes
        • Invalid index of an SQL statement
    • Customize Abnormal SQL Statement Determining Rules
      • Conditions
      • Custom column rules
    • Locate General Abnormal SQL Statements
      • How can I locate SQL statements for full-table scans in a tenant?
      • How can I locate SQL statements with high CPU load in a tenant?
      • How can I locate slow hard-parsed SQL statements in a tenant?
      • How can I locate erroneous SQL statements in a tenant?
      • How can I locate distributed SQL statements in a tenant?
      • How can I locate slow SQL statements that take a long time in a tenant?
      • How can I locate remote SQL statements in a tenant?
  • O&M Best practices
    • Send alert messages through email
    • Move out an OBProxy cluster
    • Check the availability of an auto-increment column
    • Decouple a standby tenant from the primary tenant
    • Perform a failover
    • Check clog synchronization
    • Send alert messages to a Feishu group
    • Integrate OCP monitoring into Prometheus
    • Troubleshoot host issues in an OceanBase cluster
    • Push alert messages through HTTP
    • Back up an OceanBase cluster
    • Automatic routing to the new primary tenant after a switchover
    • Scale in an OBProxy cluster
    • Perform an inspection in OCP to detect potential risks in an OceanBase cluster
    • Take over OBProxies
    • Scale in an OceanBase cluster and scale down an OceanBase Database tenant
    • Use the arbitration service of OceanBase Database to achieve HA in a scenario with two IDCs
    • Configure custom monitoring
    • Migrate a cluster between IDCs in OCP
    • Scale out an OBProxy cluster
    • Restore lost data by using backup and restore
    • Migrate a resource unit from an OceanBase Database tenant
    • Import a monitoring dashboard to Grafana
    • Send alert messages to a WeChat Enterprise group
    • Monitor the business load of OceanBase Database
    • Upgrade an OceanBase cluster
    • Expand the high availability of OceanBase clusters and tenants
    • Perform a failover between primary and standby OceanBase clusters for disaster recovery in a scenario with two IDCs
    • Replace an OBProxy
    • Reduce the high availability of OceanBase clusters and tenants
    • Scale out an OceanBase cluster and scale up an OceanBase Database tenant
    • Check the NIC rate
    • Migrate an OceanBase cluster to another IDC
    • Perform a switchover between primary and standby OceanBase Database tenants in a scenario with two IDCs
    • Delete an OBProxy
    • Send alert messages to a DingTalk group
  • Reference Guide
    • Alarm reference
      • Overview
      • Application alerts
        • ob_host_monitordb_disconnected
        • base_backup_too_long_time_no_one_success_task
        • backup_process_dead
        • odp_sql_query_slow
        • ob_cluster_inspection_not_passed
        • upgrade_ocp_agent_failed
        • monitor_exporter_unavailable
        • ob_host_tcp_retrans_percent_over_threshold
        • odp_instance_compress_failed
        • backup_storage_capacity_timeout_or_interrupted
        • ob_host_invalid_disk_exists
        • ocp_remote_server_time_diff_too_large
        • host_agent_open_fd_count_over_threshold
        • ic_server_connect_failed Inter-Connector
        • Host log alerts
        • host_agent_goroutine_count_over_threshold
        • obagent_dead
        • host_ntp_service_not_exist
        • host_ntp_offset_too_large
        • backup_storage_capacity_over_threshold
        • base_backup_timeout
        • partition_create_failed
        • host_disk_readonly
        • odp_sql_execute_failed
        • ocp_collect_metric_failure_rate_high
        • host_agent_res_memory_over_threshold
        • ob_host_net_recv_percent_over_threshold
        • vpc_connect_failed
        • ocp_http_request_timeout
        • ob_host_ssd_wear_indicator_over_threshold
        • mgragent_process_stop
        • host_agent_version_not_same
        • agentd_process_stop
        • base_backup_fail
        • ocp_alarm_detect_timeout
        • ob_host_net_send_percent_over_threshold
        • ob_host_cpu_percent_over_threshold
        • monagent_process_stop
        • ocp_meta_db_disconnected
        • ocp_contingency_failed
        • system_obproxy_unavailable
        • node_load1_peak
        • base_secondary_backup_fail
        • ob_host_mem_percent_over_threshold
        • backup_storage_capacity_retry_times_exceeded
        • odp_instance_expanse_failed
        • inc_backup_delay
        • ocp_http_request_too_many_errors_occur
        • ob_cluster_recyclebin_disk_used_over_threshold
        • host_unavailable
      • OceanBase alerts
        • ob_cannot_connected
        • ob_cluster_rs_not_same
        • ob_cluster_status_check_failed
        • ob_cluster_merge_timeout
        • ob_cluster_operation_info
        • ob_cpu_assigned_percent_over_threshold
        • ob_cpu_percent_over_threshold
        • ob_tenant_expired_trans_exist
        • ob_host_load1_per_cpu_over_threshold
        • ob_host_partition_count_over_threshold
        • obproxy_process_dead
        • ob_tenant_large_trans_exist
        • obproxy_host_operation
        • refresh_location_cache_failed
        • ob_tenant_log_stream_degraded
        • standby_tenant_sync_delay_too_long
        • obproxy_client_connections_usage_over_threshold
        • ob_tenant_request_queue_over_threshold
        • oas_anomaly_sql_from_anomaly_event_analysis_cpu_percent_high
        • refresh_location_cache_failed_by_metric
        • obproxy_core_dump
        • ob_cluster_status_check_failed
        • ob_cluster_merge_error
        • ob_cluster_no_merge
        • ob_cluster_sync_failed
        • ob_host_disk_readonly
        • ob_server_sstable_percent_over_threshold
        • ob_tenant_operation_info
        • ob_host_install_disk_percent_over_threshold
        • ob_tenant_exists_expired_xa_trans
        • ob_tenant_active_session_count_over_threshold
        • ob_tenant_log_disk_usage_high
        • ob_tenant_no_compaction
        • ob_tenant_no_frozen
        • ob_host_operation
        • standby_tenant_sync_status_error
        • oas_anomaly_sql_from_anomaly_event_analysis_plan_changed
        • os_observer_not_exist
        • ob_tenant_cpu_usage_over_threshold
        • ob_tenant_partition_replica_absent
        • ob_tenant500_storage_short_meta_mem_hold_high
        • agent_process_count_abnormal
        • obproxy_process_stop
        • ob_cluster_sync_delay_time_too_long
        • oas_anomaly_sql_from_anomaly_event_analysis_perf_degradation
        • ob_host_data_disk_percent_over_threshold
        • obproxyd_process_dead
        • ob_mem_assigned_percent_over_threshold
        • observer_process_stop
        • ob_tenant_expired_trans_exist
        • ob_tenant_long_trans_exist
        • tenant_memstore_percent_over_threshold
        • obproxy_cannot_connected
        • host_operation
        • oas_anomaly_sql_from_sql_inspection_perf_degradation
        • ob_cluster_no_frozen
        • ob_tenant_partition_leader_absent
        • tenant_active_memstore_percent_over_threshold
        • ob_server_cannot_connect_arbitration
        • OceanBase log alerts
        • ob_tenant_compaction_error
        • ob_host_task_timeout
        • ob_host_active_session_count_over_threshold
        • ob_cluster_active_session_count_over_threshold
        • ob_host_log_disk_percent_over_threshold
        • ob_host_connection_percent_over_threshold
        • oas_anomaly_sql_from_sql_inspection_plan_changed
        • ob_tenant500_mem_hold_percent_over_threshold
        • obproxy_cluster_operation
        • arbitration_service_unavailable
        • ob_tenant_long_trans_exist
        • arbitration_auto_replace_operation_info
        • obproxyd_process_stop
        • ob_cluster_exists_index_fail_table
        • same_alarm_rule_detect_too_many_targets
        • tenant_cpu_percent_over_threshold
        • ob_cluster_exists_inactive_server
        • ob_tenant_task_timeout
        • ob_tenant_slow_sql_exists
        • ob_tenant500_mem_hold_over_threshold
        • arbitration_group_auto_replace_failed
      • OAS alerts
        • node_memory_peak
        • os_nic_1000m_full
        • os_tsar_cpu_util_hwm
        • os_observer_fd_usage
        • os_tsar_traffic_error
        • os_tsar_cpu_util_full
        • os_kernel_ntp_delay
        • node_file_datalog1_usage
        • os_home_file_usage
        • os_tsar_nvme_ioawait
        • os_tsar_cpu_sys_abnormal
        • os_tsar_traffic_overload
        • os_tsar_traffic_drop
        • os_tsar_sda_ioawait
        • os_kernel_io_hang
        • sql_audit_collect_lost_percent_over_threshold
        • node_file_inode_usage
        • node_file_root_usage
        • node_file_data1_usage
        • os_kernel_ntp_down
        • os_nic_1000m_hwm
        • os_cpu_irq_error
        • os_observer_core_dump
      • Appendix
        • Network troubleshooting
        • Execute the alert clearance plan
        • Exception handling for OceanBase cluster compaction
        • Apply throttling to an OceanBase cluster
    • Metric reference
      • Overview of metrics
      • Monitoring metrics list
      • OBProxy cluster
        • Memory for the obproxy process
        • Client connections
        • Number of threads in the obproxy process
        • RPC request time consumption
        • RPC sessions
        • Number of file descriptors for the obproxy process
        • TPS
        • Server connections
        • RPC requests
        • Net bytes
        • QPS
        • OBProxy CPU usage
        • Log error
        • Route table queries
        • Average response time for each SQL statement
      • OceanBase Database tenant
        • Performance and SQL
          • Wait events
          • Rpc package rt
          • MemStore usage
          • Request queue size
          • SQL execution plan category
          • Tenant thread usage
          • Request waiting queue
          • Clog synchronization delay
          • QPS
          • Cursors
          • Frontend workload metrics
          • Tenant CPU cost
          • Metrics related to time consumption of wait events
          • DB time metrics
          • Background workload metrics
          • Response time (SQL mode)
          • RPC packet throughput
          • Sessions
          • Metrics for the SQL execution phase
          • memroy usage pecent
          • Request waiting queue time consuming
          • SQL execution plan time
          • PX worker thread usage
        • Storage and Cache
          • MemStore
          • IOPS
          • IO time-consuming
          • I/O Throughput
          • Cache size
          • Cache hit rates
          • Number of cache requests
          • Frozen MemStores
          • # Log disk
          • # Data disk
        • OBKV_Table
          • Response time (OBKV-Table)
          • Average number of statement lines processed (OBKV-Table)
          • QPS (OBKV-Table)
        • Transaction
          • Transaction table read request hits
          • Number of XA transactions
          • Number of transaction logs
          • Partitions
          • Lock waits
          • Transaction response time
          • Average execution duration of XA statements
          • TPS
          • Time consumed by transaction logs
          • TPS
          • Transaction log volume
          • Transaction response time details
          • Time consumed by lock waits
          • Number of XA statements
        • OBKV_HBase
          • QPS (OBKV_Hbase)
          • Average number of statement lines processed (OBKV-HBase)
          • Response time (OBKV-HBase)
        • OBKV_Redis
          • Response time (OBKV-Redis)
          • QPS (OBKV-Redis)
        • Database objects
          • Objects
      • Host
        • Host Performance
          • I/O usage
          • TCP retransmission rate
          • Packet forwarding
          • I/O queue length
          • Linux system load
          • I/O throughput
          • CPU Utilization
          • Inode usage
          • Time consumed by I/O operations
          • Network throughput
          • NTP clock offset
          • IOPS
        • Host Resources
          • Memory
          • Disk
          • Memory usage
        • Host Processes
          • Number of process file descriptors
          • Process resident memory
          • Number of process threads
          • Number of OCP-Agent process goroutines
          • Process CPU utilization
      • OceanBase cluster
        • Database performance
          • Query response time
          • I/O Throughput
          • Request queue time
          • Number of sessions
          • IOPS
          • Transaction response time
          • Number of transaction logs
          • QPS
          • Time consumed by transaction logs
          • TPS
          • TPS
          • Transaction log volume
          • IO time-consuming
        • OBServer performance
          • Error logs
          • Number of process threads
          • Process memory
          • Process file descriptors
          • Process CPU utilization
          • sys500 memory occupation
      • Binlog Service
        • Subscription Connection Monitoring
          • Associate RPS
          • Network Traffic
          • Sending Delay
        • Binlog Resource Monitoring
          • CPU
          • memory used
          • memory
          • disk used
          • Binlog Disk Write Rate
          • disk ratio
          • FD count
          • network bytes
        • Binlog Performance Monitoring
          • Binlog Delay
          • Binlog RPS
    • API Reference
      • Overview
      • API call description
      • Rules for generating a signature by using AK/SK
      • Task return structure
      • Software packages
        • Query software packages
        • Delete a software package
        • Upload a software package
      • Cluster management
        • Migrate an arbitration service
        • Query arbitration service parameters
        • Perform a failover
        • Upgrade an arbitration service group
        • Start a zone in an OceanBase cluster
        • Delete multiple OBServers at a time
        • Perform a precheck on batch arbitration service replacement
        • Stop an OceanBase cluster
        • Perform a takeover precheck on an OceanBase cluster
        • Create a zone for an OceanBase cluster
        • Start an OceanBase cluster
        • Start an arbitration service
        • Delete a zone from an OceanBase cluster
        • Query the list of arbitration services
        • Change the password of an OceanBase cluster
        • Take over an arbitration service
        • Delete an arbitration service group
        • Restart a zone in an OceanBase cluster
        • Query resource statistics of all OBServer nodes in an OceanBase cluster
        • Query the parameter metadata of OceanBase clusters
        • Take over an OceanBase cluster
        • Add an OBServer node
        • Delete an OceanBase cluster
        • Perform a switchover pre-check
        • Delete an arbitration service
        • Query resource statistics of an OceanBase cluster
        • Stop an OBServer node
        • Associate an arbitration service with multiple OceanBase clusters
        • Create an arbitration service group
        • Upgrade an OceanBase cluster
        • Bind/Unbind tags to/from an arbitration service
        • Query information of an arbitration service group
        • Stop an arbitration service
        • Query details of an arbitration service
        • Query units of an OceanBase cluster
        • Perform a switchover
        • Replace the arbitration service for multiple clusters
        • Create an arbitration service
        • Restart an arbitration service
        • Restart an OceanBase cluster
        • Restart an OBServer node
        • Query zones of an OceanBase cluster
        • Start an OBServer node
        • Create an OceanBase cluster
        • Query parameters of an OceanBase cluster
        • Perform an arbitration service takeover precheck
        • Query OBServer nodes in a zone
        • Move out an OceanBase cluster
        • Perform an association precheck on multiple OceanBase clusters
        • Dissociate an arbitration service from multiple clusters
        • Upgrade an arbitration service
        • Stop a zone in an OceanBase cluster
        • Replace an OBServer node
        • Modify parameters of an OceanBase cluster
        • Query OBServer nodes of an OceanBase cluster
        • Query OceanBase clusters
        • Query the list of arbitration service groups
        • Update an arbitration service group
        • Perform a failover pre-check
      • Database management
        • Grant roles to a user
        • Grant database privileges to a user
        • Grant object privileges to a user
        • Query database objects
        • Revoke global privileges of a role
        • Query the list of database roles
        • Change object privileges of a role
        • Grant global privileges to a role
        • Change global privileges of a role
        • Grant global privileges to a user
        • Query database user details
        • Change database privileges of a user
        • Delete a database user
        • Query databases
        • Revoke database privileges of a user
        • Grant roles to a role
        • Change roles of a role
        • Create a database user
        • Create a database role
        • Lock a database user
        • Change object privileges of a user
        • Query database role details
        • Delete a database role
        • Revoke roles of a user
        • Query the list of database users
        • Delete a database
        • Revoke object privileges of a user
        • Revoke roles of a role
        • Change global privileges of a user
        • Unlock a database user
        • Change the password of a database user
        • Modify a database
        • Grant object privileges to a role
        • Create a database
        • Change roles of a user
        • Revoke global privileges of a user
        • Revoke object privileges of a role
      • System management
        • Operation Audit
          • Query event history
        • Health examination
          • Query the basic information of an OCP application
          • Query OCP server time
          • Query OCP application status
        • Agent management
          • Stop the OCP Agent process on a host
          • Stop the OCP Agent process on a host
          • Restart the OCP Agent process on a host
          • Query OCP Agent details on a host
          • Batch stop the OCP Agent processes on hosts
          • Batch restart the OCP Agent processes on hosts
          • Restart the OCP Agent process on a host
          • Query OCP Agent processes on a host
      • SQL performance
        • Query the performance indicator trend of an SQL statement
        • Query performance indicators of an SQL statement
        • Query a performance report
        • Query the operator structure of an execution plan
        • Query the list of slow SQL statements
        • Query SQL text
        • Generate a performance report
        • Query snapshots
        • Query the performance indicator trend of an execution plan
        • Query performance indicators of an execution plan
      • O&M tasks management
        • Query details about a task
        • Query tasks
        • Retry a task
        • Cancel a subtask
        • Roll back a task
        • Retry a subtask
        • Query subtask logs
        • Skip a subtask
      • Backup and recovery
        • View the log backup tasks of a tenant
        • View the data backup tasks of a tenant
        • Delete the backup strategy of a cluster
        • Parse the backup information of a tenant
        • Initiate tenant recovery
        • View restore tasks
        • Query the backup strategy of a tenant
        • Start backup scheduling for a cluster
        • Clear added restore resources
        • Query recovery tasks of a cluster
        • Stop backup scheduling for a tenant
        • Query the backup overview of a cluster
        • Modify the backup strategy of a cluster
        • Query backup capabilities of a cluster
        • Query the backup strategy of a cluster
        • Create a backup strategy for a tenant
        • Parse cluster backup data
        • Initiate a data backup for a tenant
        • Modify the backup strategy of a tenant
        • Query data backup tasks of a cluster
        • Start backup scheduling for a tenant
        • Add restore resources
        • Create a backup strategy for a cluster
        • Immediately back up a cluster
        • Preview a restore task
        • Delete the backup strategy of a tenant
        • Stop backup scheduling for a cluster
        • Query log backup tasks of a cluster
      • OBProxy management
        • Update configurations of an OBProxy cluster
        • Restart an OBProxy
        • Upgrade an OBProxy
        • Remove a connectable OceanBase cluster from an OBProxy cluster
        • Create an OBProxy cluster
        • Query the description information of the OBProxy parameters
        • Delete an OBProxy (not recommended)
        • Start an OBProxy
        • Query details about an OBProxy cluster
        • Add an OBProxy
        • Take over an OBProxy
        • Stop an OBProxy
        • Add a connectable OceanBase cluster for an OBProxy cluster
        • Query parameters of an OBProxy cluster
        • Upgrade an OBProxy
        • Delete an OBProxy cluster
        • Query OBProxy clusters
        • Delete an OBProxy
        • Restart an OBProxy
      • Tenant management
        • Create a tenant
        • Modify a replica of a tenant
        • Modify parameters of a tenant
        • Query tenants of a cluster
        • Create a standby tenant
        • Obtain a list of unit specifications
        • Delete a unit from a tenant
        • Perform a batch failover
        • Add a replica for a tenant
        • Create a resource unit specification
        • Perform a batch switchover
        • Unlock a tenant
        • Perform a switchover
        • Perform a failover precheck
        • Query all tenants
        • Query parameters of a tenant
        • Delete a replica of a tenant
        • Change the administrator password of a tenant
        • Delete a resource unit specification
        • Perform a batch switchover precheck
        • Query details about a tenant
        • Modify the allowlist of a tenant
        • Perform a switchover precheck
        • Lock a tenant
        • Perform a batch failover precheck
        • Modify zone priorities of a tenant
        • Query units of a tenant
        • Delete a tenant
        • Perform a failover
      • Inspection
        • Query inspection objects
        • Query the last inspection result of an inspection item
        • Initiate an inspection
        • Query the last inspection result of an inspection object
        • Query all inspection tasks
        • View the details of an inspection report
      • Host management
        • Query host types
        • Add host type information
        • Add IDC information
        • Query details about an IDC
        • Delete multiple hosts at a time
        • Query regions
        • Delete an IDC
        • Delete a region
        • Add multiple hosts at a time
        • Delete a host
        • Query details about a host type
        • Add region information
        • Query hosts
        • Query IDCs
        • Query details about a host
        • Query details about a region
        • Delete a host type
      • Alerts
        • Call an alert API
        • Alert events
          • Query alert events
          • Query the alert event list
        • Alert notifications
          • Query alert notifications
      • Monitoring
        • Query monitoring data by tag
        • Query monitoring data
        • Query the description of a monitoring metric
    • Information Collection Reference
      • Data Disk Full
        • Collect information about the disk space occupied by temporary files of a tenant
        • Collect incremental data generated during cluster compactions
        • Collect information about sizes of data of different versions in major SSTables
        • Collect information about the macroblock utilization of nodes
        • Collect the data disk usage information of nodes in a cluster
      • CPU Exceptions
        • Collect information about threads with high CPU utilization in an observer process
        • Collect information about processes with high CPU utilization on a cluster node
      • Major Compaction Exceptions
        • Collect the last-one-day records of major compaction events scheduled by RootService
        • Collect major compaction parameter settings
        • Collect diagnostic information about major compactions
        • Collect the checksum information about tablets
        • Collect information about the major compaction status of zones of a cluster
        • Collect the major compaction time
        • Collect RootService task records
        • Collect the checksum information about columns
        • Collect information about the ongoing major compaction in a cluster
        • Collect suggestions provided based on historical major compactions
        • Collect information about DAG warnings in OceanBase Database
      • Cluster Exceptions
        • Collect connectivity information of the sys tenant
        • Collect information about the core dump file of the observer process
        • Collect host logs containing the CRASH ERROR keyword
        • Collect obstack information on a cluster node
        • Collect information about bad disks
        • Collect information about OBServer nodes in a cluster
      • OCP Agent Exceptions
        • Collect panic logs of the mgragent process
        • Collect information about goroutines of the agent processes
        • Collect panic logs of the monagent process
      • Memory Exceptions
        • Collect memory allocation sampling data of OBServer nodes
        • Collect KV cache information of a tenant
        • Collect memory leakage detection information
        • Collect MemStore information of a tenant
        • Collect information about modules with highest memory usage
      • Other Tenants Exceptions
        • Collect host logs containing the dump tenant info keyword
        • Collect host logs containing the dump tenant info keyword
        • Collect host logs containing the dump tenant disk usage keyword
      • Host Exceptions
        • Collect host information by running the df -h command
        • Collect logs from the /var/log/messages directory of a host
    • Error codes reference
      • OCP error codes
      • OBServer error codes
        • Oracle mode
          • OBE-00000 to OBE-00999
          • OBE-20000 to OBE-29999
          • Overview
          • OBE-10000 to OBE-19999
          • OBE-30000 to OBE-49999
          • OBE-02000 to OBE-04999
          • PLS-00000 to PLS-00999
          • OBE-50000 to OBE-99999
          • OBE-01500 to OBE-01999
          • OBE-05000 to OBE-10000
          • OBE-01000 to OBE-01499
        • MySQL mode
          • 10000 to 12000
          • 4000 to 4499
          • 4500 to 4999
          • 6000 to 6999
          • 7000 to 7999
          • 9000 to 9499
          • 5000 to 5999
          • 9500 to 9999
          • 8000 to 8999
          • 22998, 30926, 38104, and 38105
          • Overview
          • 0001 to 3999
  • FAQ
    • FAQ on the OCP system
    • FAQ about deployment
    • FAQ on alerts
    • OCP multi-cluster FAQ
    • FAQ on upgrade
    • FAQ on monitoring
      • FAQ on monitoring metrics
      • FAQ on SQL monitoring
      • FAQ about resource usage
      • Use OCP-Agent to pull time-series monitoring data
    • FAQ on O&M
      • FAQ on backup and recovery
      • FAQ on the OCP software package
      • FAQ on OceanBase cluster
      • FAQ on OBProxy
      • FAQ on OceanBase tenants
      • FAQ on accounts and passwords
      • FAQ on host management
  • Appendix
    • AWS S3 protocol
    • Install and configure OCI
    • Component listening port list
    • Processes
    • OCP background tasks
    • Modify the log stream downgrade control time
    • Tables managed by the daemon
  • Release Notes
    • V4.3
      • OCP V4.3.4
      • OCP V4.3.1
      • OCP V4.3.0
      • OCP V4.3.5
      • OCP V4.3.3
      • OCP V4.3.2

Download PDF

Document Overview What is OceanBase Cloud Platform? Differences between Enterprise Edition and Community Edition System architecture Features Dependencies System requirements Installation process Prepare for the installation Overview Post-deployment check Use Docker to deploy OCP Deploy OCP on the GUI Overview Considerations Preparations Post-upgrade check Upgrade OCP on the GUI Upgrade OCP using Docker containers Log on to the OCP console Create a user OCP operations Create an OBProxy cluster Create a tenant Create a cluster Add a host Upload a software package Upgrade an OceanBase cluster View the topology of a clusterOverview of cluster tenant management Overview Manage cluster parameter templates Disable automatic detection of deadlocks Change the password Restart a cluster Delete a cluster Take over a cluster Stop a cluster Move out a cluster Enable automatic detection of deadlocks Create a standby cluster Upgrade a standalone centralized database to a distributed cluster Manage CPU binding configurations View the details of a cluster Edit an arbitration service group Create an arbitration service group Delete an arbitration service group Overview Upgrade an arbitration service group Stop the observer process Restart a faulty OBServer nodeDelete an OBServer Replace an OBServer node Reinstall an OBServer Add an OBServer node Stop an OBServer service Add a zone Edit a zone Restart a zone Stop a zone Delete a zone Stop an arbitration service Delete an arbitration service Upgrade an arbitration service Dissociate an arbitration service Restart an arbitration service Arbitration service Overview Migrate an arbitration service Associate a cluster Take over an arbitration service Create an arbitration service Start an arbitration service Replace an arbitration service View resource usage View the unit distribution Parameter types View parameters View the history of parameter changes Modify parameters Perform a major compaction View details of a major compaction Modify the major compaction settings of a cluster View the major compaction records View statistics of a major compaction Create a distributed cluster Create a standalone centralized database Tenant and resource management Create a primary tenant Manage tenant parameter templatesView OCP resource unit specifications Manage unit specifications Manage databases Manage the resources of a tenant View tenant overview information Copy a tenant Manage the binlog service for a tenant Rename a tenantLock a tenant Modify zone priorities Change the password of the sys tenant
OceanBase logo

The Unified Distributed Database for the AI Era.

Follow Us
Products
OceanBase CloudOceanBase EnterpriseOceanBase Community EditionOceanBase seekdb
Resources
DocsBlogWhite PaperLive DemosTraining & CertificationTicket
Company
About OceanBaseTrust CenterLegalPartnerContact Us
Follow Us

© OceanBase 2026. All rights reserved

Cloud Service AgreementPrivacy PolicySecurity
Contact Us
Document Feedback
  1. Documentation Center
  2. OceanBase Cloud Platform
  3. V4.3.5
iconOceanBase Cloud Platform
V 4.3.5
Databases
  • OceanBase Database
  • OceanBase Cloud
  • OceanBase Tugraph
  • Interactive Tutorials
  • OceanBase Best Practices
Tools
  • OceanBase Cloud Platform
  • OceanBase Migration Service
  • OceanBase Developer Center
  • OceanBase Migration Assessment
  • OceanBase Admin Tool
  • OceanBase Loader and Dumper
  • OceanBase Deployer
  • Kubernetes operator for OceanBase
  • OceanBase Diagnostic Tool
  • OceanBase Binlog Service
Connectors and Middleware
  • OceanBase Database Proxy
  • Embedded SQL in C for OceanBase
  • OceanBase Call Interface
  • OceanBase Connector/C
  • OceanBase Connector/J
  • OceanBase Connector/ODBC
  • OceanBase Connector/NET
  • V 4.4.2
  • V 4.3.6
  • V 4.3.5
  • V 4.3.4
  • V 4.3.3
  • V 4.3.2
  • V 4.3.1
  • V 4.3.0
  • V 4.2.2
  • V 4.0.0 and earlier

OCP configuration parameters

Last Updated:2026-04-16 03:36:04  Updated
Share
What is on this page
Global configuration
Security and login
Monitoring
Performance diagnostics
Alerting
Backup and Restore
Log analysis
Inspection
OceanBase connection management
Host
OCP Agent
File management
Flow control
System logs

folded

Share

This topic lists all system parameters of OceanBase Cloud Platform (OCP) for reference by OCP administrators. After a parameter is modified, the modification takes effect in about 10 minutes by default. Some parameters only take effect after OCP Server restarts. The need for restart is indicated in the description column of the tables.

Global configuration

Parameter
Default value
Description
ocp.site.url http://localhost:8080 The URL for accessing the OCP console. The URL must start with http or https. It must contain the virtual IP (VIP) address, domain name, and port number, and not end with a forward slash (/).
ocp.config-url.site.url - The URL for accessing the OCP config url service. The default value is empty, indicating that the URL specified for the ocp.site.url parameter is used. If the config url service is deployed separately, you must set a value different from that of ocp.site.url.
ocp.config-url.use-request-address TRUE The URL for the requests used by responses in the config url service. The default value is TRUE. If it is set to FALSE, responses will use the URL specified for the ocp.config-url.site.url parameter.
ocp.system.default.timezone - The default time zone of OCP. If this parameter is not specified, the default time zone of the system is used. A restart is required for a modification to take effect.
ocp.system.default.language zh-CN The system default language, which is not the frontend display language. The default value of zh-CN is used if this parameter is not specified. A restart is required for a modification to take effect.
ocp.web.tracking.enabled false Specifies whether to enable the telemetry feature of OCP. By default, the telemetry feature is disabled in the Enterprise Edition and enabled in the Community Edition. The telemetry feature collects usage information of users in some scenarios and shares desensitized usage information with OceanBase Database to improve the product experience. For example, the information helps you understand how users use OceanBase Database, enabling improvements in user experience.
You can run the update config_properties set value = 'false' where `key` = 'ocp.web.tracking.enabled'; command in MetaDB of OCP to disable this feature.

Security and login

Parameter
Default value
Description
server.servlet.session.timeout 30m The timeout value for session logins and sessions. Default value: 30m. Minimum value: 60s. If no unit is specified, the default unit of second is used.
ocp.iam.auth local The web page login option. Valid values: local (for OCP accounts in the local MetaDB) and buc (for Alibaba Group employee accounts). Default value: local. A restart is required for a modification to take effect.
ocp.iam.csrf.enabled TRUE Specifies whether to enable protection against cross-site request forgery (CSRF). We recommend that you enable this feature for web-based logins. Default value: TRUE. A restart is required for a modification to take effect.
ocp.iam.login.max-attempts 5 The maximum number of consecutive unsuccessful login attempts allowed. When this threshold is exceeded, the client IP address is temporarily blocked. Default value: 5.
ocp.iam.login.lockout-minutes 30 The amount of time a client IP address is blocked after the maximum number of unsuccessful login attempts is exceeded. Default value: 30. Unit: minutes.
ocp.iam.login.client.max-attempts 10 The maximum number of consecutive login attempts allowed for a client. When this threshold is exceeded, the client IP address is temporarily blocked. Default value: 10.
ocp.iam.login.client.lockout-minutes 10 The amount of time a client IP address is blocked after the maximum number of login attempts is exceeded. Default value: 10. Unit: minutes.

Monitoring

Parameter
Default value
Description
ocp.monitor.collect.obcluster.enabled true Specifies whether to collect the monitoring data of OceanBase clusters. If this parameter is set to true, the monitoring data of all OceanBase clusters is collected.
ocp.monitor.collect.obproxy.enabled true Specifies whether to collect the monitoring data of OBProxies. If this parameter is set to true, the monitoring data of all OBProxy clusters is collected.
ocp.monitor.collect.host.enabled true Specifies whether to collect the monitoring data of hosts. If this parameter is set to true, the monitoring data of all hosts is collected.
ocp.monitor.data.retention-days {"ob_cluster_system_event":31,"ocp_metric_data_1":8,"ocp_metric_data_60":31,"metric_hour_data":1098,"metric_daily_data":1098} The number of days for which the monitoring data is retained. The key is the name of the table where the data is stored, and the value is the number of days for data retention. A restart is required for modifications to take effect.

Performance diagnostics

The following table describes the parameters for SQL performance diagnostics.

Parameter
Default value
Description
ocp.perf.sql-diag.awful-performance-index-used-config {"enabled":true, "cpuTimeLimitUs":100000, "execPsLimit":5.0, "fullLogicalReadsLimit":10000} The diagnostic parameter for poor performance despite the use of an index. * enabled: specifies whether to enable this check item.* execPsLimit: the number of executions per second. * cpuTimeLimitUs: the average CPU time (μs). * fullLogicalReadsLimit: the number of logical reads. Diagnostic objects: SQL queries that meet the following conditions during the diagnostic period: Average CPU time > cpuTimeLimitUs && Actual logical reads > fullLogicalReadsLimit && Full table scan is not performed && Execution frequency > $execPsLimit.
ocp.perf.sql-diag.cpu-time-proportion-high-config {"enabled":true, "cpuTimeLimitUs":10000, "execPsLimit":10.0, "maxCpuTimeLimitUs":30000, "affectedRowsLimit":100, "execLimit":30, "sqlCountLimit":20, "cpuTimePercentLimit":20} The diagnostic parameter for a high CPU time percentage for execution. * enabled: specifies whether to enable this check item. * execPsLimit: the execution frequency, which is the number of executions per second. * cpuTimeLimitUs: the average CPU time (μs). * maxCpuTimeLimitUs: the maximum CPU time. * affectedRowsLimit: the number of rows affected. * execLimit: the number of executions. * sqlCountLimit: the number of SQL queries. * cpuTimePercentLimit: the percentage of CPU time. Diagnostic objects: SQL queries that meet the following conditions during the diagnostic period: Average CPU time > $cpuTimeLimitUs || Number of rows affected > $affectedRowsLimit || Maximum CPU time > $maxCpuTimeLimitUs && Execution frequency >= $execPsLimit.
Diagnostic criteria: During the diagnostic period, if all the following conditions are met, the CPU time percentage is considered high: (1) The percentage of the CPU time of the diagnosed SQL query to the CPU time of the tenant exceeds $cpuTimePercentLimit. (2) The total number of SQL executions by the tenant exceeds $execLimit. (3) The number of unique SQL queries executed by the tenant exceeds $sqlCountLimit.
ocp.perf.sql-diag.database-white-list oceanbase,information_schema,mysql,__recyclebin,sys,__public The names of the databases to be skipped in SQL diagnostics.
ocp.perf.sql-diag.execution-spike-config {"enabled":true, "cpuTimeLimitUs":3000, "execPsLimit":5.0, "pointsLimit":5, "compareMin":20, "avgExecutionMultiply":{"0":6, "1":5, "5":4, "10":3, "50": 2.5, "100": 2, "500": 1.6}, "stdExecutionMultiply":{"0":80, "1":60 , "3": 30,"5":20, "10":15, "20":8, "30":6, "50":5, "80":4}} The diagnostic parameter for execution spikes. * enabled: specifies whether to enable this check item. * execPsLimit: the execution frequency, which is the number of executions per second. * cpuTimeLimitUs: the average CPU time (μs). * pointsLimit: the number of points. * compareMin: the time of comparison (min). * avgExecutionMultiply: the multiple of the average execution frequency. * stdExecutionMultiply: the multiple of the standard deviation of the execution frequency. Diagnostic objects: SQL queries that meet the following conditions during the diagnostic period: Average CPU time >= $cpuTimeLimitUs && Average number of executions per second >= $execPsLimit. Diagnostic criteria: 1. Find the SQL queries that meet the diagnostic conditions within the first $compareMin after the diagnostics start. Calculate the average execution frequency per minute (avg_exec_ps) of the SQL queries in the first $compareMin, the standard deviation of the execution frequency (std_exec_ps) in the first $compareMin, and the ratio of the standard deviation to the average (range_percent). In other words, the following statistics are calculated:
  • Historical average execution frequency (avg_exec_ps)
  • Standard deviation (std_exec_ps)
  • range_percent (std_exec_ps / avg_exec_ps * 100)
2. Then, calculate the average number of executions per second (exec_ps) of the SQL query. If the exec_ps parameter meets all the following conditions at the same time, the SQL query is considered an execution spike:
  • exec_ps >= avg_exec_ps * $multiple_value_1
  • exec_ps >= avg_exec_ps + std_exec_ps * $multiple_value_2

Note
  • The value of the multiple_value_1 parameter varies with that of the avg_exec_ps parameter, depending on the value of the avgExecutionMultiply parameter. When avg_exec_ps > 500, multiple_value_1 = 1.6. Likewise, 100 -> 2, 50 -> 2.5, 10 -> 3, 5 -> 4, and 1 -> 5. * The value of the multiple_value_2 parameter varies with that of the range_percent parameter, depending on the value of the stdExecutionMultiply parameter. When range_percent > 80, multiple_value_ 2 = 4. Likewise, 50 -> 5, 30 -> 6, 20 -> 8, 10 -> 15, 5 -> 20, 3 -> 30, 1 -> 60, and 0 -> 80.
ocp.perf.sql-diag.index-diagnoser-config {"enabled":true,"schedulePeriodMin":5, "coreThreadSize":10, "maxThreadSize":50,"maxQueueSize":10000,"diagPeriodSec":300,"diagOffsetSec":60,"maxDiagPeriodSec":1800} The parameter for SQL index diagnostics. It takes effect after a restart. We recommend that you leave this parameter unchanged.
ocp.perf.sql-diag.ineffective-hint-config {"enabled":true, "execPsLimit":5.0, "cpuTimeLimitUs":20000} The diagnostic parameter for inactive hints. * enabled: specifies whether to enable this check item. * execPsLimit: the execution frequency, which is the number of executions per second. * cpuTimeLimitUs: the average CPU time (μs). Diagnostic objects: SQL queries that meet the following conditions during the diagnostic period: Average CPU time >= $cpuTimeLimitUs && Execution frequency >= $execPsLimit.
Diagnostic criteria: If the index specified in a hint is inconsistent with that of the execution plan, the hint is inactive.
ocp.perf.sql-diag.perf-diagnoser-config {"enabled":true,"schedulePeriodMin":5, "coreThreadSize":10, "maxThreadSize":50,"maxQueueSize":10000,"diagPeriodSec":300,"diagOffsetSec":60,"maxDiagPeriodSec":1800} The parameter for SQL performance diagnostics. It takes effect after a restart. We recommend that you leave this parameter unchanged.
ocp.perf.sql-diag.performance-degradation-after-plan-changed-config {"enabled":true, "compareMin":5, "cpuTimeMultiply":{"0":50, "1":30, "10":10, "100":8, "1000":6}} The diagnostic parameter for changes in the execution plan and performance degradation. * enabled: specifies whether to enable this check item. * cpuTimeMultiply: the multiple of CPU time. If the current average CPU time is greater than 0 ms, the performance is considered degraded only when the CPU time is increased by at least 50 times after the execution plan is changed. If the current average CPU time is greater than 1 ms, the performance is considered degraded when the CPU time is increased by at least 30 times, and so forth. * compareMin: the time of performance comparison (min). Diagnostic criteria: The performance is considered degraded if the average CPU time of the SQL query within $compareMin is increased by more times than the specified multiple of CPU time after the execution plan is changed.
ocp.perf.sql-diag.performance-degradation-config {"enabled":true, "cpuTimeLimitUs":10000, "execPsLimit":5.0, "maxCpuTimeLimitUs":30000, "affectedRowsLimit":100, "execLimit":5, "compareMin":20, "cpuTimeMultiply":{"0":50, "1":30, "10":10, "100":8, "1000":6}} The diagnostic parameter for performance degradation. * enabled: specifies whether to enable this check item. * execPsLimit: the execution frequency, which is the number of executions per second. * cpuTimeLimitUs: the average CPU time (μs). * maxCpuTimeLimitUs: the maximum CPU time. * affectedRowsLimit: the number of rows affected. * execLimit: the number of executions. * compareMin: the source time (min) of the baseline data. It is the first $compareMin after the diagnostics start. * cpuTimeMultiply: the multiple of CPU time. If the current CPU time is greater than 0 ms, the performance is considered degraded only when the CPU time is increased by at least 50 times after the execution plan is changed. If the current average CPU time is greater than 1 ms, the performance is considered degraded when the CPU time is increased by at least 30 times, and so forth. Diagnostic objects: SQL queries that meet the following conditions during the diagnostic period: Average CPU time > $cpuTimeLimitUs || Number of affected rows > $affectedRowsLimit || Maximum CPU time > $maxCpuTimeLimitUs && Execution frequency > $execPsLimit. Diagnostic criteria: A baseline number of executions is taken as the reference for comparison. The baseline number of executions must be greater than $execLimit. Otherwise, it cannot be used as the reference for comparison. After the reference for comparison is determined, the performance is considered degraded when the SQL query under diagnostics meets all the following conditions at the same time: * Current average CPU time >= Baseline CPU time * $cpuTimeMultiply. The default value of cpuTimeMultiply is 6. * Current execution frequency >= Baseline execution frequency * 0.5.
ocp.perf.sql-diag.query-timeout 30000000 The timeout threshold of SQL diagnostic queries (μs).
ocp.perf.sql-diag.row-lock-contention-high-config {"enabled":true, "execPsLimit":0, "cpuTimeLimitUs":1000, "elapsedTimeLimitUs":0} The diagnostic parameter for high row lock contention. * enabled: specifies whether to enable this check item. * execPsLimit: the execution frequency, which is the number of executions per second. * cpuTimeLimitUs: the average CPU time (μs). * elapsedTimeLimitUs: the average response time (μs). Diagnostic objects: SQL queries that meet the following conditions during the diagnostic period: Execution frequency > $execPsLimit && Average CPU time > $cpuTimeLimitUs && Average response time > $elapsedTimeLimitUs.
Note
The elapsedTimeLimitUs parameter is used only when it is configured. Diagnostic criteria: An SQL query is considered to have caused high row lock contention if its type is %select%for%update%.
ocp.perf.sql-diag.table-scan-index-not-exists-config {"enabled":true, "execPsLimit":1.0, "cpuTimeLimitUs":20000} The diagnostic parameter for the full-table scan without any indexes available. * enabled: specifies whether to enable this check item. * execPsLimit: the execution frequency, which is the number of executions per second. *cpuTimeLimitUs: the average CPU time (μs). Diagnostic objects: SQL queries that meet the following conditions during the diagnostic period: table_scan > 0 in the v$sql_audit view. These queries involve full table scans. Diagnostic criteria: No index is available if the following conditions are met:
  • A single table is scanned and it has no index.
  • Multiple tables are scanned, and some tables have no index.
ocp.perf.sql-diag.table-scan-index-not-used-config {"enabled":true, "execPsLimit":1.0, "cpuTimeLimitUs":2000} The diagnostic parameter for a full-table scan without using the index. * enabled: specifies whether to enable this check item. * execPsLimit: the execution frequency, which is the number of executions per second. * cpuTimeLimitUs: the average CPU time (μs). Diagnostic objects: SQL queries that meet the following conditions during the diagnostic period: Execution frequency > $execPsLimit && Average CPU time > $cpuTimeLimitUs && Full-table scan is performed.
Diagnostic criteria: The index is not used.
ocp.perf.sql.diag-plan-change-config {"enabled":true,"schedulePeriodMin":5, "coreThreadSize":10, "maxThreadSize":50,"maxQueueSize":10000,"diagPeriodSec":300,"diagOffsetSec":300,"maxDiagPeriodSec":1800} The parameter for scheduling of diagnostic tasks. We recommend that you leave this parameter unchanged.
ocp.perf.sql.max-query-range 24h The maximum length of time range for querying SQL performance data. Default value: 24h. If the time range of a query you specified on the TopSQL or SlowSQL tab exceeds the value of this parameter, an error is returned when you submit the query.
ocp.perf.sql.plan-hist-level0-granularity 30s The time interval for OCP to aggregate the performance data of the Level 0 SQL execution plans, or plans for short. By default, OCP collects and aggregates the performance data of plans once every 30s. The performance data is stored in specific tables for use in TopSQL diagnostics. You can increase this value to relieve the storage pressure for the MetaDB and MonitorDB of OCP.
ocp.perf.sql.plan-hist-level0-query-interval 2h The maximum time range for querying the Level 0 plan performance data. If the specified query time range exceeds this value, OCP queries data tables with larger aggregation time intervals.
ocp.perf.sql.plan-hist-level0-retention 5d The period for retaining performance data partitions of Level 0 plans. Performance data partitions are created by day. By default, the data is retained for only five days. Partitions that have been retained for more than five days are automatically deleted.
ocp.perf.sql.prepare-partition-ahead 8 The number of days for creating performance data partitions before the diagnostics. You need to specify the period in days.
ocp.perf.sql.query-timeout 30000000 The timeout threshold for SQL performance data queries (μs).
ocp.perf.sql.sql-hist-level0-granularity 30s The time interval for OCP to aggregate the performance data of the Level 0 SQL queries.
Note
To improve the performance of monitoring metric collection, OCP collects and aggregates SQL performance data at different time intervals for TopSQL diagnostics. The data is divided into three levels and is collected and stored in table partitions of the corresponding levels by day. The retention period for performance data partitions is specified by a fixed parameter. For the same type of performance data, a larger time interval requires less storage space.
ocp.perf.sql.sql-hist-level0-query-interval 2h The maximum time range for querying the Level 0 SQL performance data. If the time range you specified on the TopSQL tab exceeds this value, OCP queries the Level 1 SQL performance data tables.
ocp.perf.sql.sql-hist-level0-retention 2d The retention period for partitions of Level 0 SQL performance data. Partitions for Level 0 SQL performance data are created by day. By default, the MetaDB and MonitorDB of OCP only retain partitions created in the last two days.
ocp.perf.sql.sql-hist-level1-granularity 2m The time interval for OCP to aggregate the performance data of the Level 1 SQL queries. By default, OCP aggregates SQL performance data once every 2 minutes and writes the data into Level 2 SQL performance data tables.
ocp.perf.sql.sql-hist-level1-query-interval 12h The maximum time interval for querying the Level 1 SQL performance data. If the time range you specified on the TopSQL tab exceeds this value, OCP queries the Level 2 SQL performance data tables.
ocp.perf.sql.sql-hist-level1-retention 8d The retention period for partitions of Level 1 SQL performance data.
ocp.perf.sql.sql-hist-level2-granularity 10m The time interval for OCP to aggregate the performance data of the Level 2 SQL queries. By default, OCP aggregates SQL performance data once every 10 minutes and writes the data into Level 2 SQL performance data tables.
ocp.perf.sql.sql-hist-level2-query-interval 48h The maximum time interval for querying the Level 2 SQL performance data. Regardless of whether the time range you specified exceeds this value, OCP queries the Level 2 SQL performance data tables.
ocp.perf.sql.sql-hist-level2-retention 15d The retention period for partitions of Level 2 SQL performance data.
ocp.perf.ash.max-analyse-range 60m The maximum analysis range of the Active Sessions History (ASH) report of OceanBase Database.
ocp.perf.ash.earliest-analyse-time 8 The analysis start time recorded in the ASH report of OceanBase Database.

Alerting

Parameter
Default value
Description
ocp.alarm.send.enabled true Specifies whether to send alerts. This parameter is set to true by default.
ocp.alarm.datasource.slow-sql-exclude-obclusters sys#* Specifies the clusters in which the slow SQL statements of the data source are not alerted, such as *#cluster1,tenant2#cluster2.
ocp.alarm.datasource.trans-stat-exclude-obclusters Specifies the clusters in which the transactions of the data source are not alerted, such as *#cluster1,tenant2#cluster2.
ocp.alarm.detect.too-many-targets-alarm-threshold 20 Specifies the maximum number of alerted instances that hit the same alert rule. If the number exceeds the specified value, the alerts for those instances are merged into one.
ocp.alarm.notification.expired-days 90 Specifies the number of days that an alert message is archived. After the specified number of days, the archived message is stored in the history database and the corresponding alert event is deleted.
ocp.alarm.host.property svr_ip Specifies the information displayed for an alerted host. If you set the value to svr_ip, the IP address of the alerted host is displayed. If you set the value to host_name, the name of the alerted host is displayed.

Backup and Restore

Parameter
Default value
Description
ocp.backup.alarm.backup-data-retention-days 7 The number of days for which backup data is retained.
ocp.backup.alarm.backup-liboblog-expire-days 7 The number of days for which the backup liboblog is retained.
ocp.backup.storage.collect.task.timeout 10800000 The timeout value for each directory storage collection task during backup and restore.
ocp.backup.storage.collect.command.timeout 3600000 The timeout value for each data collection command during a storage collection task of backup and restore. This parameter is used when a storage collection task requires more than one data collection command.
ocp.backup.storage.collect.period.minutes 180 The time interval, in minutes, between data collection commands during a storage collection task of backup and restore.
ocp.backup.storage.collect.schedule.enabled true Specifies whether to enable periodical storage collection tasks during backup and restore. This parameter is set to true by default. To disable the feature, set this parameter to false.
ocp.backup.storage.collect.max.retry.times 2 The maximum number of retries for each storage collection task during backup and restore.
ocp.backup.storage.collect.host.task.concurrency 8 The maximum concurrency of storage collection tasks on each host during backup and restore.
ocp.backup.storage.collect.obtain-idle-host-interval-seconds 60 The time interval, in seconds, between retries to obtain an idle host during a storage collection task of backup and restore.
ocp.backup.storage.collect.obtain-idle-host-times 60 The maximum number of retries to obtain an idle host during a storage collection task of backup and restore.
ocp.backup.restore-time-pre-check.enabled true Specifies whether to check whether the restore time is within the period during which data can be restored before the restore is initiated. By default, this parameter is set to true.
ocp.backup.oss.support.cname true Specifies whether to support cname when OSS is accessed during backup and restore. By default, this parameter is set to true.
ocp.backup.backup-command.timeout 300 The timeout period of a backup command, in seconds.
ocp.backup.object-storage-sdk.invoke.https true Specifies whether to use the HTTPS or HTTP protocol for access when the Tencent Cloud Object Storage (COS) or Amazon Simple Storage Service (S3) SDK is called, if no protocol is specified for the access domain name. The value true indicates to use the HTTPS protocol. The value false indicates to use the HTTP protocol.

Log analysis

Parameter
Default value
Description
ocp.log.regex.observer %s/log/* The regular expression for the observer log.
ocp.log.regex.obproxy /home/admin/logs/obproxy/log/* The regular expression for the obproxy log.
ocp.log.regex.host /var/log/message* The regular expression for the host log.
ocp.analyze.enabled false Specifies whether to enable the data middle platform.
ocp.analyze.ob.trace.enabled false Specifies whether to enable trace data capture.
ocp.analyze.ob.log.enabled false Specifies whether to enable OceanBase log capture.
ocp.analyze.es.client.addresses The list of addresses of the client roles of the data middle platform Elastic Search (ES). The addresses are separated with a comma (,).
ocp.analyze.es.client.username Optional. The username for authentication of the connection to ES.
ocp.analyze.es.client.password Optional. The password for authentication of the connection to ES.
ocp.analyze.es.index.keep.days 7 The number of days that the ES indexes are retained.
ocp.analyze.es.index.shards 12 The number of shards of each ES index.
ocp.analyze.es.index.replicas 1 The number of replicas of each ES index.
ocp.ob.slowsql.threshold The time threshold, in microseconds, for OB-Agent to identify and collect a query of the OceanBase cluster as a slow query.

Inspection

Parameter
Default value
Description
ocp.inspection.scrips.sequence-availability.threshold-percentage 0.8 The threshold, in percentage, above which a sequence is identified as available during the inspection.
ocp.monitor.exporter.check-active-period-seconds 60 The time interval, in seconds, at which the status of active exporters is checked.
ocp.monitor.exporter.check-inactive-period-seconds 50 The time interval, in seconds, at which the status of inactive exporters is checked.

OceanBase connection management

Parameter
Default value
Description
obsdk.print.sql true Specifies whether to print SQL statements in OceanBase connection management. The default value is true.
obsdk.slow.query.threshold.millis 1000 The threshold for slow queries in OceanBase connection management. Default value: 1000. Unit: milliseconds.
obsdk.operation.global.timeout.millis 300000 The global timeout period for O&M commands in OceanBase connection management. Valid values: 10000 to 7200000. Default value: 300000. Unit: milliseconds.

Host

Parameter
Default value
Description
ocp.host.remote-command.default-timeout-millis 30000 The default timeout value for remote commands on the host. Unit: milliseconds.
ocp.host.ssh-ping.max-delay-millis 3000 The maximum time difference between the request and response for a whoami command sent by the OCP Server through SSH. When the actual delay exceeds this value, some operations such as adding a host may be affected. Unit: milliseconds.
ocp.host.check.clock-diff.enable false Specifies whether to check the difference between the time of OCP Server and that of the managed hosts.
ocp.host.check.clock-diff.max-diff 50 The maximum difference between the time of OCP Server and that of the managed hosts. When the actual time difference exceeds this value, host management and monitoring can be affected. Unit: milliseconds.
ocp.host.check.unavailable-time-threshold 60000 The maximum offline duration of OCP-Agent, in milliseconds. If the offline duration of OCP-Agent exceeds the specified value, an alert is sent, indicating that the host is unavailable.

OCP Agent

Parameter
Default value
Description
ocp.agent.home.path.prefix /home/admin The custom installation path of OCP Agent.
ocp.agent.manager.http.port 62888 The O&M port of OCP Agent.
ocp.agent.monitor.http.port 62889 The monitoring port of OCP Agent.
ocp.agent.auth.metric-auth-enabled true Specifies whether to enable authentication for the monitoring API of OCP Agent.
monagent.log.level info The log level of the ocp_monagent process. Default value: info.
mgragent.log.level info The log level of the ocp_mgragent process. Default value: info.

File management

Parameter
Default value
Description
ocp.file.local.dir #{systemProperties['user.home'].concat('/data/files')} The local storage path of files in the OCP file module.
ocp.file.file-server.bucket.type LOCAL The default type of the file server, such as LOCAL and OSS. Default value: LOCAL.

Flow control

Parameter
Default value
Description
ocp.iam.rate-limit.enabled true Specifies whether throttling is enabled at the global level. This parameter can be dynamically enabled and disabled.
ocp.iam.rate-limit.internal-api.connect.timeout 1000 The connection timeout value for calls made to the internal flow control APIs. Unit: milliseconds. A restart is required for a modification to take effect.
ocp.iam.rate-limit.internal-api.read.timeout 1000 The read timeout value for calls made to the internal flow control APIs. Unit: milliseconds. A restart is required for a modification to take effect.
ocp.iam.rate-limit.task.schedule.period 3 The scheduling cycle of primary and secondary role management tasks in throttling. Unit: seconds. A restart is required for a modification to take effect.
ocp.iam.rate-limit.on-user.enabled true Specifies whether throttling applies to users. This parameter can be dynamically enabled and disabled.
ocp.iam.rate-limit.on-ip.enabled false Specifies whether throttling applies to IP addresses. This parameter can be dynamically enabled and disabled.

System logs

Parameter
Default value
Description
logging.file.name ${user.home}/logs/ocp/ocp.log The full log file name, which contains the absolute path and the file name. System environment variables in Linux and macOS, such as ${HOME}, and Java system variables, such as ${user.home}, are supported. Default value: ${user.home}/logs/ocp/ocp.log.
logging.file.max-history 100 The maximum number of days to keep archived log files. This parameter is used after logging.file.name is configured.
logging.file.max-size 100MB The size of a log file, such as 30MB or 1GB. This parameter is used after logging.file.name is configured. Default value: 100MB.
logging.file.total-size-cap 10GB The total size of log files, such as 1GB. This parameter is used after logging.file.name is configured. Default value: 10GB.
logging.level.org.hibernate.SQL INFO The log level of SQL statements in the Spring framework. Default value: INFO.
logging.level.web INFO The log level of the Spring web framework. Default value: INFO.
logging.level.com.alipay.ocp INFO The log level of OCP. Default value: INFO.
logging.level.com.oceanbase.ocp INFO The log level of OCP. Default value: INFO.

Previous topic

Modify system parameters
Last

Next topic

Manage tasks
Next
What is on this page
Global configuration
Security and login
Monitoring
Performance diagnostics
Alerting
Backup and Restore
Log analysis
Inspection
OceanBase connection management
Host
OCP Agent
File management
Flow control
System logs