OceanBase is an enterprise distributed relational database with high availability, high performance, horizontal scalability, and compatibility with SQL standards.
Information | Description |
---|---|
Release date | May 15, 2024 |
Version | V4.2.1_CE_BP6 |
Commit number | 38166dc |
OBServer RPM version | oceanbase-ce-4.2.1.6-106000012024042515 |
Optimization of show table status
performance: In earlier versions, the performance of the show table status from ... like ...
command is not ideal because it did not make use of indexes related to table_name
. In the new version, significant improvement in query performance has been achieved for scenarios with single table filtering conditions.
SET collation_connection = 'utf8mb4_unicode_ci'
is executed, comparing/joining columns of string type in information_schema
would cause an error Illegal mix of collations
, which is not compatible with native MySQL.项目 | 描述 |
---|---|
发布日期 | 2024-05-15 |
版本号 | V4.2.1_CE_BP6 |
Commit 号 | 38166dc |
OBServer RPM 版本号 | oceanbase-ce-4.2.1.6-106000012024042515 |
优化 show table status
性能: 老版本 show table status from ... like ...
场景性能较差,未利用 table_name
相关索引。新版本针对存在单表过滤条件的场景,显著提升查询性能。
SET collation_connection = 'utf8mb4_unicode_ci'
后,information_schema
下字符串类型的列比较/关联操作,会报错 Illegal mix of collations
,和原生 MySQL 不兼容的问题。Information | Description |
---|---|
Release date | April 24, 2024 |
Version | V4.2.1_CE_BP5 |
Commit number | ec03c25 |
OBServer RPM version | oceanbase-ce-4.2.1.5-105000032024041915 |
Compatibility with MySQL
SET
statement that contains the SET NAMES
statement can also set other variables.information_schema.events
table of MySQL is supported. #1194
Other optimizations
[G]V$OB_SESSION
view is provided to display session information and help reduce the time required in collecting processlist statistics.NETWORK_WAIT_TIME
column is added to the GV$OB_SQL_AUDIT
view to indicate the total amount of time spent on events of the Network class.log_storage_compress_all
parameter is provided to specify whether to compress clogs for storage, and the log_storage_compress_func
parameter is provided to specify the clog compression algorithm.slog
and sstable
directories now can be stored in different paths on the disk.To ensure stability, the batch rescan optimization feature was disabled by default for the NESTED-LOOP JOIN (NLJ) and SUBPLAN FILTER (SPF) operators during cluster creation in OceanBase Database since V4.2.1_CE_BP2_HF1. This feature is optimized in V4.2.1_CE_BP5 and is now enabled by default. In other words, the batch rescan optimization feature is enabled by default for new tenants. In OceanBase Database of a version earlier than V4.2.1_CE_BP5, the feature is still disabled by default. You can manually enable the feature as needed.
slog
disk is used up.information_schema.tables
and all_tables
after a DDL operation is performed to convert a non-partitioned table into a partitioned table.obstack
command is automatically executed when requests are accumulated in the queue.SHOW TRACE
statement for a distributed execution plan after end-to-end tracing is enabled.INT64_MAX
when the LIMIT OFFSET
syntax is used in the .NET
driver.create table if not exists
statement to create an existing table immediately after the cluster is restarted.OceanBase Database V4.2.1_CE_BP5 fixes the issue where connection establishment fails because the reference count of session connections is leaked. We recommend that you upgrade OceanBase Database to V4.2.1_CE_BP5 as soon as possible.
项目 | 描述 |
---|---|
发布日期 | 2024-04-24 |
版本号 | V4.2.1_CE_BP5 |
Commit 号 | ec03c25 |
OBServer RPM 版本号 | oceanbase-ce-4.2.1.5-105000032024041915 |
MySQL 兼容性
SET
语句中同时包含 SET NAMES
语句和使用 SET
设置其他变量。information_schema.events
表结构。 #1194
其他优化
[G]V$OB_SESSION
视图展示会话信息,优化 Processlist 统计时间。GV$OB_SQL_AUDIT
视图新增 NETWORK_WAIT_TIME
字段,用于展示所有 Network 类事件的总时间。_parallel_ddl_control
参数用于控制是否在租户级别开启各类并行 DDL 的功能。log_storage_compress_all
控制是否开启 Clog 存储压缩功能以及通过 log_storage_compress_func
设置 Clog 存储压缩的压缩算法。slog
和 sstable
的目录放在不同的磁盘目录下。出于稳定性因素的考虑,从 V4.2.1_CE_BP2_HF1 版本开始,新建集群时,Nested Loop join(NLJ)和 SUBPLAN FILTER(SPF)算子的 BATCH RESCAN 优化默认会被关闭。我们针对该功能进行了专项提升,在 V4.2.1_CE_BP5 版本重新打开该默认开关。V4.2.1_CE_BP5 版本开始,新建的租户默认保持 BATCH RESCAN 优化开启。升级前已存在的老租户会维持原来的配置,如需打开优化,需在对应的租户下执行 SET GLOBAL _nlj_batching_enabled = true
手动开启。
slog
盘满导致系统租户队列积压的问题。information_schema.TABLES
/ALL_TABLES
)多显示一条记录的问题。.NET
驱动中使用 limit offset 时遇到 int64_max
溢出导致的 core 问题。V4.2.1_CE_BP5 版本修复了集群 session 连接数引用计数泄漏导致不能新建连接的问题,请尽快升级到 V4.2.1_CE_BP5 版本。
Information | Description |
---|---|
Release date | March 13, 2024 |
Version | V4.2.2_CE_BP1 |
Commit number | 083a68a |
OBServer RPM version | oceanbase-ce-4.2.2.1-101000012024030709 |
项目 | 描述 |
---|---|
发布日期 | 2024-03-13 |
版本号 | V4.2.2_CE_BP1 |
Commit 号 | 083a68a |
OBServer RPM 版本号 | oceanbase-ce-4.2.2.1-101000012024030709 |
Information | Description |
---|---|
Release date | March 5, 2024 |
Version | V4.2.1_CE_BP4 |
Commit number | 3246b00 |
OBServer RPM version | oceanbase-ce-4.2.1.4-104000052024022918 |
MIN
or MAX
functions.COMMENT
field in the information_schema.STATISTICS
view.TENANT
keyword is changed from a required parameter to an optional one in the table-level restore statement.max_syslog_file_count
parameter is changed to control the total number of log files of all types.UNION ALL
operation on TIMESTAMP
data may be inaccurate.
binlog_row_image
.
upgrade_post.py
script fails to execute when an upgrade is performed after the enable_rebalance
parameter is manually disabled.
ALTER SYSTEM SET
statement is used to modify multiple parameters.
DROP DATABASE
statement is executed in a cluster with small specifications.
项目 | 描述 |
---|---|
发布日期 | 2024-03-05 |
版本号 | V4.2.1_CE_BP4 |
Commit 号 | 3246b00 |
OBServer RPM 版本号 | oceanbase-ce-4.2.1.4-104000052024022918 |
MIN
或 MAX
函数时的查询性能。information_schema.STATISTICS
的 COMMENT
字段来判断索引状态。TENANT
关键字为可选。max_syslog_file_count
调整为控制所有类型的 Log 总量。TIMESTAMP
类型的数据进行 Union All 操作时,返回结果可能不正确的问题。
binlog_row_image
系统变量的影响。
enable_rebalance
参数后升级,执行 upgrade_post.py
脚本失败的问题。
ALTER SYSTEM SET
语句修改多个配置项时,可能出现部分配置项同步失败的问题。
DROP DATABASE
可能由于 sys 租户内存过小报错 4013 的问题。
Information | Description |
---|---|
Release date | February 28, 2024 |
Version | V4.2.2_CE_HF1 |
Commit number | c984fe7 |
OBServer RPM version | oceanbase-ce-4.2.2.0-100010012024022719 |
项目 | 描述 |
---|---|
发布日期 | 2024-2-28 |
版本号 | V4.2.2_CE_HF1 |
Commit 号 | c984fe7 |
OBServer RPM 版本号 | oceanbase-ce-4.2.2.0-100010012024022719 |
Information | Description |
---|---|
Release date | February 5, 2024 |
Version | V4.2.1_CE_BP3_HF2 |
Commit number | 73d0496 |
OBServer RPM version | oceanbase-ce-4.2.1.3-103020042024020317 |
systemd service
.
When using the bypass import feature to import LOB data that exceeds 4 KB, a transfer event could result in import failure. Therefore, we recommend that you temporarily disable the transfer feature.
When using the bypass import feature to import LOB data that exceeds 4 KB, if a leader switchover occurs during the import process, the system will attempt to perform the import operation again.
项目 | 描述 |
---|---|
发布日期 | 2024-02-05 |
版本号 | V4.2.1_CE_BP3_HF2 |
Commit 号 | 73d0496 |
OBServer RPM 版本号 | oceanbase-ce-4.2.1.3-103020042024020317 |
systemd service
的方式启停 OceanBase 数据库。
使用旁路导入功能导入超过 4 KB 的 LOB 数据时,如果发生 Transfer,则会导致导入失败,建议使用时临时关闭 Transfer 功能。
使用旁路导入功能导入超过 4 KB 的 LOB 数据时,如果导入过程中发生切主,则系统会进行重试。
Information | Description |
---|---|
Release date | January 25, 2024 |
Version | V4.2.1_CE_BP3_HF1 |
Commit number | 37a4c62 |
OBServer RPM version | oceanbase-ce-4.2.1.3-103010052024011916 |
DBMS_MONITOR
package with decimal type data would result in an Incorrect arguments to control info
error.
LONGTEXT
columns.
insertOrUpdate
operation on the OBKV client failed to write data when an auto-increment column of the table was used as the primary key and secondary indexes existed.
ORDER BY
and LIMIT
clauses were used.
项目 | 描述 |
---|---|
发布日期 | 2024-1-25 |
版本号 | V4.2.1_CE_BP3_HF1 |
Commit 号 | 37a4c62 |
OBServer RPM 版本号 | oceanbase-ce-4.2.1.3-103010052024011916 |
DBMS_MONITOR
包传入小数类型数据报错 Incorrect arguments to control info
的问题。
insertOrUpdate
接口写入失败的问题。
order by + limit
分页场景下,由于执行计划不优导致查询性能慢的问题。