prometheus+granfan+export+监控数据模板

{ "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": false, "iconColor": "#e0752d", "limit": 100, "name": "PMM Annotations", "showIn": 0, "tags": [ "pmm_annotation" ], "type": "tags" }, { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "#6ed0e0", "limit": 100, "name": "Annotations & Alerts", "showIn": 0, "tags": [], "type": "dashboard" } ] }, "editable": true, "gnetId": null, "graphTooltip": 1, "id": null, "iteration": 1540971751770, "links": [ { "icon": "dashboard", "includeVars": true, "keepTime": true, "tags": [ "QAN" ], "targetBlank": false, "title": "Query Analytics", "type": "link", "url": "/graph/dashboard/db/_pmm-query-analytics" }, { "asDropdown": true, "includeVars": true, "keepTime": true, "tags": [ "OS" ], "targetBlank": false, "title": "OS", "type": "dashboards" }, { "asDropdown": true, "includeVars": true, "keepTime": true, "tags": [ "MySQL" ], "targetBlank": false, "title": "MySQL", "type": "dashboards" }, { "asDropdown": true, "includeVars": true, "keepTime": true, "tags": [ "MongoDB" ], "targetBlank": false, "title": "MongoDB", "type": "dashboards" }, { "asDropdown": true, "includeVars": true, "keepTime": true, "tags": [ "PostgreSQL" ], "targetBlank": false, "title": "PostgreSQL", "type": "dashboards" }, { "asDropdown": true, "includeVars": true, "keepTime": true, "tags": [ "HA" ], "targetBlank": false, "title": "HA", "type": "dashboards" }, { "asDropdown": true, "includeVars": true, "keepTime": true, "tags": [ "Cloud" ], "targetBlank": false, "title": "Cloud", "type": "dashboards" }, { "asDropdown": true, "includeVars": true, "keepTime": true, "tags": [ "Insight" ], "targetBlank": false, "title": "Insight", "type": "dashboards" }, { "asDropdown": true, "includeVars": true, "keepTime": true, "tags": [ "PMM" ], "targetBlank": false, "title": "PMM", "type": "dashboards" } ], "panels": [ { "collapsed": false, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 382, "panels": [], "repeat": null, "title": "", "type": "row" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": true, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "Prometheus", "decimals": 1, "description": "**MySQL Uptime**\n\nThe amount of time since the last restart of the MySQL server process.", "editable": true, "error": false, "format": "s", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 2, "w": 6, "x": 0, "y": 1 }, "height": "125px", "id": 12, "interval": "$interval", "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": "80%", "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": [ { "calculatedInterval": "10m", "datasourceErrors": {}, "errors": {}, "expr": "mysql_global_status_uptime{instance=~\"$host\"}", "format": "time_series", "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 300 } ], "thresholds": "300,3600", "title": "MySQL Uptime", "transparent": false, "type": "singlestat", "valueFontSize": "80%", "valueMaps": [], "valueName": "current" }, { "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": "Prometheus", "decimals": 2, "description": "**Current QPS**\n\nBased on the queries reported by MySQL's ``SHOW STATUS`` command, it is the number of statements executed by the server within the last second. This variable includes statements executed within stored programs, unlike the Questions variable. It does not count \n``COM_PING`` or ``COM_STATISTICS`` commands.", "editable": true, "error": false, "format": "short", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 2, "w": 6, "x": 6, "y": 1 }, "height": "125px", "id": 13, "interval": "$interval", "links": [ { "targetBlank": true, "title": "MySQL Server St