CDN基础数据
CDN基础数据仪表盘主要展示缓存命中率、下载速度、访问状态、访问延时分布、请求带宽、访问次数/人数、访问平均延时、请求命中率。
背景信息
CDN(Content Delivery Network,内容分发网络)记录了所有域名(包括已删除域名,如果您开通了企业项目,则已删除域名不支持此功能)被网络用户访问的详细日志,您可以将日志接入LTS,对您的业务资源被访问情况进行详细分析。
分析网站访问情况
- 登录云日志服务控制台,在左侧导航栏中选择“仪表盘”。
- 在仪表盘模板下方,选择“CDN仪表盘模板>CDN基础数据”仪表盘,查看图表详情。
重要图表说明
CDN基础数据仪表盘中的重要图表说明如下所示:
- 缓存命中率图展示缓存命中率统计的变化情况,所关联的查询分析语句如下所示:
select round(diff[1],2) as Hit_ratio, round(diff[2],2) as diff, round((diff[3]-1)*100, 2) from (select compare(Hit_ratio, 86400) as diff from (select sum(s) * 100.0/count(*) as Hit_ratio from (select case when hit_info = 'HIT' then 1 else 0 end as s from log)))
- 下载速度图展示下载速度统计的变化情况,所关联的查询分析语句如下所示:
select round(diff[1],2) as speed, round(diff[2],2) as diff, round((diff[3]-1)*100, 2) from (select compare(speed, 86400) as diff from (select sum(response_size) * 1.0 /sum(response_time) as speed from log ))
- 访问状态图展示访问状态统计的变化情况,所关联的查询分析语句如下所示:
select http_code , count(*) as c group by http_code order by c desc
- 访问延时分布图展示访问延时分布统计的变化情况,所关联的查询分析语句如下所示:
select case when response_time < 100 then '~100ms' when response_time < 500 then '100~500ms' when response_time < 1000 then '500ms~1s' when response_time < 5000 then '1~5s' when response_time < 6000 then '5~6s' when response_time < 7000 then '6~7s' when response_time < 8000 then '7~8s' when response_time < 10000 then '8~10s' when response_time < 15000 then '10~15s' else '15s~' end as latency , count(*) as cnt group by latency order by cnt
- 请求带宽图展示请求带宽统计的变化情况,所关联的查询分析语句如下所示:
select TIME_FORMAT (TIME_FLOOR(__time,'PT1M'), 'HH:mm', '+08:00') as thisdate, sum(response_size) * 8/1000000000.0 as "带宽Gbit/min" group by TIME_FLOOR(__time,'PT1M') order by TIME_FLOOR(__time,'PT1M')
- 访问次数/人数图展示访问次数/人数统计的变化情况,所关联的查询分析语句如下所示:
select TIME_FORMAT (TIME_FLOOR(__time,'PT1M'), 'HH:mm', '+08:00') as thisdate, count(*) as pv, APPROX_COUNT_DISTINCT(client_ip) as uv group by TIME_FLOOR(__time,'PT1M') order by TIME_FLOOR(__time,'PT1M')
- 访问平均延时图展示访问平均延时统计的变化情况,所关联的查询分析语句如下所示:
select TIME_FORMAT (TIME_FLOOR(__time,'PT1M'), 'HH:mm', '+08:00') as thisdate, avg(response_time) as "平均延时(ms)" group by TIME_FLOOR(__time,'PT1M') order by TIME_FLOOR(__time,'PT1M')
- 请求命中率图展示请求命中率变化情况,所关联的查询分析语句如下所示:
select TIME_FORMAT (TIME_FLOOR(m_time,'PT1M'), 'HH:mm', '+08:00' ) as thisdate , sum(is_hit)*100.0/count(*) as hit_ratio from (select TIME_FLOOR(__time,'PT1M') as m_time , case when hit_info = 'HIT' then 1 else 0 end as is_hit from log ) group by m_time order by m_time