help 帮助问题

OceanBase 技术问题
#1 
CREATE RESOURCE UNIT unitname 
MAX_CPU [=] cpunum, 
MAX_MEMORY [=] memsize, 
MAX_IOPS [=] iopsnum, 
MAX_DISK_SIZE [=] disksize, 
MAX_SESSION_NUM [=] sessionnum, 
[MIN_CPU [=] cpunum,]
[MIN_MEMORY [=] memsize,] 
[MIN_IOPS [=] iopsnum] ;

比如 create resource unit语法，我在obclient或者 mysql shell 下如何查看create resource unit帮助呢？
谢谢！

#3

HELP 功能需要加载 help tables 才能正常使用，步骤如下：

1. 复制 `fill_help_tables-ob.sql` 文件至客户端机器 `tmp` 目录下。
2. 登录 sys 租户执行语句 `source /tmp/fill_help_tables-ob.sql` 。
注意：默认在/home/admin/.obd/repository/oceanbase-ce/4.3.0.1/d475e3bfe98d2a741a7bbb50f5f76345d778c9b8/etc/fill_help_tables-ob.sql;


obclient [(none)]> source /home/admin/.obd/repository/oceanbase-ce/4.3.0.1/d475e3bfe98d2a741a7bbb50f5f76345d778c9b8/etc/fill_help_tables-ob.sql;

......

obclient [mysql]> HELP 'contents';
You asked for help about help category: "Contents"
For more information, type 'help <item>', where <item> is one of the following
categories:
   Data Types
   Utility
   Administration
   Compound Statements
   Prepared Statements
   Transaction Statements
   Data Manipulation
   Data Definition
   Escape character
   Operator
   Functions


obclient [mysql]> help Administration
You asked for help about help category: "Administration"
For more information, type 'help <item>', where <item> is one of the following
topics:
   CREATE RESOURCE UNIT
   DROP RESOURCE UNIT
   CREATE RESOURCE POOL
   ALTER RESOURCE POOL
   DROP RESOURCE POOL
   CREATE TENANT
   ALTER TENANT
   LOCK/UNLOCK
   DROP TENANT
   CREATE TABLEGROUP
   DROP TABLEGROUP
   ALTER TABLEGROUP
   CREATE USER
   DROP USER
   SET PASSWORD
   RENAME USER
   ALTER USER
   GRANT
   REVOKE
   SET
   ALTER SYSTEM
categories:
   Account Management
   Other Management

obclient [mysql]> help CREATE RESOURCE UNIT
Name: 'CREATE RESOURCE UNIT'
Description:

  语法：

  CREATE RESOURCE UNIT unitname 
     MAX_CPU [=] cpunum, 
     MEMORY_SIZE [=] memsize, 
     MAX_IOPS [=] iopsnum, 
     LOG_DISK_SIZE [=] disksize, 
     [MIN_CPU [=] cpunum,] 
     [MIN_IOPS [=] iopsnum];

  创建资源单元时，MAX_CPU、MEMORY_SIZE、MAX_IOPS必须指定。MIN_CPU、MIN_IOPS可选，默认值和MAX_CPU、MEMORY_SIZE、MAX_IOPS保持一致。LOG_DISK_SIZE可选，默认值和MEMORY_SIZE保持一致


obclient [mysql]>
#4

提个建议，help contents 提示 内容太少，尽可能丰富点
比如： create resource pool

obclient [test]> help 'create resource pool'
Name: 'CREATE RESOURCE POOL'
Description:

  语法：

  CREATE RESOURCE POOL poolname 
   UNIT [=] unitname, 
   UNIT_NUM [=] unitnum, 
   ZONE_LIST [=] ('zone' [, 'zone'...]);


obclient [test]> help 'create tenant'
Name: 'CREATE TENANT'
Description:

  语法：

  CREATE TENANT [IF NOT EXISTS] tenantname 
     [tenant_characteristic_list]
     [tenant_variables_list]

  tenant_characteristic_list: 
    tenant_characteristic [, tenant_characteristic...]

  tenant_characteristic: 
    COMMENT 'string' 
    | {CHARACTER SET | CHARSET} [=] value 
    | REPLICA_NUM [=] num 
    | ZONE_LIST [=] (zone [, zoneu2026]) 
    | PRIMARY_ZONE [=] zone
    | RESOURCE_POOL_LIST [=] (poolname) 
    | {READ ONLY | READ WRITE} 

  tenant_variables_list: 
    SET sys_variables_list 
    | SET VARIABLES sys_variables_list 
    | VARIABLES sys_variables_list 

  sys_variables_list: 
    sys_variables [, sys_variables...] 

  sys_variables: 
    sys_variable_name = expr 
  
  如果要创建的租户名已存在，并且没有指定IF NOT EXISTS，则会出现错误。

  租户名的合法性和变量名一致，最长64个字节，字符只能有大小写英文字母，数字和下划线，而且必须以字母或下划线开头，并且不能OceanBase的关键字。

  只有用root用户连接根到租户（root@ROOT）才能执行CREATE TENANT去创建租户。

  说明：RESOURCE_POOL_LIST为创建租户时的必填项。