View configurations of a resource unit

Before you create a resource pool, you must check the resource unit configurations to select an appropriate resource template.

View resource unit configurations in an internal table

A resource unit can be considered as a template for using server resources. You can query the internal table for the configurations of existing resource unit in the current cluster.

1. Log on to the sys tenant as the root user.

2. Execute the following statement to query all resource unit configurations in the cluster:

   obclient> SELECT * FROM oceanbase.__all_unit_config;
   +----------------------------+----------------------------+----------------+-----------------------------+---------+---------+-------------+-------------+----------+----------+---------------+---------------------+
   | gmt_create                 | gmt_modified               | unit_config_id | name                        | max_cpu | min_cpu | max_memory  | min_memory  | max_iops | min_iops | max_disk_size | max_session_num     |
   +----------------------------+----------------------------+----------------+-----------------------------+---------+---------+-------------+-------------+----------+----------+---------------+---------------------+
   | 2021-11-11 14:29:24.847092 | 2021-11-11 14:29:24.847092 |              1 | sys_unit_config             |       5 |     2.5 | 16106127360 | 12884901888 |    10000 |     5000 |  179593805824 | 9223372036854775807 |
   | 2021-11-11 14:43:01.449090 | 2021-11-11 14:43:01.449090 |           1002 | config_Oracle_zone1_S1_rhf  |     1.5 |     1.5 |  6442450944 |  6442450944 |     1250 |     1250 |  536870912000 |
   375 |
   | 2021-11-15 11:25:48.371781 | 2021-11-15 11:25:48.371781 |           1003 | config_MySQL_zone1_S1_zlz   |     1.5 |     1.5 |  6442450944 |  6442450944 |     1250 |     1250 |  536870912000 |
   375 |
   | 2021-11-15 11:26:38.979746 | 2021-11-15 11:26:38.979746 |           1004 | config_MySQL1_zone1_S1_cey  |     1.5 |     1.5 |  6442450944 |  6442450944 |     1250 |     1250 |  536870912000 |
   375 |
   | 2021-11-15 11:27:09.347510 | 2021-11-15 11:27:09.347510 |           1005 | config_MySQL2_zone1_S1_ydf  |     1.5 |     1.5 |  6442450944 |  6442450944 |     1250 |     1250 |  536870912000 |
   375 |
   | 2021-11-15 11:27:42.442706 | 2021-11-15 11:27:42.442706 |           1006 | config_Oracle1_zone1_S1_dfl |     1.5 |     1.5 |  6442450944 |  6442450944 |     1250 |     1250 |  536870912000 |
   375 |
   | 2021-11-17 14:29:09.458317 | 2021-11-17 14:29:09.458317 |           1022 | unit1                       |       5 |       5 | 38654705664 | 34359738368 |      128 |      128 | 2199023255552 |
    64 |
   +----------------------------+----------------------------+----------------+-----------------------------+---------+---------+-------------+-------------+----------+----------+---------------+---------------------+
   7 rows in set
   

   The following table describes the fields in the query result.

   Field	Description
   gmt_create	The time when the resource unit was created.
   gmt_modified	The time when the resource unit was last modified.
   unit_config_id	The ID of the resource unit.
   name	The name of the resource unit.
   max_cpu	The maximum number of CPU cores that can be provided by the resource unit.
   min_cpu	The minimum number of CPU cores that can be provided by the resource unit.
   max_memory	The maximum size of memory that can be provided by the resource unit. Unit: bytes.
   min_memory	The minimum size of memory that can be provided by the resource unit. Unit: bytes.
   max_iops	The maximum IOPS that can be provided by the resource unit. Unit: bytes.
   min_iops	The minimum IOPS that can be provided by the resource unit. Unit: bytes.
   max_disk_size	The maximum size of the data disk that can be provided by the resource unit. Unit: bytes.
   max_session_num	The maximum number of sessions that can be provided by the resource unit.

View resource unit configurations in OCP

You can define unit specifications for resource units and view all unit specifications in the cluster by using OceanBase Cloud Platform (OCP), including the built-in and custom unit specifications.

1. Log on to the OCP console.

2. In the left-side navigation pane, click Tenants.

3. On the page that appears, click Unit Specification Management in the upper-right corner. The Unit Specification Management page appears.

4. View the unit list.

   The unit list contains the following columns: Type Name, Minimum CPU Cores, Maximum CPU Cores, Minimum Memory (GB), Maximum Memory (GB), Unit Types, and Actions.