OceanBase 查看集群 SQL 请求流量是否均衡
运行如下语句可以查看集群 SQL 请求流量是否均衡:
obclient>SELECT/*+ PARALLEL(15)*/t2.zone, t1.svr_ip, COUNT(*) AS QPS,
AVG(t1.elapsed_time), AVG(t1.queue_time)
FROM oceanbase.gv$sql_audit t1, __all_server t2
WHERE t1.svr_ip = t2.svr_ip AND IS_EXECUTOR_RPC = 0
AND request_time > (time_to_usec(now()) - 1000000)
AND request_time < time_to_usec(now())
GROUP BY t1.svr_ip ORDER BY t2.zone;
+--------+----------------+------+----------------------+--------------------+
| zone | svr_ip | QPS | avg(t1.elapsed_time) | avg(t1.queue_time) |
+--------+----------------+------+----------------------+--------------------+
| ET2_1 | 10.103.224.119 | 379 | 5067.3034 | 33.7071 |
| ET2_1 | 10.103.226.124 | 507 | 5784.1538 | 12.5878 |
| ET2_1 | 10.103.228.177 | 370 | 5958.2162 | 10.9811 |
| ET2_1 | 10.103.229.107 | 356 | 5730.9972 | 39.4185 |
| ET2_1 | 10.103.229.94 | 369 | 5851.7886 | 64.9621 |
| EU13_2 | 10.183.78.113 | 354 | 6182.6384 | 11.3107 |
| EU13_2 | 10.183.78.86 | 349 | 5881.3209 | 10.7393 |
| EU13_2 | 10.183.79.56 | 347 | 5936.0144 | 11.9049 |
| EU13_2 | 10.183.85.152 | 390 | 5988.4846 | 12.0487 |
| EU13_3 | 10.183.76.140 | 284 | 5657.2218 | 11.7993 |
| EU13_3 | 10.183.78.165 | 372 | 5360.6989 | 11.6290 |
| EU13_3 | 10.183.79.198 | 416 | 4154.2861 | 12.2524 |
| EU13_3 | 10.183.86.65 | 446 | 6487.6009 | 24.5112 |
| EU13_3 | 11.180.113.7 | 364 | 5444.4203 | 12.3462 |
+--------+----------------+------+----------------------+--------------------+