每分钟接口访问次数的前200条统计
not request_uri : "/heartbeat.html" | SELECT time_series(time, '1m', '%H:%i:%s' ,'0') as time,request_uri,COUNT(*) as number GROUP BY request_uri,time order by number desc LIMIT 200
请求时长统计表
not request_uri : "/heartbeat.html" | SELECT time_series(time, '1m', '%H:%i:%s' ,'0') as time,request_uri,request_time GROUP BY request_uri,time,request_time order by request_time desc LIMIT 200
http status 每分钟状态统计
not request_uri : "/heartbeat.html" | SELECT time_series(time, '1m', '%H:%i:%s' ,'0') as time,status,COUNT(*) as number GROUP BY status,time order by number desc LIMIT 200
http status 499 每分钟状态统计
not request_uri : "/heartbeat.html" and status : 499 | SELECT time_series(time, '1m', '%H:%i:%s' ,'0') as time,status,COUNT(*) as number GROUP BY status,time order by number desc LIMIT 200
499接口报警
* not request_uri : "/heartbeat.html" and status : 499 | SELECT time_series(__time__, '1m', '%H:%i:%s' ,'0') as time,status,COUNT(*) as number GROUP BY status,time order by number desc LIMIT 200
按响应时间排序
select "request_time" , "request_uri" from (select * fromloglimit 1000) orderby "request_time" desc
按请求次数排序
select count(*) as pv , "request_uri" fromlog WHERE time 1550888403 groupby "request_uri" ORDERBY pv DESC
当你停下来休息的时候，不要忘记别人还在奔跑！
服务器托管，北京服务器托管，服务器租用 http://www.fwqtg.net
机房租用，北京机房租用，IDC机房托管， http://www.e1idc.net
