Created
January 24, 2019 20:40
-
-
Save juliojsb/5abba8ecabc9374e6f58a138a597e49f to your computer and use it in GitHub Desktop.
MySQL/MariaDB dashboard for Grafana (Collectd)
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
{ | |
"annotations": { | |
"list": [ | |
{ | |
"builtIn": 1, | |
"datasource": "-- Grafana --", | |
"enable": true, | |
"hide": true, | |
"iconColor": "rgba(0, 211, 255, 1)", | |
"name": "Annotations & Alerts", | |
"type": "dashboard" | |
} | |
] | |
}, | |
"editable": true, | |
"gnetId": null, | |
"graphTooltip": 0, | |
"id": 14, | |
"iteration": 1548349459138, | |
"links": [], | |
"panels": [ | |
{ | |
"cacheTimeout": null, | |
"colorBackground": false, | |
"colorValue": false, | |
"colors": [ | |
"#299c46", | |
"rgba(237, 129, 40, 0.89)", | |
"#d44a3a" | |
], | |
"format": "none", | |
"gauge": { | |
"maxValue": 100, | |
"minValue": 0, | |
"show": false, | |
"thresholdLabels": false, | |
"thresholdMarkers": true | |
}, | |
"gridPos": { | |
"h": 5, | |
"w": 3, | |
"x": 0, | |
"y": 0 | |
}, | |
"id": 48, | |
"interval": null, | |
"links": [], | |
"mappingType": 1, | |
"mappingTypes": [ | |
{ | |
"name": "value to text", | |
"value": 1 | |
}, | |
{ | |
"name": "range to text", | |
"value": 2 | |
} | |
], | |
"maxDataPoints": 100, | |
"nullPointMode": "connected", | |
"nullText": null, | |
"postfix": "", | |
"postfixFontSize": "50%", | |
"prefix": "", | |
"prefixFontSize": "50%", | |
"rangeMaps": [ | |
{ | |
"from": "null", | |
"text": "N/A", | |
"to": "null" | |
} | |
], | |
"sparkline": { | |
"fillColor": "rgba(31, 118, 189, 0.18)", | |
"full": false, | |
"lineColor": "rgb(31, 120, 193)", | |
"show": false | |
}, | |
"tableColumn": "", | |
"targets": [ | |
{ | |
"alias": "connected", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type_instance", | |
"operator": "=", | |
"value": "connected" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": "", | |
"title": "Current Connections", | |
"type": "singlestat", | |
"valueFontSize": "80%", | |
"valueMaps": [ | |
{ | |
"op": "=", | |
"text": "N/A", | |
"value": "null" | |
} | |
], | |
"valueName": "current" | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "$datasource", | |
"editable": true, | |
"error": false, | |
"fill": 7, | |
"grid": {}, | |
"gridPos": { | |
"h": 5, | |
"w": 6, | |
"x": 3, | |
"y": 0 | |
}, | |
"id": 6, | |
"legend": { | |
"alignAsTable": true, | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": false, | |
"values": false | |
}, | |
"lines": true, | |
"linewidth": 0, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "1 min", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "load_shortterm", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "5 min", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "load_midterm", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "15 min", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "load_longterm", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "C", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Load Average", | |
"tooltip": { | |
"msResolution": true, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"transparent": true, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "$datasource", | |
"editable": true, | |
"error": false, | |
"fill": 7, | |
"grid": {}, | |
"gridPos": { | |
"h": 5, | |
"w": 7, | |
"x": 9, | |
"y": 0 | |
}, | |
"id": 4, | |
"legend": { | |
"alignAsTable": true, | |
"avg": false, | |
"current": false, | |
"hideZero": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": false, | |
"values": false | |
}, | |
"lines": true, | |
"linewidth": 0, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "iowait", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "cpu_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "C", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "wait" | |
} | |
] | |
}, | |
{ | |
"alias": "irq", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "cpu_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "D", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "interrupt" | |
} | |
] | |
}, | |
{ | |
"alias": "nice", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "cpu_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "E", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "nice" | |
} | |
] | |
}, | |
{ | |
"alias": "steal", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "cpu_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "G", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "steal" | |
} | |
] | |
}, | |
{ | |
"alias": "system", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "cpu_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "H", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "system" | |
} | |
] | |
}, | |
{ | |
"alias": "user", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "cpu_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "I", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "user" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "CPU Usage", | |
"tooltip": { | |
"msResolution": true, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"transparent": true, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "$datasource", | |
"editable": true, | |
"error": false, | |
"fill": 7, | |
"grid": {}, | |
"gridPos": { | |
"h": 5, | |
"w": 8, | |
"x": 16, | |
"y": 0 | |
}, | |
"id": 8, | |
"legend": { | |
"alignAsTable": true, | |
"avg": false, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 0, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": true, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "used", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "mem", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"query": "SELECT mean(\"value\") FROM \"memory_value\" WHERE \"type_instance\" = 'used' AND \"host\" =~ /^$host$/ AND $timeFilter GROUP BY time($interval) fill(null)", | |
"rawQuery": true, | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"used" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "free", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "mem", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"query": "SELECT mean(\"value\") FROM \"memory_value\" WHERE \"type_instance\" = 'free' AND \"host\" =~ /^$host$/ AND $timeFilter GROUP BY time($interval) fill(null)", | |
"rawQuery": true, | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"free" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "buffered", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "mem", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"query": "SELECT mean(\"value\") FROM \"memory_value\" WHERE \"type_instance\" = 'buffered' AND \"host\" =~ /^$host$/ AND $timeFilter GROUP BY time($interval) fill(null)", | |
"rawQuery": true, | |
"refId": "C", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"buffered" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "cached", | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"intervalFactor": 2, | |
"measurement": "mem", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"query": "SELECT mean(\"value\") FROM \"memory_value\" WHERE \"type_instance\" = 'cached' AND \"host\" =~ /^$host$/ AND $timeFilter GROUP BY time($interval) fill(null)", | |
"rawQuery": true, | |
"refId": "D", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"cached" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Memory Usage", | |
"tooltip": { | |
"msResolution": true, | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"transparent": true, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"cacheTimeout": null, | |
"colorBackground": false, | |
"colorValue": false, | |
"colors": [ | |
"rgba(245, 54, 54, 0.9)", | |
"rgba(237, 129, 40, 0.89)", | |
"rgba(50, 172, 45, 0.97)" | |
], | |
"datasource": "$datasource", | |
"decimals": 1, | |
"editable": true, | |
"error": false, | |
"format": "s", | |
"gauge": { | |
"maxValue": 100, | |
"minValue": 0, | |
"show": false, | |
"thresholdLabels": false, | |
"thresholdMarkers": true | |
}, | |
"gridPos": { | |
"h": 5, | |
"w": 3, | |
"x": 0, | |
"y": 5 | |
}, | |
"height": "55px", | |
"hideTimeOverride": true, | |
"id": 10, | |
"interval": null, | |
"links": [], | |
"mappingType": 1, | |
"mappingTypes": [ | |
{ | |
"name": "value to text", | |
"value": 1 | |
}, | |
{ | |
"name": "range to text", | |
"value": 2 | |
} | |
], | |
"maxDataPoints": 100, | |
"nullPointMode": "connected", | |
"nullText": null, | |
"postfix": "s", | |
"postfixFontSize": "80%", | |
"prefix": "", | |
"prefixFontSize": "50%", | |
"rangeMaps": [ | |
{ | |
"from": "null", | |
"text": "N/A", | |
"to": "null" | |
} | |
], | |
"sparkline": { | |
"fillColor": "rgba(31, 118, 189, 0.18)", | |
"full": false, | |
"lineColor": "rgb(31, 120, 193)", | |
"show": false | |
}, | |
"tableColumn": "", | |
"targets": [ | |
{ | |
"dsType": "influxdb", | |
"expr": "", | |
"groupBy": [], | |
"intervalFactor": 2, | |
"measurement": "system", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"query": "SELECT last(\"value\") FROM \"uptime_value\" WHERE \"host\" =~ /^$host$/ AND $timeFilter GROUP BY time(10s) fill(null)", | |
"rawQuery": true, | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"uptime" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "last" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": "", | |
"timeFrom": "1h", | |
"title": "Uptime", | |
"type": "singlestat", | |
"valueFontSize": "80%", | |
"valueMaps": [ | |
{ | |
"op": "=", | |
"text": "N/A", | |
"value": "null" | |
} | |
], | |
"valueName": "current" | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"fill": 7, | |
"gridPos": { | |
"h": 5, | |
"w": 15, | |
"x": 3, | |
"y": 5 | |
}, | |
"id": 38, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"hideEmpty": false, | |
"hideZero": false, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 0, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Received", | |
"groupBy": [ | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_rx", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_octets" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "Sent", | |
"groupBy": [ | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_tx", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_octets" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Network Traffic", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"transparent": true, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bps", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "bps", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": true, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "$datasource", | |
"editable": true, | |
"error": false, | |
"fill": 7, | |
"grid": {}, | |
"gridPos": { | |
"h": 5, | |
"w": 6, | |
"x": 18, | |
"y": 5 | |
}, | |
"id": 36, | |
"legend": { | |
"alignAsTable": false, | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"rightSide": false, | |
"show": false, | |
"total": false, | |
"values": false | |
}, | |
"lines": false, | |
"linewidth": 0, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Received", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_rx", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "sum" | |
}, | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_octets" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "Sent", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"measurement": "mysql_tx", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "sum" | |
}, | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_octets" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Total Network Traffic", | |
"tooltip": { | |
"msResolution": true, | |
"shared": false, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"transparent": true, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "series", | |
"name": null, | |
"show": true, | |
"values": [ | |
"total" | |
] | |
}, | |
"yaxes": [ | |
{ | |
"format": "decbytes", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "none", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"fill": 10, | |
"gridPos": { | |
"h": 7, | |
"w": 6, | |
"x": 0, | |
"y": 10 | |
}, | |
"id": 23, | |
"legend": { | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"show": false, | |
"total": false, | |
"values": false | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": true, | |
"targets": [ | |
{ | |
"alias": "cache size", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_size" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Cache Size", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"transparent": false, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "deckbytes", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"fill": 7, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 6, | |
"y": 10 | |
}, | |
"id": 43, | |
"legend": { | |
"alignAsTable": true, | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": false, | |
"values": false | |
}, | |
"lines": true, | |
"linewidth": 0, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "hits", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_result" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "qcache-hits" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "inserts", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_result" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "qcache-inserts" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "not cached", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "C", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_result" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "qcache-not_cached" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "prunes", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "D", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_result" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "qcache-prunes" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Query Cache Results", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"transparent": false, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": true, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "$datasource", | |
"fill": 1, | |
"gridPos": { | |
"h": 7, | |
"w": 6, | |
"x": 18, | |
"y": 10 | |
}, | |
"id": 17, | |
"legend": { | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"rightSide": false, | |
"show": false, | |
"total": false, | |
"values": false | |
}, | |
"lines": false, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "hits", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"query": "SELECT sum(\"value\") FROM \"mysql_value\" WHERE (\"type_instance\" = 'insert') AND $timeFilter GROUP BY time($__interval) fill(null)", | |
"rawQuery": false, | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_result" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "qcache-hits" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "insert", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_result" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "qcache-inserts" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "not cached", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "C", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"1s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_result" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "qcache-not_cached" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "prunes", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"hide": false, | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "D", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "cache_result" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "qcache-prunes" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Query Cache Summary", | |
"tooltip": { | |
"shared": false, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "series", | |
"name": null, | |
"show": true, | |
"values": [ | |
"total" | |
] | |
}, | |
"yaxes": [ | |
{ | |
"format": "none", | |
"label": "Total", | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "none", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "$datasource", | |
"fill": 7, | |
"gridPos": { | |
"h": 8, | |
"w": 6, | |
"x": 0, | |
"y": 17 | |
}, | |
"id": 19, | |
"legend": { | |
"alignAsTable": true, | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": false, | |
"total": false, | |
"values": false | |
}, | |
"lines": true, | |
"linewidth": 0, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "connections", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type_instance", | |
"operator": "=", | |
"value": "connected" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Connections", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"transparent": false, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "$datasource", | |
"fill": 7, | |
"gridPos": { | |
"h": 8, | |
"w": 10, | |
"x": 6, | |
"y": 17 | |
}, | |
"id": 51, | |
"legend": { | |
"alignAsTable": true, | |
"avg": false, | |
"current": true, | |
"hideEmpty": false, | |
"hideZero": false, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 0, | |
"links": [], | |
"nullPointMode": "connected", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "change_db", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_commands" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "change_db" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "create_user", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "B", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_commands" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "create_user" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "delete", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "C", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_commands" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "delete" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "delete_multi", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "D", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_commands" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "delete_multi" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "flush", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "E", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_commands" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "flush" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "grant", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "F", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_commands" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "grant" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "insert", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "G", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"tags": [ | |
{ | |
"key": "type", | |
"operator": "=", | |
"value": "mysql_commands" | |
}, | |
{ | |
"condition": "AND", | |
"key": "type_instance", | |
"operator": "=", | |
"value": "insert" | |
}, | |
{ | |
"condition": "AND", | |
"key": "host", | |
"operator": "=~", | |
"value": "/^$host$/" | |
} | |
] | |
}, | |
{ | |
"alias": "lock_tables", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$__interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"measurement": "mysql_value", | |
"orderByTime": "ASC", | |
"policy": "default", | |
"refId": "H", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], |