CDN基础数据

前提条件

• 已采集CDN日志，详情请参见CDN接入。
• 日志配置结构化，详情请参见结构化配置。

背景信息

CDN（Content Delivery Network，内容分发网络）记录了所有域名（包括已删除域名，如果您开通了企业项目，则已删除域名不支持此功能）被网络用户访问的详细日志，您可以将日志接入LTS，对您的业务资源被访问情况进行详细分析。

分析网站访问情况

1. 登录云日志服务控制台，在左侧导航栏中选择“仪表盘”。
2. 在仪表盘模板下方，选择“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