codecamp

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 |
+--------+----------------+------+----------------------+--------------------+
OceanBase 查询 SQL 流量分布情况及 QPS
OceanBase 查询排名 TOP N 的 SQL
温馨提示
下载编程狮App,免费阅读超1000+编程语言教程
取消
确定
目录

OceanBase 控制台指南

OceanBase ODC 使用指南

OceanBase Web 版 ODC

OceanBase 客户端版 ODC

OceanBase Connector/J 开发者指南

OceanBase 什么是OceanBase Connector/J

OceanBase SQL 参考(MySQL 模式)

OceanBase SQL 参考(Oracle 模式)

OceanBase 基本元素

OceanBase 数据库对象

OceanBase 函数

OceanBase 单行函数

OceanBase 返回数字的字符串函数

OceanBase 通用比较函数

OceanBase 编码解码函数

OceanBase SQL 调优指南

OceanBase 相关协议

关闭

MIP.setData({ 'pageTheme' : getCookie('pageTheme') || {'day':true, 'night':false}, 'pageFontSize' : getCookie('pageFontSize') || 20 }); MIP.watch('pageTheme', function(newValue){ setCookie('pageTheme', JSON.stringify(newValue)) }); MIP.watch('pageFontSize', function(newValue){ setCookie('pageFontSize', newValue) }); function setCookie(name, value){ var days = 1; var exp = new Date(); exp.setTime(exp.getTime() + days*24*60*60*1000); document.cookie = name + '=' + value + ';expires=' + exp.toUTCString(); } function getCookie(name){ var reg = new RegExp('(^| )' + name + '=([^;]*)(;|$)'); return document.cookie.match(reg) ? JSON.parse(document.cookie.match(reg)[2]) : null; }