oceanbase / oceanbase-doc Goto Github PK

View Code? Open in Web Editor NEW

20.0 9.0 93.0 71.88 MB

oceanbase-doc's Introduction

OceanBase 数据库文档

欢迎访问 OceanBase 数据库文档。您可以在本仓库中查看 OceanBase 数据库的中英文文档。

zh-CN 文件夹下存放的是 OceanBase 数据库的中文文档
en-US 文件夹下存放的是 OceanBase 数据库的英文文档

OceanBase 欢迎大家随时参与到文档的共同建设中，OceanBase 文档的贡献者可以：

提交文档问题或者建议
优化已有的内容
编写新的内容

贡献文档

开始之前

感谢您对 OceanBase 数据库文档的贡献兴趣。为厘清就个人或实体贡献内容而授予的知识产权许可，我们必须对每位贡献者签署的贡献者许可协议（Contributor Licence Agreement，简称 CLA）（“CLA”）进行归档，以证明就 CLA 达成的一致。点击 OceaBase CLA，点击 Sign in with GitHub to agree 按钮签署协议。

贡献指南

您可以按照以下步骤提交 Pull Request（简称 PR）：

步骤 1：Fork 项目仓库

访问 OceanBase 数据库文档的 GitHub 地址。
点击 Fork 按钮创建远程分支。

步骤 2：克隆分支到本地

定义工作目录。

# 定义工作目录
working_dir=$HOME/Workspace

配置 GitHub 用户名。
```
user={GitHub账户名}
```

克隆代码。

# 克隆代码
mkdir -p $working_dir
cd $working_dir
git clone [email protected]:$user/oceanbase-doc.git
# 或: git clone https://github.com/$user/oceanbase-doc.git

# 添加上游分支
cd $working_dir/oceanbase-doc
git remote add upstream [email protected]:oceanbase/oceanbase-doc.git
# 或: git remote add upstream https://github.com/oceanbase/oceanbase-doc.git

# 为上游分支设置 no_push
git remote set-url --push upstream no_push

# 确认远程分支有效
git remote -v

步骤 3：创建新分支

更新本地分支。

cd $working_dir/oceanbase-doc
git fetch upstream
git checkout $branch
git rebase upstream/$branch

基于本地 $branch 分支创建新分支。
```
git checkout -b new-branch-name
```

步骤 4：修改/添加/删除文档

在 new-branch-name 上修改文档并保存更改。

步骤 5：提交更改

# 检查本地文件状态
git status

# 添加您希望提交的文件
# 如果您希望提交所有更改，直接使用 `git add .`
git add <file> ... 
git commit -m "commit-message: update the xx"

步骤 6：保持开发分支与上游分支同步

# 在开发分支执行以下操作
git fetch upstream
git rebase upstream/branch

步骤 7：推送更改至远程分支

# 在开发分支执行以下操作
git push -u origin new-branch-name

步骤 8：创建 PR

访问您 Fork 的仓库。
单击 new-branch-name 分支旁的 Compare & pull request 按钮。

以上就是参与 OceanBase 数据库文档共建的步骤，如果在此过程中遇到任何问题，可以加入我们唯一官网钉钉群：41203246，与社区热心的技术大神、热情的贡献者、经验丰富的技术专家一起交流、探讨问题。

oceanbase-doc's People

Contributors

Stargazers

Watchers

Forkers

rainelohim shuiyingshuiying meinawang amber1990zhang luoliwk liuqian1990 akaerror caifeizhi whupyw wenlixiu wg2049 liying1024 wangzk0206 cyujing luooofan mickyun yishidecengjing shunwah xjxjy askdb rainoon1 jackpaul lqkitten chrisyuan qinshaolin nmj1992 zhangjig nietiezheng hopelee2023 secxt zhangry7777 jiazibo calvinxzt bmeangel yr137157 hsunboy aaron8219 richaubin chris-sun-star aaron-23 hedpat 99huang lijiayun123 icannerxy frankxmx mozziewen ieayoio wugongbo zhoubengao win-man ajunlonglive iutx yuhuangwmn eudoratian raygift happyhust bigdata2018 longdafeng johbarca zhengyangyong teingi binchenn vonwind myisen angelii shenchai shp605 bloodsucker1 lemontree8801 flywiththewind stealbiketofeedyou sxhua dailong koalazhao martin19880126 klawzz zhqwzhcl kejun web-logs2 fforkboat yimimiyi peaceliu123 lacrimosaprinz selenachenjingxin whyyoulike zhaoshiyu2000 ridewithwind junli0411 qlmore hey-hoho raywill szg518

oceanbase-doc's Issues

ODP Best Practice or Performance Tunning

alter proxyconfig set enable_compression_protocol=false; --关闭压缩，降低cpu%
alter proxyconfig set proxy_mem_limited='16G'; --防止oom，可根据实际环境动态调整
alter proxyconfig set enable_prometheus=false;
alter proxyconfig set enable_metadb_used=false;
alter proxyconfig set enable_standby=false;
alter proxyconfig set enable_strict_stat_time=false;
alter proxyconfig set use_local_dbconfig=true;

如果CPU跑不满确认下work_thread_num这个数值，最好和CPU核数一样

文档的所有链接均不能正常链接到目标地址

文章内部所有的参考链接，功能为跳转到本文档的另一部分的，均不能正常链接到目的地址；现在点击是跳转到MD文件上，但是并不能在网页端正常显示。如下：

该图片上的系统表书写错误

链接地址：https://help-static-aliyun-doc.aliyuncs.com/assets/img/zh-CN/4462752461/p356007.jpg

这个图片上系统表前应该是双下划线，我这边没法提交更改，还请稍作修改。

Check Before Asking

Please check the issue list and confirm this issue is encountered for the first time.

Description

快速上手=》体验多租户特性=》根据创建的 resource pool 创建租户
存在如下重复字段：
在完成 tenant1、tenant2 租户创建后，您可以通过查询 oceanbase.DBA_OB_TENANTS 视图来确认租户是否创建成功。

obclient [oceanbase]> SELECT * FROM DBA_OB_TENANTS;
在完成 tenant1、tenant2 租户创建后，您可以通过查询 oceanbase.DBA_OB_TENANTS 视图来确认租户是否创建成功。

obclient [oceanbase]> SELECT * FROM DBA_OB_TENANTS;

Documentation Links

https://www.oceanbase.com/docs/community-observer-cn-10000000000900959

Are you willing to submit a pull request?

Yes I am willing to submit a pull request.

《与 MySQL 兼容性对比》需更新

5.release-notes.md

3.1.2版本新增函数： UUID_SHORT()、TO_BASE64()、FROM_BASE64()、DAY()、ANY_VALUE()

2.compatibility-with-mysql.md

不支持的函数需更新

[Doc]: add a image for deadlock

Check Before Asking

Please check the issue list and confirm this issue is encountered for the first time.

Description

from https://ask.oceanbase.com/t/topic/35600042

could the doc be added a image about how to change private label

Documentation Links

https://www.oceanbase.com/docs/community-observer-cn-10000000000902010

Are you willing to submit a pull request?

Yes I am willing to submit a pull request.

[Bug]: 永久关闭透明大页和 NUMA方法（CentOS 或 Red Hat 7/8）

Please check the issue list for the same bug

Please check issue list and confirm this bug is encountered for the first time.
Please try full text in English and attach precise description.

Environment

- Version or commit id.
- Hardware parameter: OS type & Compiler & CPU etc. 
- Others

OceanBase官网址中的手动关闭透明大页方法可能有问题的，而且此方法是临时的，不是永久的，重启OS会失效。
https://www.oceanbase.com/docs/community-observer-cn-10000000000900489
对于 CentOS 或 Red Hat 操作系统，需要运行以下命令，手动关闭透明大页：
echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled

临时关闭透明大页正确语法是 ：
 echo never > /sys/kernel/mm/transparent_hugepage/enabledecho never > /sys/kernel/mm/transparent_hugepage/defrag


建议永久关闭透明大页 和 NUMA（CentOS 或 Red Hat 7/8）：
sed -i 's/quiet/quiet transparent_hugepage=never numa=off/' /etc/default/grub
grub2-mkconfig -o /boot/grub2/grub.cfg

Fast Reproduce Steps (Required)

OceanBase官网址中的手动关闭透明大页方法可能有问题的，而且此方法是临时的，不是永久的，重启OS会失效。
https://www.oceanbase.com/docs/community-observer-cn-10000000000900489
对于 CentOS 或 Red Hat 操作系统，需要运行以下命令，手动关闭透明大页：
echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled

临时关闭透明大页正确语法是：
echo never > /sys/kernel/mm/transparent_hugepage/enabledecho never > /sys/kernel/mm/transparent_hugepage/defrag

建议永久关闭透明大页和 NUMA（CentOS 或 Red Hat 7/8）：
sed -i 's/quiet/quiet transparent_hugepage=never numa=off/' /etc/default/grub
grub2-mkconfig -o /boot/grub2/grub.cfg

Actual Behavior

临时关闭透明大页正确语法是：
echo never > /sys/kernel/mm/transparent_hugepage/enabledecho never > /sys/kernel/mm/transparent_hugepage/defrag

建议永久关闭透明大页和 NUMA（CentOS 或 Red Hat 7/8）：
sed -i 's/quiet/quiet transparent_hugepage=never numa=off/' /etc/default/grub
grub2-mkconfig -o /boot/grub2/grub.cfg

Expected Behavior

临时关闭透明大页正确语法是：
echo never > /sys/kernel/mm/transparent_hugepage/enabledecho never > /sys/kernel/mm/transparent_hugepage/defrag

建议永久关闭透明大页和 NUMA（CentOS 或 Red Hat 7/8）：
sed -i 's/quiet/quiet transparent_hugepage=never numa=off/' /etc/default/grub
grub2-mkconfig -o /boot/grub2/grub.cfg

other information

临时关闭透明大页正确语法是：
echo never > /sys/kernel/mm/transparent_hugepage/enabledecho never > /sys/kernel/mm/transparent_hugepage/defrag

建议永久关闭透明大页和 NUMA（CentOS 或 Red Hat 7/8）：
sed -i 's/quiet/quiet transparent_hugepage=never numa=off/' /etc/default/grub
grub2-mkconfig -o /boot/grub2/grub.cfg

[Doc]: Add limitation for resource pool merge and split

Check Before Asking

Please check the issue list and confirm this issue is encountered for the first time.

Description

Right now, there is no limiation introduction in the document of resource pool merge

It should add limitaion for resource pool merge and split.

Documentation Links

resource pool merge

Are you willing to submit a pull request?

Yes I am willing to submit a pull request.

Update installation process for 4.0

文档中出现未开放参数问题

【问题描述】
文档《I/O 相关参数》展示的参数 enable_clog_persistence_compress 在环境中找不到
文档链接：https://open.oceanbase.com/docs/observer-cn/V3.1.3/0000000000153086
【问题现象】
运行该参数出现如下报错：

MySQL [oceanbase]> ALTER SYSTEM SET enable_clog_persistence_compress=True;
ERROR 5099 (42000): System config unknown

【解决方案】
该参数在社区版 OB 未开放，与文档所示不一致，文档需更新。

[Doc]: Add requirement for MySQL authority

Check Before Asking

Please check the issue list and confirm this issue is encountered for the first time.

Description

oms mysql作为数据源，开启增量同步的用户权限需要有create/insert/update 心跳表的权限

Documentation Links

https://www.oceanbase.com/docs/community-oms-cn-10000000000818595

Are you willing to submit a pull request?

Yes I am willing to submit a pull request.

不可编缉

https://open.oceanbase.com/docs/observer-cn/V3.1.3/0000000000160026 这个链接不可编缉

[Doc]: The load data 's limitation isn't accurate

Check Before Asking

Please check the issue list and confirm this issue is encountered for the first time.

Description

目前，OceanBase 数据库不支持 LOCAL INFILE 的语法加载数据文件。这是由于 OceanBase 是分布式数据库，读写数据由 Leader 节点进行，而 CSV 文件需要上传到 Leader 节点所在服务器才能加载，因此需要提供 NAS 文件系统进行文件存放。OceanBase 数据库中的 LOAD DATA 语句仅支持加载 OBServer 本地的输入文件。因此，用户需要在导入之前将文件拷贝到某台 OBServer 上。

This paragraph isn't accurate.

Documentation Links

No response

Are you willing to submit a pull request?

Yes I am willing to submit a pull request.

[Doc]: Add example to Flashback query

Check Before Asking

Please check the issue list and confirm this issue is encountered for the first time.

Description

There is no example for Flashback query.

It should add one example for Flashback query.

At the same time, suggest user no to use flashback query right now.

Documentation Links

https://www.oceanbase.com/docs/community-observer-cn-10000000000901303

Are you willing to submit a pull request?

Yes I am willing to submit a pull request.

1.oceanbase-database -> 2.compatibility-with-mysql.md -> 备份恢复小节不完整

备份恢复

OceanBase 数据库兼容了部分 MySQL 数据库的备份恢复特性，主要支持情况如下：

<内容缺失>

唯一索引

CREATE TABLE t1(c1 INT, c2 INT, c3 INT, c4 INT, PRIMARY KEY(c1)); CREATE INDEX i1 ON t1(c2); CREATE UNIQUE INDEX i2 ON t1(c3);

对于非唯一索引表 i1，它的存储键是 c2 和 c1，而对于唯一索引表 i2，它的存储键是 c2，而 c1 是可变的。当 c2 为 NULL 时，可变的 c1 列值是主表 c1 列的值；当 c2 不为 NULL 时，可变的 c1 列值为 NULL

1、c1为主键就不可能为空
2、c3唯一键和主键没啥关系吧

建议OB3.1.2及其后续版本文档能给出DDL支持列表

在OB3.1.0/3.1.1版本的官网上有DDL的支持列表：
https://open.oceanbase.com/docs/observer-cn/V3.1.1/10000000000013308
https://open.oceanbase.com/docs/observer-cn/V3.1.0/10000000000016345

目前3.1.2版本没有找到，建议在OB3.1.2及其后续的版本也能明确给出对应版本针对DDL支持列表。

性能优化部分, 需要增加机器部署架构

比如在tpcc/sysbench/tpch 性能测试中,

建议机器规格

其中可能需要有个公式, 算出ecs 1 需要多少资源, 比如如果想跑更高并发数, ecs1 可能需要更高的配置
ecs1: 8核/64g内存/essd 磁盘1快部署tpcc/sysbench/tpch 客户端程序 + obproxy + obdeploy
ecs2: 32核/256g 内存/essd 磁盘2块部署observer
ecs3: 32核/256g 内存/essd 磁盘2块部署observer
ecs4: 32核/256g 内存/essd 磁盘2块部署observer

文档中创建临时表语句不支持问题

【问题描述】
使用文档展示的建表语句建临时表，出现报错为不支持。
文档链接：https://open.oceanbase.com/docs/observer-cn/V3.1.3/10000000000096805
建表语句： CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table_name (table_definition_list) [table_option_list] [partition_option] [AS] select;
【问题现象】
报错结果：

create temporary table t6 as select * from t2;
ERROR 1235 (0A000): View/Table's column refers to a temporary table not supported

【解决方案】
该语句目前不支持，需更新文档。

Adjuect the performance testing method with OBD

Due to performance test can be done by OBD easily, please update the performance testing method

[Bug]: The setting of password in RDB adapter is wrong

Check Before Asking

Please check the issue list and confirm this bug is encountered for the first time.
Please try full text in English and attach precise description.

Environment

The setting of password in RDB adapter is wrong

Fast Reproduce Steps

The setting of password in RDB adapter is wrong

Actual Behavior

The setting of password in RDB adapter is wrong

Expected Behavior

No response

Other Information

No response

[Doc]: Add example to show how to enable parallel query.

Check Before Asking

Please check the issue list and confirm this issue is encountered for the first time.

Description

Add example to show how to enable parallel query.

https://www.oceanbase.com/docs/community-observer-cn-10000000000901975

3 种方式打开并行查询

hint 方式

obclient [tpch]> explain select /*+ PARALLEL(8) */ count(*) from lineitem;
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ==================================================
|ID|OPERATOR             |NAME    |EST. ROWS|COST|
--------------------------------------------------
|0 |SCALAR GROUP BY      |        |1        |7   |
|1 | PX COORDINATOR      |        |8        |7   |
|2 |  EXCHANGE OUT DISTR |:EX10000|8        |6   |
|3 |   MERGE GROUP BY    |        |8        |6   |
|4 |    PX BLOCK ITERATOR|        |1        |6   |
|5 |     TABLE SCAN      |lineitem|1        |6   |
==================================================

Outputs & filters:
-------------------------------------
  0 - output([T_FUN_COUNT_SUM(T_FUN_COUNT_SUM(T_FUN_COUNT(*)))]), filter(nil), rowset=256,
      group(nil), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT_SUM(T_FUN_COUNT(*)))])
  1 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]), filter(nil), rowset=256
  2 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]), filter(nil), rowset=256, dop=8
  3 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]), filter(nil), rowset=256,
      group(nil), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT(*))])
  4 - output([T_FUN_COUNT(*)]), filter(nil), rowset=256
  5 - output([T_FUN_COUNT(*)]), filter(nil), rowset=256,
      access(nil), partitions(p[0-23])
 |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.004 sec)

设置session 环境变量

obclient [tpch]> set _force_parallel_query_dop = 3;
Query OK, 0 rows affected (0.001 sec)
obclient [tpch]> explain select count(*) from lineitem;
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ==================================================
|ID|OPERATOR             |NAME    |EST. ROWS|COST|
--------------------------------------------------
|0 |SCALAR GROUP BY      |        |1        |15  |
|1 | PX COORDINATOR      |        |3        |15  |
|2 |  EXCHANGE OUT DISTR |:EX10000|3        |14  |
|3 |   MERGE GROUP BY    |        |3        |14  |
|4 |    PX BLOCK ITERATOR|        |1        |14  |
|5 |     TABLE SCAN      |lineitem|1        |14  |
==================================================

Outputs & filters:
-------------------------------------
  0 - output([T_FUN_COUNT_SUM(T_FUN_COUNT_SUM(T_FUN_COUNT(*)))]), filter(nil), rowset=256,
      group(nil), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT_SUM(T_FUN_COUNT(*)))])
  1 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]), filter(nil), rowset=256
  2 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]), filter(nil), rowset=256, dop=3
  3 - output([T_FUN_COUNT_SUM(T_FUN_COUNT(*))]), filter(nil), rowset=256,
      group(nil), agg_func([T_FUN_COUNT_SUM(T_FUN_COUNT(*))])
  4 - output([T_FUN_COUNT(*)]), filter(nil), rowset=256
  5 - output([T_FUN_COUNT(*)]), filter(nil), rowset=256,
      access(nil), partitions(p[0-23])
 |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.003 sec)

建表时强制设置并行度

obclient [tpch]> create table t1(a int, b int ) parallel 3;
Query OK, 0 rows affected (0.136 sec)

obclient [tpch]> explain select * from t1;
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ================================================
|ID|OPERATOR           |NAME    |EST. ROWS|COST|
------------------------------------------------
|0 |PX COORDINATOR     |        |1        |2   |
|1 | EXCHANGE OUT DISTR|:EX10000|1        |1   |
|2 |  PX BLOCK ITERATOR|        |1        |1   |
|3 |   TABLE SCAN      |t1      |1        |1   |
================================================

Outputs & filters:
-------------------------------------
  0 - output([INTERNAL_FUNCTION(t1.a, t1.b)]), filter(nil), rowset=256
  1 - output([INTERNAL_FUNCTION(t1.a, t1.b)]), filter(nil), rowset=256, dop=3
  2 - output([t1.a], [t1.b]), filter(nil), rowset=256
  3 - output([t1.a], [t1.b]), filter(nil), rowset=256,
      access([t1.a], [t1.b]), partitions(p0)
 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.098 sec)

Documentation Links

备注ALTER SESSION 是oracle 语法, 社区版没有
ALTER SESSION FORCE PARALLEL QUERY PARALLEL 3;
ALTER SESSION FORCE PARALLEL DML PARALLEL 3;
https://www.oceanbase.com/docs/enterprise-oceanbase-database-cn-10000000000363715
ALTER SESSION FORCE PARALLEL QUERY PARALLEL 3;

obclient [tpch]> ALTER SESSION FORCE PARALLEL QUERY PARALLEL 3;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'SESSION FORCE PARALLEL QUERY PARALLEL 3' at line 1

ALTER SESSION FORCE PARALLEL DML PARALLEL 3;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'SESSION FORCE PARALLEL DML PARALLEL 3' at line 1

Are you willing to submit a pull request?

Yes I am willing to submit a pull request.

OceanBase 数据库 TPC-H 测试一文中，修改query的步骤不完整

原文中写道：“
去掉生成文件中的 limit -xx（OB不支持limit 负数的语法） , 去掉 day 后的 (3), 加上parallel(96) 并发
”

实际上只这样做是不够的，还需要

某些非负数的limit 100，要去掉limit前面的;
更关键的，q13需要修改语法，否则会报错You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near '(c_custkey, c_count)

文档缺少各虚拟表作用和字段的含义

__all_virtual_processlist
__all_virtual_core_meta_table
__all_virtual_zone_stat
__all_virtual_plan_cache_stat
__all_virtual_plan_stat
__all_virtual_mem_leak_checker_info
__all_virtual_latch
__all_virtual_kvcache_info
__all_virtual_data_type_class
__all_virtual_data_type
__all_virtual_server_stat
__all_virtual_rebalance_task_stat
__all_virtual_session_event
__all_virtual_session_wait
__all_virtual_session_wait_history
__all_virtual_system_event
__all_virtual_tenant_memstore_info
__all_virtual_concurrency_object_pool
__all_virtual_sesstat
__all_virtual_sysstat
__all_virtual_storage_stat
__all_virtual_disk_stat
__all_virtual_memstore_info
__all_virtual_partition_info
__all_virtual_upgrade_inspection
__all_virtual_trans_stat
__all_virtual_trans_mgr_stat
__all_virtual_election_info
__all_virtual_election_mem_stat
__all_virtual_sql_audit
__all_virtual_trans_mem_stat
__all_virtual_partition_sstable_image_info
__all_virtual_core_root_table
__all_virtual_core_all_table
__all_virtual_core_column_table
__all_virtual_memory_info
__all_virtual_tenant_stat
__all_virtual_sys_parameter_stat
__all_virtual_partition_replay_status
__all_virtual_clog_stat
__all_virtual_trace_log
__all_virtual_engine
__all_virtual_proxy_server_stat
__all_virtual_proxy_sys_variable
__all_virtual_proxy_schema
__all_virtual_plan_cache_plan_explain
__all_virtual_obrpc_stat
__all_virtual_partition_sstable_merge_info
__all_virtual_sql_monitor
__all_virtual_sql_plan_statistics
__all_virtual_partition_sstable_macro_info
__all_virtual_proxy_partition_info
__all_virtual_proxy_partition
__all_virtual_proxy_sub_partition
__all_virtual_proxy_route
__all_virtual_rebalance_tenant_stat
__all_virtual_rebalance_unit_stat
__all_virtual_rebalance_replica_stat
__all_virtual_partition_amplification_stat
__all_virtual_election_event_history
__all_virtual_partition_store_info
__all_virtual_leader_stat
__all_virtual_partition_migration_status
__all_virtual_sys_task_status
__all_virtual_macro_block_marker_status
__all_virtual_server_clog_stat
__all_virtual_rootservice_stat
__all_virtual_election_priority
__all_virtual_tenant_disk_stat
__all_virtual_rebalance_map_stat
__all_virtual_rebalance_map_item_stat
__all_virtual_io_stat
__all_virtual_long_ops_status
__all_virtual_rebalance_unit_migrate_stat
__all_virtual_rebalance_unit_distribution_stat
__all_virtual_server_object_pool
__all_virtual_trans_lock_stat
__all_virtual_election_group_info
__all_virtual_server_blacklist
__all_virtual_partition_split_info
__all_virtual_trans_result_info_stat
__all_virtual_duplicate_partition_mgr_stat
__all_virtual_tenant_parameter_stat
__all_virtual_server_schema_info
__all_virtual_memory_context_stat
__all_virtual_dump_tenant_info
__all_virtual_tenant_parameter_info
__all_virtual_dag_warning_history
__all_virtual_master_key_version_info
__all_virtual_server_memory_info
__all_virtual_partition_table
__all_virtual_lock_wait_stat
__all_virtual_partition_item
__all_virtual_replica_task
__all_virtual_partition_location
__all_virtual_tenant_memstore_allocator_info
__all_virtual_table_mgr
__all_virtual_meta_table
__all_virtual_freeze_info
__all_virtual_bad_block_table
__all_virtual_px_worker_stat
__all_virtual_trans_audit
__all_virtual_trans_sql_audit
__all_virtual_weak_read_stat
__all_virtual_partition_audit
__all_virtual_sequence_v2
__all_virtual_sequence_value
__all_virtual_cluster
__all_virtual_partition_table_store_stat
__all_virtual_ddl_operation
__all_virtual_outline
__all_virtual_outline_history
__all_virtual_synonym
__all_virtual_synonym_history
__all_virtual_database_privilege
__all_virtual_database_privilege_history
__all_virtual_table_privilege
__all_virtual_table_privilege_history
__all_virtual_database
__all_virtual_database_history
__all_virtual_tablegroup
__all_virtual_tablegroup_history
__all_virtual_table
__all_virtual_table_history
__all_virtual_column
__all_virtual_column_history
__all_virtual_part
__all_virtual_part_history
__all_virtual_part_info
__all_virtual_part_info_history
__all_virtual_def_sub_part
__all_virtual_def_sub_part_history
__all_virtual_sub_part
__all_virtual_sub_part_history
__all_virtual_constraint
__all_virtual_constraint_history
__all_virtual_foreign_key
__all_virtual_foreign_key_history
__all_virtual_foreign_key_column
__all_virtual_foreign_key_column_history
__all_virtual_temp_table
__all_virtual_ori_schema_version
__all_virtual_sys_stat
__all_virtual_user
__all_virtual_user_history
__all_virtual_sys_variable
__all_virtual_sys_variable_history
__all_virtual_func
__all_virtual_func_history
__all_virtual_package
__all_virtual_package_history
__all_virtual_routine
__all_virtual_routine_history
__all_virtual_routine_param
__all_virtual_routine_param_history
__all_virtual_type
__all_virtual_type_history
__all_virtual_type_attr
__all_virtual_type_attr_history
__all_virtual_coll_type
__all_virtual_coll_type_history
__all_virtual_column_stat
__all_virtual_table_stat
__all_virtual_histogram_stat
__all_virtual_column_statistic
__all_virtual_recyclebin
__all_virtual_tenant_gc_partition_info
__all_virtual_tenant_plan_baseline
__all_virtual_tenant_plan_baseline_history
__all_virtual_sequence_object
__all_virtual_sequence_object_history
__all_virtual_raid_stat
__all_virtual_server_log_meta
__all_virtual_dtl_channel
__all_virtual_dtl_memory
__all_virtual_dtl_first_cached_buffer
__all_virtual_dblink
__all_virtual_dblink_history
__all_virtual_tenant_partition_meta_table
__all_virtual_tenant_role_grantee_map
__all_virtual_tenant_role_grantee_map_history
__all_virtual_tenant_keystore
__all_virtual_tenant_keystore_history
__all_virtual_deadlock_stat
__all_virtual_tenant_tablespace
__all_virtual_tenant_tablespace_history
__ALL_VIRTUAL_INFORMATION_COLUMNS
__all_virtual_pg_partition_info
__all_virtual_tenant_user_failed_login_stat
__all_virtual_tenant_profile
__all_virtual_tenant_profile_history
__all_virtual_security_audit
__all_virtual_security_audit_history
__all_virtual_trigger
__all_virtual_trigger_history
__all_virtual_cluster_stats
__all_virtual_sstable_column_checksum
__all_virtual_ps_stat
__all_virtual_ps_item_info
__all_virtual_sql_workarea_history_stat
__all_virtual_sql_workarea_active
__all_virtual_sql_workarea_histogram
__all_virtual_sql_workarea_memory_info
__all_virtual_security_audit_record
__all_virtual_sysauth
__all_virtual_sysauth_history
__all_virtual_objauth
__all_virtual_objauth_history
__all_virtual_backup_info
__all_virtual_backup_task
__all_virtual_pg_backup_task
__all_virtual_pg_backup_log_archive_status
__all_virtual_server_backup_log_archive_status
__all_virtual_error
__all_virtual_timestamp_service
__all_virtual_table_modifications
__all_virtual_backup_clean_info
__all_virtual_restore_pg_info
__all_virtual_object_type
__all_virtual_trans_table_status
__all_virtual_pg_log_archive_stat
__all_virtual_sql_plan_monitor
__all_virtual_sql_monitor_statname
__all_virtual_open_cursor
__all_virtual_backup_validation_task
__all_virtual_pg_backup_validation_task
__all_virtual_time_zone
__all_virtual_time_zone_name
__all_virtual_time_zone_transition
__all_virtual_time_zone_transition_type
__all_virtual_constraint_column
__all_virtual_constraint_column_history
__all_virtual_files
__all_virtual_dependency
__all_virtual_reserved_table_mgr
__all_virtual_backupset_history_mgr
__all_virtual_backup_backupset_task
__all_virtual_pg_backup_backupset_task
__all_virtual_global_transaction

oceanbase / oceanbase-doc Goto Github PK

oceanbase-doc's Introduction

OceanBase 数据库文档

贡献文档

开始之前

贡献指南

oceanbase-doc's People

Contributors

Stargazers

Watchers

Forkers

oceanbase-doc's Issues

Check Before Asking

Description

Documentation Links

Are you willing to submit a pull request?

Check Before Asking

Description

Documentation Links

Are you willing to submit a pull request?

Please check the issue list for the same bug

Environment

Fast Reproduce Steps (Required)

Actual Behavior

Expected Behavior

other information

Check Before Asking

Description

Documentation Links

Are you willing to submit a pull request?

Check Before Asking

Description

Documentation Links

Are you willing to submit a pull request?

Check Before Asking

Description

Documentation Links

Are you willing to submit a pull request?

Check Before Asking

Description

Documentation Links

Are you willing to submit a pull request?

Check Before Asking

Environment

Fast Reproduce Steps

Actual Behavior

Expected Behavior

Other Information

Check Before Asking

Description

Documentation Links

Are you willing to submit a pull request?

Recommend Projects

Recommend Topics

Recommend Org