obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 404.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.021 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 408.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.003 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 416.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.003 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 418.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.015 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 422.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.003 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 850.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.003 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 1150.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.005 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 1410.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.004 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 1730.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.004 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 1766.00000000 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 4 rows in set (0.003 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 1768.00000000 | | 1 | 127.0.0.1 | SqlPhyPlan | 154.53851318 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 5 rows in set (0.004 sec) obclient [oceanbase]> select tenant_id, svr_ip, mod_name, sum(hold) / 1024 / 1024 module_sum_MB from oceanbase.__all_virtual_memory_info group by tenant_id, svr_ip, mod_name having module_sum_MB > 100 order by tenant_id, svr_ip, module_sum_MB desc; +-----------+-----------+---------------+---------------+ | tenant_id | svr_ip | mod_name | module_sum_MB | +-----------+-----------+---------------+---------------+ | 1 | 127.0.0.1 | KvstorCacheMb | 1768.00000000 | | 1 | 127.0.0.1 | SqlPhyPlan | 154.53851318 | | 1 | 127.0.0.1 | Memstore | 142.87500000 | | 1 | 127.0.0.1 | CoStack | 132.89062500 | | 500 | 127.0.0.1 | CACHE_MAP_BKT | 128.01960754 | +-----------+-----------+---------------+---------------+ 5 rows in set (0.003 sec)