obclient(root@sys)[oceanbase]> SELECT SVR_IP, CONCAT(ROUND(MEMORY_LIMIT/1024/1024/1024,1),‘GB’) AS MEM_LIMIT, CONCAT(ROUND(MEM_CAPACITY/1024/1024/1024,1),‘GB’) AS MEM_CAPACITY, CONCAT(ROUND(MEM_ASSIGNED/1024/1024/1024,1),‘GB’) AS MEM_ASSIGNED, CONCAT(ROUND((MEM_CAPACITY-MEM_ASSIGNED)/1024/1024/1024,1),‘GB’) AS MEM_UNASSIGNED FROM GV$OB_SERVERS ORDER BY SVR_IP;
±--------------±----------±-------------±-------------±---------------+
| SVR_IP | MEM_LIMIT | MEM_CAPACITY | MEM_ASSIGNED | MEM_UNASSIGNED |
±--------------±----------±-------------±-------------±---------------+
| 192.168.43.31 | 15.0GB | 11.0GB | 3.0GB | 8.0GB |
| 192.168.43.32 | 15.0GB | 11.0GB | 1.0GB | 10.0GB |
| 192.168.43.33 | 15.0GB | 11.0GB | 1.0GB | 10.0GB |
±--------------±----------±-------------±-------------±---------------+
3 rows in set (0.042 sec)
obclient(root@sys)[oceanbase]> SELECT SVR_IP, CPU_CAPACITY_MAX, CPU_ASSIGNED_MAX,
→ CPU_CAPACITY_MAX-CPU_ASSIGNED_MAX AS CPU_UNASSIGNED_MAX,
→ CPU_CAPACITY, CPU_ASSIGNED,
→ CPU_CAPACITY-CPU_ASSIGNED AS CPU_UNASSIGNED FROM GV$OB_SERVERS ORDER BY SVR_IP;
±--------------±-----------------±-----------------±-------------------±-------------±-------------±---------------+
| SVR_IP | CPU_CAPACITY_MAX | CPU_ASSIGNED_MAX | CPU_UNASSIGNED_MAX | CPU_CAPACITY | CPU_ASSIGNED | CPU_UNASSIGNED |
±--------------±-----------------±-----------------±-------------------±-------------±-------------±---------------+
| 192.168.43.31 | 9 | 4.5 | 4.5 | 6 | 3.5 | 2.5 |
| 192.168.43.32 | 9 | 3 | 6 | 6 | 3 | 3 |
| 192.168.43.33 | 9 | 3 | 6 | 6 | 3 | 3 |
±--------------±-----------------±-----------------±-------------------±-------------±-------------±---------------+
obclient(root@sys)[oceanbase]> CREATE RESOURCE UNIT u1
→ MAX_CPU 1.5,
→ MIN_CPU 1.5,
→ MEMORY_SIZE ‘4G’ ;
Query OK, 0 rows affected (0.032 sec)
obclient(root@sys)[oceanbase]>
obclient(root@sys)[oceanbase]> CREATE RESOURCE POOL rp1
→ UNIT ‘u1’,
→ UNIT_NUM 1,
→ ZONE_LIST (‘zone1’, ‘zone2’, ‘zone3’);
Query OK, 0 rows affected (0.064 sec)
obclient(root@sys)[oceanbase]>
obclient(root@sys)[oceanbase]>
obclient(root@sys)[oceanbase]>
obclient(root@sys)[oceanbase]> SELECT RESOURCE_POOL_ID,NAME,TENANT_ID,UNIT_COUNT,UNIT_CONFIG_ID,ZONE_LIST
→ FROM DBA_OB_RESOURCE_POOLS;
±-----------------±-------------------±----------±-----------±---------------±------------------+
| RESOURCE_POOL_ID | NAME | TENANT_ID | UNIT_COUNT | UNIT_CONFIG_ID | ZONE_LIST |
±-----------------±-------------------±----------±-----------±---------------±------------------+
| 1010 | pool_sys_zone1_cot | 1 | 1 | 1010 | zone1 |
| 1011 | pool_sys_zone2_lom | 1 | 1 | 1 | zone2 |
| 1012 | pool_sys_zone3_mjb | 1 | 1 | 1 | zone3 |
| 1016 | rp1 | NULL | 1 | 1014 | zone1;zone2;zone3 |
±-----------------±-------------------±----------±-----------±---------------±------------------+
4 rows in set (0.012 sec)
obclient(root@sys)[oceanbase]>
obclient(root@sys)[oceanbase]>
obclient(root@sys)[oceanbase]> CREATE TENANT obmysql RESOURCE_POOL_LIST=(‘rp1’) SET ob_tcp_invited_nodes=’%’;
ERROR 4550 (HY000): rootservice is shutdown
obclient(root@sys)[oceanbase]>
obclient(root@sys)[oceanbase]>