php接入influxdb,[Linux]安装grafana并且添加influxdb监控
安裝grafana,官網(wǎng)提供了ubuntu的安裝包,直接進(jìn)行安裝
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
使用influxdb的http api添加數(shù)據(jù)和查詢數(shù)據(jù)
添加數(shù)據(jù)
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
查詢數(shù)據(jù)
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數(shù)據(jù)源
查詢表數(shù)據(jù)繪制出折線圖
{"xhrStatus": "complete","request": {"method": "GET","url": "api/datasources/proxy/1/query","params": {"db": "sinamail","q": "SELECT count(\"prototype\") FROM \"webface\" WHERE (\"httpstatus\" = '404') AND time >= now() - 15m GROUP BY time(1m) fill(null)","epoch": "ms"},"data": null,"precision": "ms"},"response": {"results": [
{"statement_id": 0,"series": [
{"name": "webface","columns": ["time","count"],"values": [
[1575211320000,0],
[1575211380000,0],
[1575211440000,0],
[1575211500000,0],
[1575211560000,1],
[1575211620000,0],
[1575211680000,4],
[1575211740000,8],
[1575211800000,0],
[1575211860000,0],
[1575211920000,41],
[1575211980000,8],
[1575212040000,0],
[1575212100000,0],
[1575212160000,0],
[1575212220000,0]
]
}
]
}
]
}
}
原文鏈接:https://www.cnblogs.com/taoshihan/p/11968274.html
總結(jié)
以上是生活随笔為你收集整理的php接入influxdb,[Linux]安装grafana并且添加influxdb监控的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問(wèn)題。
- 上一篇: matlab中转置和裁剪,对Matlab
- 下一篇: oracle10g sys密码忘记,Or