/statshow

API监控利器

Primary LanguagePHP

statshow

API监控使用,tcp涉及协议解释，暂定使用http来收集上报。 模式定时读取文件，统一上报。

所需组件

  1. redis
  2. php

todolist

  1. 基本uri请求统计
  2. highcharts图表的展示

腾讯云日志服务

https://cloud.tencent.com/document/product/614/47044

检索分析日志 https://cloud.tencent.com/document/product/614/56447 https://cloud.tencent.com/document/product/614/47044

  • | select uri,histogram (cast (TIMESTAMP as timestamp) ,interval 1 minute) as analytic_time, count (*) as log_count group by uri order by analytic_time limit 1000

查看访问量比较多的uri

  • | select uri, count (*) as log_count group by uri order by log_count desc limit 1000

查看访问量比较多的ip

  • | select remote_addr, count (*) as log_count group by remote_addr order by log_count desc limit 1000

  • | select remote_addr,ip_to_city(remote_addr),uri, count (*) as log_count group by remote_addr,uri order by log_count desc

  • | select uri,remote_addr,count (*) as log_count group by uri,remote_addr order by log_count desc

耗时uri

  • | select uri,remote_addr,bytes_sent,request_time,upstream_response_time where upstream_response_time>0.5 order by upstream_response_time desc
  • | select uri,remote_addr,request,http_referer,upstream_response_time where upstream_response_time>0.5 order by upstream_response_time desc