1: nginx 格式如下:
log_format main '{"timestamp":"$time_iso8601",'
'"clientip":"$remote_addr",'
'"host":"$server_addr",'
'"request_body":"$request_body",'
'"size":$body_bytes_sent,'
'"responsetime":$request_time,'
'"upstreamtime":$upstream_response_time,'
'"upstreamhost":"$upstream_addr",'
'"request":"$request",'
'"url":"$uri",'
'"http_referer":"$http_referer",'
'"http_user_agent":"$http_user_agent",'
'"http_host":"$host",'
'"grouping":"test-in-nginx",'
'"channel":"test",'
'"status":"$status"}';
2: 统计8月8号 19:55到20:00之间访问url的频率:
sed -n '/2019-08-08T19:55/,/2019-08-08T20:01/p' /home/appsvr/access.log.2019-08-08-19 | awk -F "," '{print $10}' | sort | uniq -c | sort -n -k 1 -r | more