top -H -b -n 1 -o %CPU -p 2185069 | head -25 top - 19:05:47 up 10 days, 2:34, 1 user, load average: 10.66, 9.14, 9.10 Threads: 608 total, 9 running, 599 sleeping, 0 stopped, 0 zombie %Cpu(s): 22.2 us, 0.4 sy, 0.0 ni, 77.2 id, 0.0 wa, 0.0 hi, 0.2 si, 0.0 st MiB Mem : 64839.5 total, 32487.2 free, 16286.7 used, 16065.6 buff/cache MiB Swap: 0.0 total, 0.0 free, 0.0 used. 38546.6 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 226361 admin 20 0 20.9g 14.7g 268608 R 99.9 23.1 950:19.95 T1_PX_G0 236799 admin 20 0 20.9g 14.7g 268608 R 99.9 23.1 2350:10 T1_PX_G0 2113515 admin 20 0 20.9g 14.7g 268608 R 99.9 23.1 63:17.35 T1_L0_G0 2143034 admin 20 0 20.9g 14.7g 268608 R 99.9 23.1 259:34.79 T1_L0_G0 2144864 admin 20 0 20.9g 14.7g 268608 R 99.9 23.1 140:34.08 T1_PX_G0 2730492 admin 20 0 20.9g 14.7g 268608 S 93.8 23.1 163:06.55 T1_L0_G0 2342377 admin 20 0 20.9g 14.7g 268608 R 68.8 23.1 8:48.93 T1_L0_G0 2106973 admin 20 0 20.9g 14.7g 268608 R 18.8 23.1 269:13.53 T1_L0_G0 2185087 admin 20 0 20.9g 14.7g 268608 S 6.2 23.1 95:18.73 TimerWK3 2185372 admin 20 0 20.9g 14.7g 268608 S 6.2 23.1 16:56.26 sql_nio4 2185427 admin 20 0 20.9g 14.7g 268608 S 6.2 23.1 5:26.27 T508_L0_G0 2185443 admin 20 0 20.9g 14.7g 268608 S 6.2 23.1 49:40.90 MultiTenant 2185678 admin 20 0 20.9g 14.7g 268608 S 6.2 23.1 162:41.40 T1_L5_G0 2185726 admin 20 0 20.9g 14.7g 268608 S 6.2 23.1 5:33.51 T1_L0_G9 1723845 admin 20 0 20.9g 14.7g 268608 R 6.2 23.1 16:29.54 T1_L0_G0 2378777 admin 20 0 20.9g 14.7g 268608 S 6.2 23.1 6:25.08 T1_L0_G0 2871219 admin 20 0 20.9g 14.7g 268608 S 6.2 23.1 1:44.77 T1_L0_G0 2185069 admin 20 0 20.9g 14.7g 268608 S 0.0 23.1 0:03.29 observer SELECT tenant_name, primary_zone FROM oceanbase.DBA_OB_TENANTS; +-------------+--------------+ | tenant_name | primary_zone | +-------------+--------------+ | sys | RANDOM | +-------------+--------------+ 1 row in set (0.097 sec) obclient [oceanbase]> obclient [oceanbase]> SELECT svr_ip, COUNT(*) FROM oceanbase.CDB_OB_TABLE_LOCATIONS -> WHERE role='LEADER' GROUP BY svr_ip; +----------------------------------+----------+ | svr_ip | COUNT(*) | +----------------------------------+----------+ | fc00:305:200:500a:73:0:d6d1:8c0b | 2910 | +----------------------------------+----------+ 1 row in set (0.597 sec) obclient [oceanbase]> obclient [oceanbase]> SELECT tenant_id, svr_ip, COUNT(*) AS req_cnt -> FROM oceanbase.GV$OB_SQL_AUDIT -> WHERE request_time > TIME_TO_USEC(NOW()) - 60000000 -> GROUP BY tenant_id, svr_ip ORDER BY req_cnt DESC; +-----------+----------------------------------+---------+ | tenant_id | svr_ip | req_cnt | +-----------+----------------------------------+---------+ | 1 | fc00:305:200:500a:73:0:d6d1:8c0b | 4626 | | 1 | fc00:305:200:500a:73:0:d6a6:7d15 | 800 | | 1 | fc00:305:200:500a:73:0:d6bb:38dc | 788 | +-----------+----------------------------------+---------+ 3 rows in set (0.113 sec) obclient [oceanbase]> SELECT sql_id, COUNT(*) AS cnt, -> ROUND(AVG(elapsed_time)) AS avg_us, -> SUBSTR(query_sql, 1, 100) AS sql_text -> FROM oceanbase.GV$OB_SQL_AUDIT -> WHERE svr_ip = 'fc00:305:200:500a:73:0:d6d1:8c0b' -> AND request_time > TIME_TO_USEC(NOW()) - 60000000 -> GROUP BY sql_id ORDER BY cnt DESC LIMIT 10; +----------------------------------+------+--------+------------------------------------------------------------------------------------------------------+ | sql_id | cnt | avg_us | sql_text | +----------------------------------+------+--------+------------------------------------------------------------------------------------------------------+ | | 1462 | 1989 | UPDATE hhit_asset_port SET online_state = 1, pid = CASE WHEN ? <> '' THEN ? ELSE pid END, | | 949C1563B18F92C7054A28A9EE6F86A5 | 489 | 58793 | SELECT uid, SUBSTRING( uid, 105, 32 ) AS uuid FROM `hhit_asset` WHERE SUBSTRING( uid, 105, 32 ) IN(' | | 24D486F20861EBD9E0217692DB0E9C61 | 247 | 394 | update __all_weak_read_service set min_version=1785495829723957000, max_version=178549582972395 | | C9B8EFE1B98D8F5BCEB705FC158DB450 | 149 | 1203 | select count(*) as srs_cnt from oceanbase.__all_spatial_reference_systems | | 32AB97A0126F566064F84DDDF4936F82 | 149 | 1254 | | | DD35BC844207137673913D28CFA2BB12 | 122 | 458 | SET @_min_cluster_version = '4.3.5.6'; | | 8E7D6F11BF9D87DDE30D502C8B7509DA | 121 | 178197 | UPDATE hhit_agent SET is_support_ipv4=?,is_support_ipv6=?,agent_ip=?,agent_ip_long=?, agent_localhos | | B0DEFDE3AFC7B6076716DE4E930724A4 | 92 | 184395 | UPDATE hhit_agent SET is_support_ipv4=?,is_support_ipv6=?,agent_ip=?,agent_ip_long=?, agent_localhos | | DBCB5D52A5E14718345165081BC7EAE4 | 66 | 1645 | | | C64BE5C6E91CDAD08370B7189C583332 | 55 | 413 | SET NAMES utf8mb4 | +----------------------------------+------+--------+------------------------------------------------------------------------------------------------------+ 10 rows in set (0.087 sec) obclient [oceanbase]> SELECT svr_ip, user_client_ip, COUNT(*) AS sess_cnt -> FROM oceanbase.GV$OB_PROCESSLIST -> GROUP BY svr_ip, user_client_ip ORDER BY sess_cnt DESC; +----------------------------------+-----------------------------+----------+ | svr_ip | user_client_ip | sess_cnt | +----------------------------------+-----------------------------+----------+ | fc00:305:200:500a:73:0:d6d1:8c0b | 192.168.168.168 | 41 | | fc00:305:200:500a:73:0:d6a6:7d15 | 192.168.168.168 | 17 | | fc00:305:200:500a:73:0:d6bb:38dc | 192.168.168.168 | 7 | | fc00:305:200:500a:73:0:d6a6:7d15 | fc00:301:200:3300:2532::238 | 1 | | fc00:305:200:500a:73:0:d6bb:38dc | fc00:301:200:3300:2532::238 | 1 | +----------------------------------+-----------------------------+----------+ 5 rows in set (0.047 sec)