The CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES stored procedure calculates the amount of physical resources required to accommodate the specified types and quantities of logical resources in a tenant.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_OB_LIMIT_CALCULATOR.CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES(args IN VARCHAR);
Parameters
In the syntax, the value of args is a string similar to the following ones:
'ls: 1, tablet: 20000';
'ls: 10';
'tablet: 20000'
| Parameter | Description |
|---|---|
| ls | The number of logical streams (LSs) required. |
| tablet | The number of tablets required. |
Examples
Run the following command to calculate the amount of required physical resources:
obclient> CALL DBMS_OB_LIMIT_CALCULATOR.CALCULATE_MIN_PHY_RES_NEEDED_BY_LOGIC_RES("LS: 15, TABLET:40000");
+------------------------+-------------+
| PHYSICAL_RESOURCE_NAME | MIN_VALUE |
+------------------------+-------------+
| MEMSTORE | 0 |
| MEMORY | 4194304000 |
| DATA_DISK | 0 |
| CLOG_DISK | 10737418240 |
| CPU | 0 |
+------------------------+-------------+
5 rows in set (0.003 sec)