OceanBase 4.3.5 CE BP4 Release: New Features, Upgrade Guide, and Bug Fixes

by

Overview

OceanBase released version V4.3.5_CE_BP4 on 2025‑09‑16. The release focuses on feature enrichment for MySQL‑compatible mode, materialized‑view capabilities, vector indexing, and operational stability.

Upgrade Considerations

  • Supported upgrade path: any V4.3.x version → V4.3.5 BP4.
  • Unsupported: V4.2.x or earlier.
  • For clusters with many partitions, allocate extra time because the multi‑source data format was re‑engineered in V4.3.2.
  • Vector‑write workloads require index rebuild after upgrade.
  • When upgrading from V4.3.0/V4.3.1, stop transfer tasks one day in advance using ALTER SYSTEM SET enable_transfer = FALSE; and re‑enable after the upgrade.
  • Upgrade on x86 machines without AVX is supported.

Feature Enhancements

  • Session‑level private temporary tables are now available in MySQL‑compatible mode, allowing creation, modification, deletion, and indexing of temporary tables.
  • Materialized view improvements: incremental refresh can skip dimension tables via the new AS OF PROCTIME() syntax; MIN()/MAX() aggregates are supported; automatic MLOG management simplifies view maintenance.
  • Vector index upgrades: VSGA lock optimization, cosine and IP distance support for HNSW_BQ, weak‑read capability, and support for partitioned tables up to 1 billion vectors.
  • Prepare‑statement (PS) parameterization now has a tenant‑level switch enable_ps_parameterize to disable automatic constant‑to‑parameter conversion when needed.
  • Real‑time memory usage per SQL/PL is exposed in [G]V$OB_PROCESSLIST, enabling top‑N memory monitoring.
  • SQL AUDIT view gains client port and transaction status columns.
  • Full‑schema refresh after DDL is now server‑wide, reducing performance spikes in high‑concurrency environments.

Configuration and Syntax Changes

  • New tenant‑level configs: enable_mlog_auto_maintenance, mlog_trim_interval, ob_deterministic_udf_cache_max_size, approx_count_distinct_precision, enable_ps_parameterize, and updated ob_route_policy behavior.
  • MySQL‑mode ALTER TABLE … ADD INDEX now accepts mocked ALGORITHM and LOCK clauses.
  • New CREATE MATERIALIZED VIEW … AS OF PROCTIME() syntax to exclude tables from incremental refresh.
  • System‑tenant command ALTER SYSTEM LOAD MODULE DATA MODULE = {REDIS|GIS|TIMEZONE} TENANT = tenant_name [INFILE = file_path]; enables bulk import of Redis, timezone, or GIS metadata.

Critical Bug Fixes

The release addresses numerous stability issues, including transaction timeout under high concurrency, backup failures caused by skip index, incorrect aggregation results with constant expressions, and crashes related to long‑length SQL via the combined protocol. Performance regressions in MIN()/MAX() and statistics collection have also been resolved.

Conclusion

OceanBase 4.3.5 CE BP4 delivers substantial functional upgrades for MySQL compatibility, materialized views, and vector workloads while tightening operational reliability. Administrators should follow the outlined upgrade steps, especially the transfer‑task pause and extra time allocation for large partition counts.