diff options
| author | doufenghu <[email protected]> | 2018-12-19 19:11:12 +0600 |
|---|---|---|
| committer | doufenghu <[email protected]> | 2018-12-19 19:11:12 +0600 |
| commit | 1522149abd18aaaced8805e54219a6142df13c04 (patch) | |
| tree | 9b1b5fca55cc40d83a5622100305776c156cd236 | |
| parent | f716650e4038001b761714a4434031bce3b8fca1 (diff) | |
修正互联网流量（各个地域当前网络负载流量），使用传输层流量进行统计
| -rw-r--r-- | src/main/resources/mybatis/mapper/NetflowTopNMapper.xml | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml b/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml index bd139d1..3a0e4fc 100644 --- a/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml +++ b/src/main/resources/mybatis/mapper/NetflowTopNMapper.xml @@ -19,7 +19,7 @@ ]]> </select> <!--互联网流量TOP10--> - <select id="getNetFlowWaterTop10" resultType="com.nis.galaxy.domain.NetFlowWater"> + <select id="getNetFlowWaterTop10_old" resultType="com.nis.galaxy.domain.NetFlowWater"> <![CDATA[ SELECT ifnull(dic.area,0) AS area,net.time AS time,sum(net.count)/1024/1024 AS count FROM ( @@ -34,6 +34,18 @@ GROUP BY area,time ]]> </select> + + + <select id="getNetFlowWaterTop10" resultType="com.nis.galaxy.domain.NetFlowWater"> + <![CDATA[ + + select entrance_id as area ,stat_time as time, IFNULL(SUM(c2s_byte_len+s2c_byte_len),0)/1024/1024 as count + from traffic_trans_statistic where STAT_TIME>= #{start} and STAT_TIME<#{end} + group by stat_time,entrance_id + + + ]]> + </select> <!--1小时互联网流量TOP10--> <select id="getNetflow1HourWaterflowTop10" resultType="com.nis.galaxy.domain.NetFlowWater" parameterType="java.util.List"> <foreach collection="list" item="item" index="index" open="(" close=")" separator=") UNION ALL ("> |