Created
October 20, 2015 16:26
-
-
Save fatmcgav/56eab3b31ce50207ac2a to your computer and use it in GitHub Desktop.
Grafana InfluxDB 'found USER'
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"id": 1, | |
"title": "New dashboard", | |
"originalTitle": "New dashboard", | |
"tags": [], | |
"style": "dark", | |
"timezone": "browser", | |
"editable": true, | |
"hideControls": false, | |
"sharedCrosshair": false, | |
"rows": [ | |
{ | |
"collapse": false, | |
"editable": true, | |
"height": "250px", | |
"panels": [ | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"datasource": null, | |
"editable": true, | |
"error": false, | |
"fill": 1, | |
"grid": { | |
"leftLogBase": 1, | |
"leftMax": null, | |
"leftMin": null, | |
"rightLogBase": 1, | |
"rightMax": null, | |
"rightMin": null, | |
"threshold1": null, | |
"threshold1Color": "rgba(216, 200, 27, 0.27)", | |
"threshold2": null, | |
"threshold2Color": "rgba(234, 112, 112, 0.22)" | |
}, | |
"id": 1, | |
"legend": { | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"show": true, | |
"total": false, | |
"values": false | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"span": 12, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"fields": [ | |
{ | |
"func": "mean", | |
"name": "system" | |
}, | |
{ | |
"func": "mean", | |
"name": "iowait" | |
}, | |
{ | |
"func": "mean", | |
"name": "idle" | |
}, | |
{ | |
"func": "mean", | |
"name": "user" | |
} | |
], | |
"groupByTags": [ | |
"host" | |
], | |
"measurement": "cpu", | |
"query": "SELECT mean(system), mean(iowait), mean(idle), mean(user) FROM \"cpu\" WHERE \"host\" =~ /sensu*/ AND $timeFilter GROUP BY time($interval), \"host\"", | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/sensu*/" | |
} | |
] | |
} | |
], | |
"timeFrom": null, | |
"timeShift": null, | |
"title": "CPU Load", | |
"tooltip": { | |
"shared": true, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"x-axis": true, | |
"y-axis": true, | |
"y_formats": [ | |
"short", | |
"short" | |
] | |
} | |
], | |
"title": "Row" | |
} | |
], | |
"nav": [ | |
{ | |
"collapse": false, | |
"enable": true, | |
"notice": false, | |
"now": true, | |
"refresh_intervals": [ | |
"5s", | |
"10s", | |
"30s", | |
"1m", | |
"5m", | |
"15m", | |
"30m", | |
"1h", | |
"2h", | |
"1d" | |
], | |
"status": "Stable", | |
"time_options": [ | |
"5m", | |
"15m", | |
"1h", | |
"6h", | |
"12h", | |
"24h", | |
"2d", | |
"7d", | |
"30d" | |
], | |
"type": "timepicker" | |
} | |
], | |
"time": { | |
"from": "now-6h", | |
"to": "now" | |
}, | |
"templating": { | |
"list": [] | |
}, | |
"annotations": { | |
"list": [] | |
}, | |
"schemaVersion": 6, | |
"version": 0, | |
"links": [] | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[http] 2015/10/20 17:24:23 127.0.0.1 - admin [20/Oct/2015:17:24:23 +0100] GET /query?db=graphite&epoch=ms&q=SELECT+mean%28system%29%2C+mean%28iowait%29%2C+mean%28idle%29%2C+mean%28user%29+FROM+%22cpu%22+WHERE+%22host%22+%3D~+%2Fsensu%2A%2F+AND+time+%3E+now%28%29+-+6h+GROUP+BY+time%2810s%29%2C+%22host%22 HTTP/1.1 400 119 http://sensu.lt0772.local:3001/dashboard/db/new-dashboard Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36 0663616e-7747-11e5-8053-000000000000 584.602µs |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
> select * from cpu limit 1 | |
name: cpu | |
--------- | |
time guest host idle iowait irq nice softirq steal system user | |
1445349415000000000 0 sensu 100 0 0 0 0 0 0 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment