安装grafana,官网提供了ubuntu的安装包,直接进行安装
wget https://dl.grafana.com/oss/release/grafana_6.5.1_amd64.deb
dpkg -i grafana_6.5.1_amd64.deb
update-rc.d grafana-server defaults 95 10
service grafana-server start
添加数据
while true;do curl -i -XPOST 'http://127.0.0.1:8086/write?db=sinamail' --data-binary "webface,ip=10.2.2.1,httpstatus=404 prototype=\"GET /favicon.ico HTTP/1.1\" `date +%s`000000000";done
查询数据
curl -GET 'http://127.0.0.1:8086/query?pretty=true' --data-urlencode "db=sinamail" --data-urlencode "q=SELECT * FROM webface where httpstatus='404'"
添加grafana的influxdb数据源
查询表数据绘制出折线图
{ "xhrStatus": complete",request: { methodGETurlapi/datasources/proxy/1/queryparams: { dbsinamailqSELECT count(\"prototype\") FROM \"webface\" WHERE (\"httpstatus\" = '404') AND time >= now() - 15m GROUP BY time(1m) fill(null)epochms },1)">data": nullprecision },1)">responseresults: [ { statement_id0series: [ { namewebfacecolumns: [ timecount ],1)">values: [ [ 1575211320000 ],[ 15752113800001575211440000157521150000015752115600001157521162000015752116800004157521174000081575211800000157521186000015752119200004115752119800001575212040000157521210000015752121600001575212220000 ] ] } ] } ] } }