1.OB租户管理
--暂不支持普通租户查看视图 oceanbase.DBA_OB_TENANTS
系统租户查看
SELECT * FROM oceanbase.DBA_OB_TENANTS;
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANTS;
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+
| TENANT_ID | TENANT_NAME | TENANT_TYPE | CREATE_TIME | MODIFY_TIME | PRIMARY_ZONE | LOCALITY | PREVIOUS_LOCALITY | COMPATIBILITY_MODE | STATUS | IN_RECYCLEBIN | LOCKED |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+
| 1 | sys | SYS | 2023-03-02 17:02:40.612243 | 2023-03-02 17:02:40.612243 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO |
| 1005 | META$1006 | META | 2023-03-03 22:09:53.496864 | 2023-03-03 22:10:09.629495 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO |
| 1006 | tent_t1 | USER | 2023-03-03 22:09:53.496864 | 2023-03-03 22:10:09.652489 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO |
| 1007 | META$1008 | META | 2023-03-03 22:15:14.071437 | 2023-03-03 22:15:34.929433 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO |
| 1008 | tent_t2 | USER | 2023-03-03 22:15:14.071437 | 2023-03-03 22:15:34.954948 | RANDOM | FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3 | NULL | MYSQL | NORMAL | NO | NO |
+-----------+-------------+-------------+----------------------------+----------------------------+--------------+---------------------------------------------+-------------------+--------------------+--------+---------------+--------+
5 rows in set (0.006 sec)
2.查看当前租户
obclient [oceanbase]> SHOW TENANT;
+---------------------+
| Current_tenant_name |
+---------------------+
| sys |
+---------------------+
1 row in set (0.007 sec)
3.查看当前有效租户。
obclient [oceanbase]> SELECT effective_tenant();
+--------------------+
| effective_tenant() |
+--------------------+
| sys |
+--------------------+
1 row in set (0.006 sec)
4.查看当前租户的状态。
obclient [oceanbase]> SHOW TENANT STATUS;
+--------+------------+
| Tenant | Status |
+--------+------------+
| sys | read write |
+--------+------------+
1 row in set (0.040 sec)
5.查看当前租户的ID;
obclient [oceanbase]> SELECT effective_tenant_id();
+-----------------------+
| effective_tenant_id() |
+-----------------------+
| 1 |
+-----------------------+
1 row in set (0.002 sec)
6.租户修改
--修改租户。
ALTER TENANT tenant1 resource_pool_list=('pool2');
ALTER TENANT tenant1 primary_zone='zone2';
ALTER TENANT tenant1 locality="F@B_1,F@B_2,F@B_3,F@B_4"
--重命名普通租户。使用 root 用户登录数据库的 sys 租户
ALTER TENANT tenant1 RENAME GLOBAL_NAME TO tenant2;
--删除租户。
DROP TENANT tenant_name [FORCE];
DROP TENANT tenant_name PURGE;
7.租户内存管理
memory_limit 为 0,表示使用百分比的配置方式,故以 memory_limit_percentage 为准,OceanBase 数据库内存上限为 100 GB*80%=80 GB。
memory_limit 为 90 GB,表示使用绝对值的配置方式,故以 memory_limit 为准,OceanBase 数据库内存上限为 90 GB。
有 memory_limit,先看这个,没有这个再看百分比。
8.内存查看
SELECT * FROM oceanbase.gv$sysstat WHERE svr_ip like '192.168.1.6%' AND svr_port=2882 AND con_id=1 AND name like '%observer memory%';
obclient [oceanbase]> SELECT * FROM oceanbase.gv$sysstat WHERE svr_ip like '192.168.1.6%' AND svr_port=2882 AND con_id=1 AND name like '%observer memory%';
+--------+--------------+----------+------------+---------------------------+-------+------------+------------+---------+
| CON_ID | SVR_IP | SVR_PORT | STATISTIC# | NAME | CLASS | VALUE | VALUE_TYPE | STAT_ID |
+--------+--------------+----------+------------+---------------------------+-------+------------+------------+---------+
| 1 | 192.168.1.61 | 2882 | 575 | observer memory used size | 64 | 6474272768 | SET_VALUE | 140008 |
| 1 | 192.168.1.61 | 2882 | 576 | observer memory free size | 64 | 20971520 | SET_VALUE | 140009 |
| 1 | 192.168.1.61 | 2882 | 578 | observer memory hold size | 64 | 6495244288 | SET_VALUE | 140011 |
| 1 | 192.168.1.62 | 2882 | 575 | observer memory used size | 64 | 5966286848 | SET_VALUE | 140008 |
| 1 | 192.168.1.62 | 2882 | 576 | observer memory free size | 64 | 16777216 | SET_VALUE | 140009 |
| 1 | 192.168.1.62 | 2882 | 578 | observer memory hold size | 64 | 5983064064 | SET_VALUE | 140011 |
| 1 | 192.168.1.63 | 2882 | 575 | observer memory used size | 64 | 5897080832 | SET_VALUE | 140008 |
| 1 | 192.168.1.63 | 2882 | 576 | observer memory free size | 64 | 4194304 | SET_VALUE | 140009 |
| 1 | 192.168.1.63 | 2882 | 578 | observer memory hold size | 64 | 5901275136 | SET_VALUE | 140011 |
+--------+--------------+----------+------------+---------------------------+-------+------------+------------+---------+
9 rows in set (0.026 sec)
9.各个租户内存使用量。
obclient [oceanbase]> SELECT tenant_id, hold FROM oceanbase.GV$OB_TENANT_MEMORY WHERE svr_ip like '192.168.1.6%' AND svr_port=2882 GROUP BY tenant_id;
+-----------+------------+
| tenant_id | hold |
+-----------+------------+
| 1 | 840495104 |
| 500 | 2871156736 |
| 506 | 27262976 |
| 507 | 12582912 |
| 508 | 41943040 |
| 509 | 12582912 |
| 510 | 12582912 |
| 512 | 33554432 |
| 999 | 12582912 |
| 1003 | 41943040 |
| 1004 | 33554432 |
| 1005 | 595099648 |
| 1006 | 685613056 |
| 1007 | 599273472 |
| 1008 | 664641536 |
+-----------+------------+
15 rows in set (0.022 sec)
10.指定租户的内存使用情况。
SELECT tenant_id, ctx_name, hold FROM oceanbase.GV$OB_MEMORY WHERE svr_ip like '192.168.1.6%'
AND svr_port=2882 AND tenant_id = 1008 ORDER BY ctx_name;
obclient [oceanbase]>
+-----------+--------------------------------+-----------+
| tenant_id | ctx_name | hold |
+-----------+--------------------------------+-----------+
| 1008 | COMPILE_CTX_ID | 0 |
| 1008 | COMPILE_CTX_ID | 0 |
| 1008 | COMPILE_CTX_ID | 0 |
| 1008 | CO_STACK | 0 |
| 1008 | CO_STACK | 68567040 |
| 1008 | CO_STACK | 29936 |
| 1008 | CO_STACK | 0 |
| 1008 | CO_STACK | 66535424 |
| 1008 | CO_STACK | 29040 |
| 1008 | CO_STACK | 0 |
| 1008 | CO_STACK | 29040 |
| 1008 | CO_STACK | 66535424 |
| 1008 | DEFAULT_CTX_ID | 2624 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 15872 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 7968 |
| 1008 | DEFAULT_CTX_ID | 7936 |
| 1008 | DEFAULT_CTX_ID | 5120 |
| 1008 | DEFAULT_CTX_ID | 98062336 |
| 1008 | DEFAULT_CTX_ID | 1920 |
| 1008 | DEFAULT_CTX_ID | 1120 |
| 1008 | DEFAULT_CTX_ID | 1088 |
| 1008 | DEFAULT_CTX_ID | 896 |
| 1008 | DEFAULT_CTX_ID | 624 |
| 1008 | DEFAULT_CTX_ID | 432 |
| 1008 | DEFAULT_CTX_ID | 384 |
| 1008 | DEFAULT_CTX_ID | 160 |
| 1008 | DEFAULT_CTX_ID | 0 |
| 1008 | DEFAULT_CTX_ID | 1589248 |
| 1008 | DEFAULT_CTX_ID | 17170432 |
| 1008 | DEFAULT_CTX_ID | 21626432 |
| 1008 | DEFAULT_CTX_ID | 80019456 |
| 1008 | DEFAULT_CTX_ID | 167854080 |
| 1008 | DEFAULT_CTX_ID | 794624 |
| 1008 | DEFAULT_CTX_ID | 204800 |
| 1008 | DEFAULT_CTX_ID | 212736 |
| 1008 | DEFAULT_CTX_ID | 262144 |
| 1008 | DEFAULT_CTX_ID | 305216 |
| 1008 | DEFAULT_CTX_ID | 375936 |
| 1008 | DEFAULT_CTX_ID | 401408 |
| 1008 | DEFAULT_CTX_ID | 524288 |
| 1008 | DEFAULT_CTX_ID | 788736 |
| 1008 | DEFAULT_CTX_ID | 204800 |
| 1008 | DEFAULT_CTX_ID | 802816 |
| 1008 | DEFAULT_CTX_ID | 933888 |
| 1008 | DEFAULT_CTX_ID | 958464 |
| 1008 | DEFAULT_CTX_ID | 1048576 |
| 1008 | DEFAULT_CTX_ID | 1133008 |
| 1008 | DEFAULT_CTX_ID | 1474560 |
| 1008 | DEFAULT_CTX_ID | 93900800 |
| 1008 | DEFAULT_CTX_ID | 16384 |
| 1008 | DEFAULT_CTX_ID | 188416 |
| 1008 | DEFAULT_CTX_ID | 163840 |
| 1008 | DEFAULT_CTX_ID | 163840 |
| 1008 | DEFAULT_CTX_ID | 139264 |
| 1008 | DEFAULT_CTX_ID | 81920 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 39680 |
| 1008 | DEFAULT_CTX_ID | 32768 |
| 1008 | DEFAULT_CTX_ID | 32512 |
| 1008 | DEFAULT_CTX_ID | 65472 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 15872 |
| 1008 | DEFAULT_CTX_ID | 16256 |
| 1008 | DEFAULT_CTX_ID | 16384 |
| 1008 | DEFAULT_CTX_ID | 32512 |
| 1008 | DEFAULT_CTX_ID | 32768 |
| 1008 | DEFAULT_CTX_ID | 39680 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 81920 |
| 1008 | DEFAULT_CTX_ID | 1920 |
| 1008 | DEFAULT_CTX_ID | 0 |
| 1008 | DEFAULT_CTX_ID | 160 |
| 1008 | DEFAULT_CTX_ID | 384 |
| 1008 | DEFAULT_CTX_ID | 432 |
| 1008 | DEFAULT_CTX_ID | 624 |
| 1008 | DEFAULT_CTX_ID | 848 |
| 1008 | DEFAULT_CTX_ID | 1088 |
| 1008 | DEFAULT_CTX_ID | 1120 |
| 1008 | DEFAULT_CTX_ID | 139264 |
| 1008 | DEFAULT_CTX_ID | 2624 |
| 1008 | DEFAULT_CTX_ID | 5120 |
| 1008 | DEFAULT_CTX_ID | 7936 |
| 1008 | DEFAULT_CTX_ID | 7968 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 1133008 |
| 1008 | DEFAULT_CTX_ID | 1474560 |
| 1008 | DEFAULT_CTX_ID | 1589248 |
| 1008 | DEFAULT_CTX_ID | 1630016 |
| 1008 | DEFAULT_CTX_ID | 2321120 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 1048576 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 5160960 |
| 1008 | DEFAULT_CTX_ID | 5160960 |
| 1008 | DEFAULT_CTX_ID | 6242304 |
| 1008 | DEFAULT_CTX_ID | 8151040 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 384064 |
| 1008 | DEFAULT_CTX_ID | 163840 |
| 1008 | DEFAULT_CTX_ID | 163840 |
| 1008 | DEFAULT_CTX_ID | 188416 |
| 1008 | DEFAULT_CTX_ID | 204800 |
| 1008 | DEFAULT_CTX_ID | 204800 |
| 1008 | DEFAULT_CTX_ID | 212736 |
| 1008 | DEFAULT_CTX_ID | 262144 |
| 1008 | DEFAULT_CTX_ID | 305216 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 401408 |
| 1008 | DEFAULT_CTX_ID | 524288 |
| 1008 | DEFAULT_CTX_ID | 788736 |
| 1008 | DEFAULT_CTX_ID | 794624 |
| 1008 | DEFAULT_CTX_ID | 802816 |
| 1008 | DEFAULT_CTX_ID | 933888 |
| 1008 | DEFAULT_CTX_ID | 958464 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 16256 |
| 1008 | DEFAULT_CTX_ID | 16384 |
| 1008 | DEFAULT_CTX_ID | 31744 |
| 1008 | DEFAULT_CTX_ID | 32512 |
| 1008 | DEFAULT_CTX_ID | 32512 |
| 1008 | DEFAULT_CTX_ID | 32768 |
| 1008 | DEFAULT_CTX_ID | 32768 |
| 1008 | DEFAULT_CTX_ID | 39680 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 15872 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 65536 |
| 1008 | DEFAULT_CTX_ID | 81920 |
| 1008 | DEFAULT_CTX_ID | 139264 |
| 1008 | DEFAULT_CTX_ID | 163840 |
| 1008 | DEFAULT_CTX_ID | 2624 |
| 1008 | DEFAULT_CTX_ID | 0 |
| 1008 | DEFAULT_CTX_ID | 160 |
| 1008 | DEFAULT_CTX_ID | 400 |
| 1008 | DEFAULT_CTX_ID | 432 |
| 1008 | DEFAULT_CTX_ID | 624 |
| 1008 | DEFAULT_CTX_ID | 800 |
| 1008 | DEFAULT_CTX_ID | 1088 |
| 1008 | DEFAULT_CTX_ID | 1120 |
| 1008 | DEFAULT_CTX_ID | 1920 |
| 1008 | DEFAULT_CTX_ID | 163840 |
| 1008 | DEFAULT_CTX_ID | 5120 |
| 1008 | DEFAULT_CTX_ID | 7968 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8128 |
| 1008 | DEFAULT_CTX_ID | 8323072 |
| 1008 | DEFAULT_CTX_ID | 2321120 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 5160960 |
| 1008 | DEFAULT_CTX_ID | 5160960 |
| 1008 | DEFAULT_CTX_ID | 8151040 |
| 1008 | DEFAULT_CTX_ID | 1630016 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 17170432 |
| 1008 | DEFAULT_CTX_ID | 21626432 |
| 1008 | DEFAULT_CTX_ID | 80019456 |
| 1008 | DEFAULT_CTX_ID | 167854080 |
| 1008 | DEFAULT_CTX_ID | 788736 |
| 1008 | DEFAULT_CTX_ID | 188416 |
| 1008 | DEFAULT_CTX_ID | 204800 |
| 1008 | DEFAULT_CTX_ID | 204800 |
| 1008 | DEFAULT_CTX_ID | 212688 |
| 1008 | DEFAULT_CTX_ID | 220672 |
| 1008 | DEFAULT_CTX_ID | 262144 |
| 1008 | DEFAULT_CTX_ID | 305216 |
| 1008 | DEFAULT_CTX_ID | 384064 |
| 1008 | DEFAULT_CTX_ID | 401408 |
| 1008 | DEFAULT_CTX_ID | 2321120 |
| 1008 | DEFAULT_CTX_ID | 794624 |
| 1008 | DEFAULT_CTX_ID | 802816 |
| 1008 | DEFAULT_CTX_ID | 933888 |
| 1008 | DEFAULT_CTX_ID | 958464 |
| 1008 | DEFAULT_CTX_ID | 1048576 |
| 1008 | DEFAULT_CTX_ID | 1165520 |
| 1008 | DEFAULT_CTX_ID | 1474560 |
| 1008 | DEFAULT_CTX_ID | 1589248 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 167854080 |
| 1008 | DEFAULT_CTX_ID | 95981568 |
| 1008 | DEFAULT_CTX_ID | 80019456 |
| 1008 | DEFAULT_CTX_ID | 21626432 |
| 1008 | DEFAULT_CTX_ID | 17170432 |
| 1008 | DEFAULT_CTX_ID | 1630016 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 8540160 |
| 1008 | DEFAULT_CTX_ID | 8151040 |
| 1008 | DEFAULT_CTX_ID | 6242304 |
| 1008 | DEFAULT_CTX_ID | 5160960 |
| 1008 | DEFAULT_CTX_ID | 5160960 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | DEFAULT_CTX_ID | 2580480 |
| 1008 | ELECTION_CTX_ID | 0 |
| 1008 | ELECTION_CTX_ID | 0 |
| 1008 | ELECTION_CTX_ID | 0 |
| 1008 | EXECUTE_CTX_ID | 0 |
| 1008 | EXECUTE_CTX_ID | 0 |
| 1008 | EXECUTE_CTX_ID | 0 |
| 1008 | GLIBC | 0 |
| 1008 | GLIBC | 0 |
| 1008 | GLIBC | 0 |
| 1008 | HASHJOIN_CTX_ID | 0 |
| 1008 | HASHJOIN_CTX_ID | 0 |
| 1008 | HASHJOIN_CTX_ID | 0 |
| 1008 | KVSTORE_CACHE_ID | 16777216 |
| 1008 | KVSTORE_CACHE_ID | 8388608 |
| 1008 | KVSTORE_CACHE_ID | 8388608 |
| 1008 | LIBEASY | 0 |
| 1008 | LIBEASY | 0 |
| 1008 | LIBEASY | 0 |
| 1008 | LOB_CTX_ID | 65536 |
| 1008 | LOB_CTX_ID | 0 |
| 1008 | LOB_CTX_ID | 0 |
| 1008 | LOB_CTX_ID | 65536 |
| 1008 | LOB_CTX_ID | 65536 |
| 1008 | LOB_CTX_ID | 0 |
| 1008 | LOGGER_CTX_ID | 0 |
| 1008 | LOGGER_CTX_ID | 0 |
| 1008 | LOGGER_CTX_ID | 0 |
| 1008 | LOG_INDEX_CTX_ID | 0 |
| 1008 | LOG_INDEX_CTX_ID | 0 |
| 1008 | LOG_INDEX_CTX_ID | 0 |
| 1008 | MEMSTORE_CTX_ID | 33292288 |
| 1008 | MEMSTORE_CTX_ID | 33292288 |
| 1008 | MEMSTORE_CTX_ID | 0 |
| 1008 | MEMSTORE_CTX_ID | 0 |
| 1008 | MEMSTORE_CTX_ID | 6242304 |
| 1008 | MEMSTORE_CTX_ID | 0 |
| 1008 | MEMSTORE_OBJECT_CTX_ID | 0 |
| 1008 | MEMSTORE_OBJECT_CTX_ID | 0 |
| 1008 | MEMSTORE_OBJECT_CTX_ID | 0 |
| 1008 | META_OBJ_CTX_ID | 1179648 |
| 1008 | META_OBJ_CTX_ID | 2408448 |
| 1008 | META_OBJ_CTX_ID | 2408448 |
| 1008 | META_OBJ_CTX_ID | 2178304 |
| 1008 | META_OBJ_CTX_ID | 1376256 |
| 1008 | META_OBJ_CTX_ID | 2194560 |
| 1008 | META_OBJ_CTX_ID | 0 |
| 1008 | META_OBJ_CTX_ID | 2408448 |
| 1008 | META_OBJ_CTX_ID | 2202688 |
| 1008 | META_OBJ_CTX_ID | 0 |
| 1008 | META_OBJ_CTX_ID | 1179648 |
| 1008 | META_OBJ_CTX_ID | 1376256 |
| 1008 | META_OBJ_CTX_ID | 1179648 |
| 1008 | META_OBJ_CTX_ID | 1376256 |
| 1008 | META_OBJ_CTX_ID | 0 |
| 1008 | OB_TRANS_LOCAL_TASK_ID | 0 |
| 1008 | OB_TRANS_LOCAL_TASK_ID | 0 |
| 1008 | OB_TRANS_LOCAL_TASK_ID | 0 |
| 1008 | PARTITION_CTX_ID | 0 |
| 1008 | PARTITION_CTX_ID | 0 |
| 1008 | PARTITION_CTX_ID | 0 |
| 1008 | PARTITION_CTX_MGR_CTX_ID | 0 |
| 1008 | PARTITION_CTX_MGR_CTX_ID | 0 |
| 1008 | PARTITION_CTX_MGR_CTX_ID | 0 |
| 1008 | PARTITION_LOG_SERVICE_CTX_ID | 0 |
| 1008 | PARTITION_LOG_SERVICE_CTX_ID | 0 |
| 1008 | PARTITION_LOG_SERVICE_CTX_ID | 0 |
| 1008 | PARTITION_STORAGE_CTX_ID | 0 |
| 1008 | PARTITION_STORAGE_CTX_ID | 0 |
| 1008 | PARTITION_STORAGE_CTX_ID | 0 |
| 1008 | PHY_PLAN_CTX_ID | 0 |
| 1008 | PHY_PLAN_CTX_ID | 0 |
| 1008 | PHY_PLAN_CTX_ID | 0 |
| 1008 | PLAN_CACHE_CTX_ID | 0 |
| 1008 | PLAN_CACHE_CTX_ID | 1441024 |
| 1008 | PLAN_CACHE_CTX_ID | 18689984 |
| 1008 | PLAN_CACHE_CTX_ID | 6127040 |
| 1008 | PLAN_CACHE_CTX_ID | 431104 |
| 1008 | PLAN_CACHE_CTX_ID | 0 |
| 1008 | PLAN_CACHE_CTX_ID | 431104 |
| 1008 | PLAN_CACHE_CTX_ID | 6127040 |
| 1008 | PLAN_CACHE_CTX_ID | 0 |
| 1008 | PS_CACHE_CTX_ID | 0 |
| 1008 | PS_CACHE_CTX_ID | 0 |
| 1008 | PS_CACHE_CTX_ID | 0 |
| 1008 | REPLAY_STATUS_CTX_ID | 0 |
| 1008 | REPLAY_STATUS_CTX_ID | 0 |
| 1008 | REPLAY_STATUS_CTX_ID | 0 |
| 1008 | REQ_MANAGER_CTX_ID | 0 |
| 1008 | REQ_MANAGER_CTX_ID | 0 |
| 1008 | REQ_MANAGER_CTX_ID | 0 |
| 1008 | SORT_CTX_ID | 0 |
| 1008 | SORT_CTX_ID | 0 |
| 1008 | SORT_CTX_ID | 0 |
| 1008 | SSSTORE_CTX_ID | 0 |
| 1008 | SSSTORE_CTX_ID | 0 |
| 1008 | SSSTORE_CTX_ID | 0 |
| 1008 | SSTABLE_CTX_ID | 0 |
| 1008 | SSTABLE_CTX_ID | 0 |
| 1008 | SSTABLE_CTX_ID | 0 |
| 1008 | STORAGE_LONG_TERM_META_CTX_ID | 0 |
| 1008 | STORAGE_LONG_TERM_META_CTX_ID | 0 |
| 1008 | STORAGE_LONG_TERM_META_CTX_ID | 0 |
| 1008 | STORAGE_SHORT_TERM_META_CTX_ID | 0 |
| 1008 | STORAGE_SHORT_TERM_META_CTX_ID | 0 |
| 1008 | STORAGE_SHORT_TERM_META_CTX_ID | 0 |
| 1008 | TRANS_COORD_CTX_ID | 0 |
| 1008 | TRANS_COORD_CTX_ID | 0 |
| 1008 | TRANS_COORD_CTX_ID | 0 |
| 1008 | TRANS_CTX_MGR_ID | 0 |
| 1008 | TRANS_CTX_MGR_ID | 1605632 |
| 1008 | TRANS_CTX_MGR_ID | 0 |
| 1008 | TRANS_CTX_MGR_ID | 0 |
| 1008 | TRANS_CTX_MGR_ID | 1605632 |
| 1008 | TRANS_CTX_MGR_ID | 1605632 |
| 1008 | TRANS_PART_CTX_ID | 0 |
| 1008 | TRANS_PART_CTX_ID | 0 |
| 1008 | TRANS_PART_CTX_ID | 0 |
| 1008 | TRANS_SCHE_CTX_ID | 0 |
| 1008 | TRANS_SCHE_CTX_ID | 0 |
| 1008 | TRANS_SCHE_CTX_ID | 0 |
| 1008 | TX_CALLBACK_CTX_ID | 0 |
| 1008 | TX_CALLBACK_CTX_ID | 325120 |
| 1008 | TX_CALLBACK_CTX_ID | 260096 |
| 1008 | TX_CALLBACK_CTX_ID | 0 |
| 1008 | TX_CALLBACK_CTX_ID | 284480 |
| 1008 | TX_CALLBACK_CTX_ID | 0 |
| 1008 | WORK_AREA | 0 |
| 1008 | WORK_AREA | 0 |
| 1008 | WORK_AREA | 0 |
+-----------+--------------------------------+-----------+
366 rows in set (0.017 sec)
11.内存模块中内存使用情况
SELECT * FROM oceanbase.GV$OB_MEMORY WHERE svr_ip like '192.168.1.6%'
AND svr_port=2882 AND tenant_id = 1008 ORDER BY hold desc limit 10;
obclient [oceanbase]>
+-----------+--------------+----------+----------------+-----------------+-------+-----------+-----------+
| TENANT_ID | SVR_IP | SVR_PORT | CTX_NAME | MOD_NAME | COUNT | HOLD | USED |
+-----------+--------------+----------+----------------+-----------------+-------+-----------+-----------+
| 1008 | 192.168.1.62 | 2882 | DEFAULT_CTX_ID | LogGroupBuffer | 4 | 167854080 | 167772160 |
| 1008 | 192.168.1.61 | 2882 | DEFAULT_CTX_ID | LogGroupBuffer | 4 | 167854080 | 167772160 |
| 1008 | 192.168.1.63 | 2882 | DEFAULT_CTX_ID | LogGroupBuffer | 4 | 167854080 | 167772160 |
| 1008 | 192.168.1.63 | 2882 | DEFAULT_CTX_ID | IoControl | 36 | 98062336 | 98006304 |
| 1008 | 192.168.1.62 | 2882 | DEFAULT_CTX_ID | IoControl | 35 | 95981568 | 95926560 |
| 1008 | 192.168.1.61 | 2882 | DEFAULT_CTX_ID | IoControl | 34 | 93900800 | 93846816 |
| 1008 | 192.168.1.63 | 2882 | DEFAULT_CTX_ID | MysqlRequesReco | 1 | 80019456 | 80000000 |
| 1008 | 192.168.1.62 | 2882 | DEFAULT_CTX_ID | MysqlRequesReco | 1 | 80019456 | 80000000 |
| 1008 | 192.168.1.61 | 2882 | DEFAULT_CTX_ID | MysqlRequesReco | 1 | 80019456 | 80000000 |
| 1008 | 192.168.1.61 | 2882 | CO_STACK | CoStack | 135 | 68567040 | 68436360 |
+-----------+--------------+----------+----------------+-----------------+-------+-----------+-----------+
10 rows in set (0.018 sec)
12.查询 OBServer 总内存
su - admin
cd ~/oceanbase-ce/log
问题一:超过租户内存限制怎么办?
ERROR 4030 (HY000): OB-4030:Over tenant memory limits。
MySQL [sjzt]> SELECT /*+ READ_CONSISTENCY(WEAK),query_timeout(100000000) */ TENANT_ID,SVR_IP,
round(ACTIVE_SPAN/1024/1024/1024,2) ACTIVE_GB,
round(MEMSTORE_USED/1024/1024/1024,2) TOTAL_GB,
round(FREEZE_TRIGGER/1024/1024/1024,2) FREEZE_TRIGGER_GB,
round(MEMSTORE_USED/FREEZE_TRIGGER*100,2) percent_trigger,
round(MEMSTORE_LIMIT/1024/1024/1024,2) MEM_LIMIT_GB
FROM oceanbase.GV$OB_MEMSTORE
WHERE tenant_id >1000 OR TENANT_ID=1
ORDER BY tenant_id,TOTAL_GB DESC;
+-----------+--------------+-----------+----------+-------------------+-----------------+--------------+
| TENANT_ID | SVR_IP | ACTIVE_GB | TOTAL_GB | FREEZE_TRIGGER_GB | percent_trigger | MEM_LIMIT_GB |
+-----------+--------------+-----------+----------+-------------------+-----------------+--------------+
| 1006 | 192.168.1.61 | 0.03 | 0.03 | 0.20 | 15.50 | 1.00 |
| 1006 | 192.168.1.62 | 0.03 | 0.03 | 0.20 | 15.50 | 1.00 |
| 1006 | 192.168.1.63 | 0.03 | 0.03 | 0.20 | 15.50 | 1.00 |
+-----------+--------------+-----------+----------+-------------------+-----------------+--------------+
3 rows in set (0.02 sec)
内存模块超限的判断标准是 module_sum > (租户 memory_size - 租户 MemStore)。
模块内存超限,可能需要先调整单独模块的内存,例如,调整 ob_sql_work_area_percentage 的值,
如果租户内存过小,也需要增加租户内存。
MySQL [sjzt]> SELECT tenant_id,svr_ip,hold module_sum
FROM oceanbase.GV$OB_MEMORY
WHERE tenant_id>1000 AND hold<>0
AND ctx_name NOT IN ( 'OB_KVSTORE_CACHE','OB_MEMSTORE')
GROUP BY tenant_id,svr_ip;
+-----------+--------------+------------+
| tenant_id | svr_ip | module_sum |
+-----------+--------------+------------+
| 1006 | 192.168.1.61 | 167854080 |
| 1006 | 192.168.1.62 | 167854080 |
| 1006 | 192.168.1.63 | 167854080 |
+-----------+--------------+------------+
3 rows in set (0.02 sec)