OceanBase查看内存的使用信息--视图查询

视图查询

查询 OBServer 总内存

在 sys 租户下，通过查询 oceanbase.gv$sysstat 视图可以查看指定机器的内存占用，示例如下：

obclient> SELECT * FROM oceanbase.gv$sysstat WHERE svr_ip = 'xx.xx.xx.xx' 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 |   xx.xx.xx.xx  |     2882 |        568 | observer memory used size |    64 | 12735815680 | SET_VALUE  |  140008 |
|      1 |   xx.xx.xx.xx  |     2882 |        569 | observer memory free size |    64 |   224395264 | SET_VALUE  |  140009 |
|      1 |   xx.xx.xx.xx  |     2882 |        571 | observer memory hold size |    64 | 12960210944 | SET_VALUE  |  140011 |
+--------+----------------+----------+------------+---------------------------+-------+-------------+------------+---------+
3 rows in set

查看各个租户内存使用总量

在 sys 租户下，通过查询 oceanbase.GV$OB_TENANT_MEMORY 视图可以查看所有租户的内存使用总量。

obclient> SELECT tenant_id, hold FROM oceanbase.GV$OB_TENANT_MEMORY WHERE svr_ip = 'xx.xx.xx.xx' AND svr_port=2882  GROUP BY tenant_id;
+-----------+------------+
| tenant_id | hold       |
+-----------+------------+
|         1 | 1308491776 |
|        21 |          0 |
|       500 | 8969994240 |
|       506 |    2097152 |
|       507 |    2097152 |
|       508 |   18874368 |
|       509 |    2097152 |
|       510 |    2097152 |
|       512 |    2097152 |
|       999 |    2097152 |
|      1001 |  524156928 |
|      1002 |  593408000 |
|      1003 |  522059776 |
|      1004 |  771678208 |
+-----------+------------+
14 rows in set

查看指定租户的内存使用详情

在 sys 租户下，通过查询 oceanbase.GV$OB_MEMORY 视图，可以查看指定租户的内存使用详情。

obclient> SELECT tenant_id, context, hold FROM oceanbase.GV$OB_MEMORY WHERE svr_ip = 'xx.xx.xx.xx' AND svr_port=2882 AND tenant_id = 1002 GROUP BY context;
+-----------+-----------------+-----------+
| tenant_id | context         | hold      |
+-----------+-----------------+-----------+
|      1002 | APPLY_STATUS    |      8128 |
|      1002 | CACHE_MAP_NODE  |  16646144 |
|      1002 | ClogGe          |    311296 |
|      1002 | ColUsagHashMap  |    212736 |
|      1002 | DDLKvMgrObj     |    524288 |
|      1002 | DeadLock        |      8128 |
|      1002 | DmlStatMap      |    212688 |
|      1002 | FlushLog        |     65536 |
|      1002 | FlushMeta       |      8128 |
|      1002 | GtsTaskQueue    |    286720 |
|      1002 | HashBuckLCSta   |   1589248 |
|      1002 | HashBuckPlanCac |    794624 |
|      1002 | HashBuckPsCache |   1187840 |
|      1002 | HashBuckPsInfo  |   1187840 |
|      1002 | HashNode        |      7968 |
|      1002 | HashNodeLCSta   |    111104 |
|      1002 | HashNodePlanCac |     55552 |
|      1002 | HashNodePsCache |      7968 |
|      1002 | HashNodePsInfo  |      7936 |
|      1002 | IdxBlkTreePath  |     89280 |
|      1002 | LobAllocator    |     65536 |
|      1002 | LockMemObj      |     65536 |
|      1002 | LockWaitMgr     |      8128 |
|      1002 | LogApplyStatus  |     13568 |
|      1002 | LogGroupBuffer  |  83927040 |
|      1002 | LogReplayStatus |     32768 |
|      1002 | LOG_HASH_MAP    |      1120 |
|      1002 | LSMap           |   4249664 |
|      1002 | LSSvr           |    269248 |
|      1002 | MatchOffsetMap  |     16256 |
|      1002 | Memstore        |  64503808 |
|      1002 | MemtableCallbac |    260096 |
|      1002 | MemTblMgrObj    |    393216 |
|      1002 | MemTblObj       |   1048576 |
|      1002 | MetaAllocator   |  14385792 |
|      1002 | MysqlRequesReco |  86261760 |
|      1002 | OmtTenant       |  10674448 |
|      1002 | PartTranCtxMgr  |    802816 |
|      1002 | PlanBaselineMgr |        96 |
|      1002 | PoolFreeList    |   5250880 |
|      1002 | QueryAllocator  |     16256 |
|      1002 | REPLAY_STATUS   |      8128 |
|      1002 | SqlDtl          |   3907584 |
|      1002 | SqlMemMgr       |     24272 |
|      1002 | SqlPhyPlan      | 143297472 |
|      1002 | SqlPhyPlObj     |   1099840 |
|      1002 | SqlPlanCache    |   7868160 |
|      1002 | SqlPlanMon      |   5021696 |
|      1002 | SqlPsCache      |      4144 |
|      1002 | SSTblObj        |   2097152 |
|      1002 | TabletObj       |   1638400 |
|      1002 | thread_factor   |     32768 |
|      1002 | TxCtxMemObj     |     65536 |
|      1002 | TxDataMemObj    |     65536 |
|      1002 | TX_DATA_TABLE   |   1815104 |
+-----------+-----------------+-----------+
55 rows in set

查看某个内存模块中内存的使用详情

在 sys 租户下，通过查询 oceanbase.GV$OB_MEMORY，可以查看某个内存模块中内存的使用详情。也可以指定机器、租户等信息来查询。

obclient> SELECT * FROM oceanbase.GV$OB_MEMORY WHERE svr_ip = 'xx.xx.xx.xx' AND svr_port=2882 AND tenant_id = 1002 ORDER BY hold desc limit 10;
+-----------+----------------+----------+-----------------+-------+-----------+-----------+-------------+------------+
| TENANT_ID | SVR_IP         | SVR_PORT | CONTEXT         | COUNT | HOLD      | USED      | ALLOC_COUNT | FREE_COUNT |
+-----------+----------------+----------+-----------------+-------+-----------+-----------+-------------+------------+
|      1002 |   xx.xx.xx.xx  |     2882 | SqlPhyPlan      |  9299 | 143297472 | 126618229 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | MysqlRequesReco |     4 |  86261760 |  86239232 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | LogGroupBuffer  |     2 |  83927040 |  83886080 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | Memstore        |    31 |  64503808 |  64474296 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | CACHE_MAP_NODE  |     8 |  16646144 |  16637952 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | MetaAllocator   |   722 |  14385792 |  12179684 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | OmtTenant       |    42 |  10674448 |  10631028 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | SqlPlanCache    |   664 |   7868160 |   7515456 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | PoolFreeList    |     8 |   5250880 |   5224352 |           0 |          0 |
|      1002 |   xx.xx.xx.xx  |     2882 | SqlPlanMon      |     3 |   5021696 |   4977920 |           0 |          0 |
+-----------+----------------+----------+-----------------+-------+-----------+-----------+-------------+------------+
10 rows in set