statshow

statshow

statshow is a simple API monitoring server, used by statstics monitoring project

use

 require dirname ( __FILE__ ). ' /vendor/autoload.php ' ;

$ server = new statshow StatShow ( ' 0.0.0.0 ' , 8081 );
$ server -> start ();

Required components

1. redis
2. php (gd extension, event extension)
3. libevent

todolist

Highcharts chart display

other

A relatively easy-to-use third-party data retrieval

Tencent Cloud Log Service

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

Retrieve analysis logs

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

View URIs with more visits

• | 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

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

View IPs with more visits

• | 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

Time consuming 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