CDN热门资源

CDN热门资源仪表盘主要展示域名访问次数Top5、域名下载流量Top5、热门访问（URI）、热门访问（来源）、全国访问次数分布统计、全国下载网速统计、省份统计、运营商流量和速度、运营商统计。

分析网站访问情况

1. 登录云日志服务控制台，在左侧导航栏中选择“仪表盘”。
2. 在仪表盘模板下方，选择“CDN仪表盘模板>CDN热门资源”仪表盘，查看图表详情。

重要图表说明

CDN热门资源仪表盘中的重要图表说明如下所示：

• 域名访问次数Top5图展示域名访问次数Top5的变化情况，所关联的查询分析语句如下所示：

  select domain ,count(*) as cnt group by domain order by cnt desc limit 5

• 域名下载流量Top5图展示域名下载流量Top5的变化情况，所关联的查询分析语句如下所示：

  select domain , sum(response_size) as "下载总量" group by domain order by "下载总量" desc limit 5

• 热门访问（URI）图展示热门访问URI的变化情况，所关联的查询分析语句如下所示：

  select uri as URI, "访问次数", "访问人数", round( CASE WHEN "下载总量(GB)" > 0 THEN "下载总量(GB)" ELSE 0 END, 2 ) AS "下载总量(GB)" from (        select uri ,count(*) as "访问次数" , APPROX_COUNT_DISTINCT(client_ip) as "访问人数", sum(response_size)/1024.0/1024.0/1024.0 as "下载总量(GB)" where http_code < 400 group by uri order by "访问次数" desc limit 100)

• 热门访问（来源）图展示热门访问来源的变化情况，所关联的查询分析语句如下所示：

  select refer_domain as "来源",c as "次数",uv as "人数", round(c * 100.0 / sum(c), 2) as  "百分比%"  from (select refer_domain as refer_domain,count(*) as c,APPROX_COUNT_DISTINCT(client_ip) as uv from log where refer_domain != '' group by refer_domain order by c desc limit 100 ) GROUP BY refer_domain, c, uv

• 全国访问次数分布统计图展示全国访问次数分布统计的变化情况，所关联的查询分析语句如下所示：

  select ip_to_province(client_ip) as province , count(*) as cnt where IP_TO_COUNTRY (client_ip) = '中国' group by province HAVING province not in ('','保留地址','*') order by cnt desc limit 1000

• 全国下载网速统计图展示全国下载网速统计的变化情况，所关联的查询分析语句如下所示：

  select province, round( CASE WHEN "speed" > 0 THEN "speed" ELSE 0 END, 3 ) AS "speed" from (select ip_to_province(client_ip) as province , sum(response_size)* 1.0 /(sum(response_time)+1) as "speed" , count(*) as c where IP_TO_COUNTRY (client_ip) = '中国' group by province HAVING province not in ('','保留地址','*') order by c desc limit 40)

• 省份统计图展示省份统计的变化情况，所关联的查询分析语句如下所示：

  select ip_to_province(client_ip) as "省份" ,count(*) as "访问次数", sum(response_size)/1024.0/1024.0/1024.0 as "下载流量(GB)" , sum(response_size) * 1.0 /sum(response_time) as "下载速度(KB/s)" group by "省份" having ip_to_province(client_ip) != '' order by "下载流量(GB)" desc limit 200

• 运营商流量和速度图展示运营商流量和速度的变化情况，所关联的查询分析语句如下所示：

  select ip_to_provider(client_ip) as isp , sum(response_size)* 1.0 /(sum(response_time)+1) as "下载速度(KB/s)" , sum(response_size)/1024.0/1024.0/1024.0 as "下载总量(GB)", count(*) as c group by isp having ip_to_provider(client_ip) != '' order by c desc limit 10

• 运营商统计图展示运营商统计的变化情况，所关联的查询分析语句如下所示：

  select "运营商", "访问次数", round( CASE WHEN "下载流量(GB)" > 0 THEN "下载流量(GB)" ELSE 0 END, 2 ) AS "下载流量(GB)",        round( CASE WHEN "下载速度(KB/s)" > 0 THEN "下载速度(KB/s)" ELSE 0 END, 2 ) AS "下载速度(KB/s)" from (      select ip_to_provider(client_ip) as "运营商" ,count(*) as "访问次数", sum(response_size)/1024.0/1024.0/1024.0 as "下载流量(GB)" , sum(response_size) * 1.0 /sum(response_time) as "下载速度(KB/s)" group by "运营商" having ip_to_provider(client_ip) != '' and "运营商" not in ('*') order by "下载流量(GB)" desc limit 200)