oceanbase

oceanbase copied to clipboard

[Enhancement]: Add snapshot ahead function for Ash Buffer

1

**Enhancement** A timer task refreshes the Ash Buffer information on the current machine, decides whether to perform an early snapshot, and sends snapshot requests to the leaders of all tenants....

huasiy

[Bug]: 疑似OceanBase内置诊断SQL导致CPU满载 || [Bug]: It is suspected that OceanBase’s built-in diagnostic SQL causes the CPU to be fully loaded

1

**Describe the bug** 我们正在使用 OMS 进行数据迁移 （从 MySQL 到 OceanBase），但是 OceanBase 中有一个完全没有参与到数据迁移的表，似乎被 OceanBase 自动执行了一些内置的诊断SQL，让 CPU 从 40+% 直接飙升到满载，产生了少则几十秒，多则几千秒的慢查询，也导致 OCP 一直频繁触发 CPU 使用率超限 的告警。 这些语句明显不是我们人为执行的。 **Environment** - OS Version: CentOS 8.2...

CodePlayer

### Task Description add expression implementation split_part in src/sql/engine/expr/ob_expr_split_part.cpp and src/sql/engine/expr/ob_expr_split_part.h add mysqltest for split_part ### Solution Description ### Passed Regressions ### Upgrade Compatibility ### Other Information the expression can...

kigb

[Question]: OB备份到S3采用tagging delete_mode，一个月1亿次WriteObjectTagging API调用 || [Question]: OB is backed up to S3 using tagging delete_mode, and the WriteObjectTagging API is called 100 million times a month

3

OB Version : OB-CE 4.3.1.0 Beta 部署在AWS，1-1-1集群，备份到S3，delete_mode=tagging。 看账单发现OB的S3桶一个月WriteObjectTagging调用了1亿多次，平均每天330多万次。 统计每天的备份文件数在12000~13000左右，不明白这么多API调用怎么来的。 --- OB Version: OB-CE 4.3.1.0 Beta Deployed in AWS, 1-1-1 cluster, backed up to S3, delete_mode=tagging. Looking at the bill, I...

lenmore

HashJoin MCV Optimization

1

### Task Description close #2052 ### Solution Description #### Solution: - If the memory is not enough to accommodate the left table to build a hash table and the histogram...

huayichai

[Question]: openeuler build error

3

**Question** build error： deps/oblib/src/lib/geo/ob_vector_tile.pb-c.h:18:10: ^[[0m^[[0;1;31mfatal error: ^[[0m^[[1m'protobuf-c/protobuf-c.h' file not found^[[0m #include **Environment** openEuler 22.03 (LTS-SP3) - OS Version and CPU Arch(`uname -a`): Linux localhost.localdomain 5.10.0-182.0.0.95.oe2203sp3.aarch64 #1 SMP Sat Dec 30...

weijinrongyuan

[Feature]: implement gis exprs || [Feature]: implement gis exprs

1

**Use Case** **Describe the solution you'd like** **Describe alternatives you've considered** **Additional context** --- **Use Case** **Describe the solution you'd like** **Describe alternatives you've considered** **Additional context**

helloamateur

fix collation, coercibility bugs && add test

1

### Task Description fix bug of collation and coercibility mismatch with mysql ### Solution Description modify the implementations of several functions ### Passed Regressions add&pass mysqltest ### Upgrade Compatibility compatible...

kigb

[Enhancement]: 分区均衡过程中尽量随机打散分区 || [Enhancement]: During the partition balancing process, the partitions are dispersed as randomly as possible.

1

# 现有问题 1. 非分区表聚合之后取消聚合，分区均衡后，同一个database上的所有非分区表都聚集到同一日志流上 * 创建3个数据库，每个数据库包含100个非分区表，创建后每个数据库的非分区表被均匀地打散到各日志流上 ``` SELECT ls_id, database_name, role, count(*) FROM oceanbase.DBA_OB_TABLE_LOCATIONS where table_id >= 500000 and role = 'LEADER' group by ls_id, database_name order by database_name; +-------+---------------+--------+----------+...

Young-Cody

[Question]: OB的表达式求值框架采用中缀表达式还是后缀表达式？ || [Question]: Does OB's expression evaluation framework use infix expressions or postfix expressions?

8

**Question** 最近在学习ob向量化执行框架的实现，有个细节不太明白。 `src/sql/code_generator/ob_static_engine_expr_cg.cpp`这个源文件中，有这样一个函数： ```cpp // 1. 将所有raw exprs展开 // cg: c1 + 1, c1 + c2 ==> c1, 1, c1 + 1, c2, c1 + c2 // 2. 构造ObExpr, 并将ObExpr对应设置到对应ObRawExpr中...

Yriuns