Created
June 29, 2021 03:38
-
-
Save michaelcoburn/cfc13a055169e8afb518c2d4f1cad5ba to your computer and use it in GitHub Desktop.
MySQL Semi-Sync Summary Dashboard for Percona Monitoring and Management PMM
This file contains hidden or 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": false, | |
| "hide": false, | |
| "iconColor": "#e0752d", | |
| "limit": 100, | |
| "matchAny": true, | |
| "name": "PMM Annotations", | |
| "showIn": 0, | |
| "tags": [ | |
| "pmm_annotation", | |
| "$service_name" | |
| ], | |
| "type": "tags" | |
| }, | |
| { | |
| "builtIn": 1, | |
| "datasource": "-- Grafana --", | |
| "enable": true, | |
| "hide": true, | |
| "iconColor": "#6ed0e0", | |
| "limit": 100, | |
| "name": "Annotations & Alerts", | |
| "showIn": 0, | |
| "tags": [], | |
| "type": "dashboard" | |
| } | |
| ] | |
| }, | |
| "editable": false, | |
| "gnetId": null, | |
| "graphTooltip": 1, | |
| "id": 544, | |
| "iteration": 1624935956671, | |
| "links": [ | |
| { | |
| "icon": "doc", | |
| "includeVars": true, | |
| "keepTime": true, | |
| "tags": [ | |
| "Home" | |
| ], | |
| "targetBlank": false, | |
| "title": "Home", | |
| "type": "link", | |
| "url": "/graph/d/pmm-home/home-dashboard" | |
| }, | |
| { | |
| "icon": "dashboard", | |
| "includeVars": true, | |
| "keepTime": true, | |
| "tags": [ | |
| "Query Analytics" | |
| ], | |
| "targetBlank": false, | |
| "title": "Query Analytics", | |
| "type": "link", | |
| "url": "/graph/d/pmm-qan/pmm-query-analytics" | |
| }, | |
| { | |
| "icon": "bolt", | |
| "includeVars": true, | |
| "keepTime": true, | |
| "tags": [ | |
| "Compare" | |
| ], | |
| "targetBlank": false, | |
| "title": "Compare", | |
| "type": "link", | |
| "url": "/graph/d/mysql-instance-compare/mysql-instances-compare" | |
| }, | |
| { | |
| "asDropdown": true, | |
| "includeVars": true, | |
| "keepTime": true, | |
| "tags": [ | |
| "MySQL" | |
| ], | |
| "targetBlank": false, | |
| "title": "MySQL", | |
| "type": "dashboards" | |
| }, | |
| { | |
| "asDropdown": true, | |
| "includeVars": true, | |
| "keepTime": true, | |
| "tags": [ | |
| "MySQL_HA" | |
| ], | |
| "targetBlank": false, | |
| "title": "HA", | |
| "type": "dashboards" | |
| }, | |
| { | |
| "asDropdown": true, | |
| "includeVars": false, | |
| "keepTime": true, | |
| "tags": [ | |
| "Services" | |
| ], | |
| "targetBlank": false, | |
| "title": "Services", | |
| "type": "dashboards" | |
| }, | |
| { | |
| "asDropdown": true, | |
| "includeVars": false, | |
| "keepTime": true, | |
| "tags": [ | |
| "PMM" | |
| ], | |
| "targetBlank": false, | |
| "title": "PMM", | |
| "type": "dashboards" | |
| } | |
| ], | |
| "panels": [ | |
| { | |
| "breadcrumbItemsMaxAmount": 6, | |
| "datasource": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "hideTextInRootDashboard": false, | |
| "id": 999, | |
| "isRootDashboard": false, | |
| "links": [], | |
| "targets": [ | |
| { | |
| "expr": "", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": " ", | |
| "transparent": true, | |
| "type": "digiapulssi-breadcrumb-panel" | |
| }, | |
| { | |
| "backgroundColor": "rgba(128,128,128,0.1)", | |
| "colorMaps": [ | |
| { | |
| "$$hashKey": "object:854", | |
| "color": "#ADA", | |
| "text": "Enabled" | |
| }, | |
| { | |
| "$$hashKey": "object:925", | |
| "color": "#F2495C", | |
| "text": "Disabled" | |
| } | |
| ], | |
| "crosshairColor": "#8F070C", | |
| "datasource": null, | |
| "description": "Replica status", | |
| "display": "timeline", | |
| "expandFromQueryS": 0, | |
| "extendLastValue": true, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 24, | |
| "x": 0, | |
| "y": 2 | |
| }, | |
| "highlightOnMouseover": true, | |
| "id": 1005, | |
| "legendSortBy": "-ms", | |
| "lineColor": "rgba(0,0,0,0.1)", | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "SHOW SLAVE STATUS Syntax", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html" | |
| }, | |
| { | |
| "targetBlank": true, | |
| "title": "Improving replication performance", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-performance.html" | |
| }, | |
| { | |
| "targetBlank": true, | |
| "title": "Replication Slave Options and Variables", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/replication-options-slave.html" | |
| } | |
| ], | |
| "metricNameColor": "#000000", | |
| "pluginVersion": "7.3.7", | |
| "rangeMaps": [ | |
| { | |
| "$$hashKey": "object:845", | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "rowHeight": 50, | |
| "showLegend": true, | |
| "showLegendNames": true, | |
| "showLegendPercent": true, | |
| "showLegendValues": true, | |
| "showTimeAxis": true, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "avg by (service_name) (\nmysql_global_status_rpl_semi_sync_slave_status{replication_set=~\"$replication_set\"}[$interval] or mysql_global_status_rpl_semi_sync_slave_status{replication_set=~\"$replication_set\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{service_name}}", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| } | |
| ], | |
| "textSize": 24, | |
| "textSizeTime": 12, | |
| "timeFrom": null, | |
| "timeOptions": [ | |
| { | |
| "name": "Years", | |
| "value": "years" | |
| }, | |
| { | |
| "name": "Months", | |
| "value": "months" | |
| }, | |
| { | |
| "name": "Weeks", | |
| "value": "weeks" | |
| }, | |
| { | |
| "name": "Days", | |
| "value": "days" | |
| }, | |
| { | |
| "name": "Hours", | |
| "value": "hours" | |
| }, | |
| { | |
| "name": "Minutes", | |
| "value": "minutes" | |
| }, | |
| { | |
| "name": "Seconds", | |
| "value": "seconds" | |
| }, | |
| { | |
| "name": "Milliseconds", | |
| "value": "milliseconds" | |
| } | |
| ], | |
| "timePrecision": { | |
| "name": "Minutes", | |
| "value": "minutes" | |
| }, | |
| "timeShift": null, | |
| "timeTextColor": "#d8d9da", | |
| "title": "Replica Status Enabled", | |
| "type": "natel-discrete-panel", | |
| "units": "short", | |
| "useTimePrecision": false, | |
| "valueMaps": [ | |
| { | |
| "$$hashKey": "object:841", | |
| "op": "=", | |
| "text": "Enabled", | |
| "value": "1" | |
| }, | |
| { | |
| "$$hashKey": "object:842", | |
| "op": "=", | |
| "text": "Disabled", | |
| "value": "0" | |
| } | |
| ], | |
| "valueTextColor": "#000000", | |
| "writeAllValues": false, | |
| "writeLastValue": true, | |
| "writeMetricNames": false | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "description": "The total number of times the source waited for transactions.\n\nNet will be the total of all Replicas, TX will be just the base number of transactions replicated.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 8 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 33, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "Configuring replication", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/replication-configuration.html" | |
| } | |
| ], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "avg by (service_name) (rate(mysql_global_status_rpl_semi_sync_master_net_waits{replication_set=~\"$replication_set\"}[$interval]) or irate(mysql_global_status_rpl_semi_sync_master_net_waits{replication_set=~\"$replication_set\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Net Waits", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "avg by (service_name) (rate(mysql_global_status_rpl_semi_sync_master_tx_waits{replication_set=~\"$replication_set\"}[$interval]) or irate(mysql_global_status_rpl_semi_sync_master_tx_waits{replication_set=~\"$replication_set\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "TX Waits", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Waits by Net & TX", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 2, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "none", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "description": "The total number of times the source waited for transactions.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 8 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 1002, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Size", | |
| "color": "#1F78C1" | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "avg by (service_name) (rate(mysql_global_status_rpl_semi_sync_master_tx_wait_time{replication_set=~\"$replication_set\"}[$interval]) or irate(mysql_global_status_rpl_semi_sync_master_tx_wait_time{replication_set=~\"$replication_set\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "TX Waits", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "TX Wait time (us)", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 5, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "µs", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "description": "The average time in microseconds the source waited for each transaction.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 16 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 1003, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "The binary log", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/binary-log.html" | |
| }, | |
| { | |
| "targetBlank": true, | |
| "title": "Configuring replication", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/replication-configuration.html" | |
| } | |
| ], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Size", | |
| "color": "#1F78C1" | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "avg by (service_name) (mysql_global_status_rpl_semi_sync_master_tx_avg_wait_time{replication_set=~\"$replication_set\"}[$interval] or mysql_global_status_rpl_semi_sync_master_tx_avg_wait_time{replication_set=~\"$replication_set\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "TX Waits", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Per Transaction Avg Wait time (us)", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 5, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "µs", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "description": "The number of commits that were and were not acknowledged successfully by a replica.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 16 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 1004, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "The binary log", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/binary-log.html" | |
| }, | |
| { | |
| "targetBlank": true, | |
| "title": "Configuring replication", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/replication-configuration.html" | |
| } | |
| ], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "7.3.7", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Size", | |
| "color": "#1F78C1" | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "avg by (service_name) (rate(mysql_global_status_rpl_semi_sync_master_yes_tx{replication_set=~\"$replication_set\"}[$interval]) or irate(mysql_global_status_rpl_semi_sync_master_yes_tx{replication_set=~\"$replication_set\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Acknowledged", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "avg by (service_name) (rate(mysql_global_status_rpl_semi_sync_master_no_tx{replication_set=~\"$replication_set\"}[$interval]) or irate(mysql_global_status_rpl_semi_sync_master_no_tx{replication_set=~\"$replication_set\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Not Acklowledged", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Commit Acknowledgements", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 5, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "none", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "refresh": false, | |
| "schemaVersion": 26, | |
| "style": "dark", | |
| "tags": [ | |
| "Percona", | |
| "MySQL_HA" | |
| ], | |
| "templating": { | |
| "list": [ | |
| { | |
| "allFormat": "glob", | |
| "auto": true, | |
| "auto_count": 200, | |
| "auto_min": "1s", | |
| "current": { | |
| "selected": false, | |
| "text": "auto", | |
| "value": "$__auto_interval_interval" | |
| }, | |
| "datasource": "Metrics", | |
| "error": null, | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "Interval", | |
| "multi": false, | |
| "multiFormat": "glob", | |
| "name": "interval", | |
| "options": [ | |
| { | |
| "selected": true, | |
| "text": "auto", | |
| "value": "$__auto_interval_interval" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1s", | |
| "value": "1s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5s", | |
| "value": "5s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1m", | |
| "value": "1m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5m", | |
| "value": "5m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1h", | |
| "value": "1h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "6h", | |
| "value": "6h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1d", | |
| "value": "1d" | |
| } | |
| ], | |
| "query": "1s,5s,1m,5m,1h,6h,1d", | |
| "refresh": 2, | |
| "skipUrlSync": false, | |
| "type": "interval" | |
| }, | |
| { | |
| "allValue": ".*", | |
| "current": { | |
| "selected": false, | |
| "text": "semi-sync", | |
| "value": "semi-sync" | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values(mysql_up, replication_set)", | |
| "error": null, | |
| "hide": 0, | |
| "includeAll": true, | |
| "label": "Replication Set", | |
| "multi": false, | |
| "name": "replication_set", | |
| "options": [], | |
| "query": "label_values(mysql_up, replication_set)", | |
| "refresh": 2, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": ".*", | |
| "current": { | |
| "selected": false, | |
| "text": "ps80p-mysql", | |
| "value": "ps80p-mysql" | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values(mysql_up{replication_set=~\"$replication_set\"}, service_name)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": "Service Name", | |
| "multi": false, | |
| "name": "service_name", | |
| "options": [], | |
| "query": "label_values(mysql_up{replication_set=~\"$replication_set\"}, service_name)", | |
| "refresh": 2, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allFormat": "glob", | |
| "allValue": null, | |
| "current": { | |
| "selected": false, | |
| "text": "matebook", | |
| "value": "matebook" | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values(mysql_up{service_name=~\"$service_name\"}, node_name)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": "Node Name", | |
| "multi": false, | |
| "multiFormat": "regex values", | |
| "name": "node_name", | |
| "options": [], | |
| "query": "label_values(mysql_up{service_name=~\"$service_name\"}, node_name)", | |
| "refresh": 2, | |
| "refresh_on_load": false, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": null, | |
| "tags": [], | |
| "tagsQuery": null, | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": false, | |
| "text": "8.0.23-14", | |
| "value": "8.0.23-14" | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "query_result(mysql_version_info{service_name=~\"$service_name\"})", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "version", | |
| "options": [], | |
| "query": "query_result(mysql_version_info{service_name=~\"$service_name\"})", | |
| "refresh": 2, | |
| "regex": "/(([0-9\\.]+)\\.([0-9\\.]+)\\.([0-9\\.]+)-?([0-9?]+))/", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": false, | |
| "text": "ps80p-mysql", | |
| "value": "ps80p-mysql" | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values(mysql_up{service_name=~\"$service_name\"}, service_name)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": "Service Name", | |
| "multi": false, | |
| "name": "crop_service", | |
| "options": [], | |
| "query": "label_values(mysql_up{service_name=~\"$service_name\"}, service_name)", | |
| "refresh": 2, | |
| "regex": "/(.?.?.?.?.?.?.?.?.?.?.?.?.?).*/", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allFormat": "glob", | |
| "allValue": null, | |
| "current": { | |
| "selected": false, | |
| "text": "matebook", | |
| "value": "matebook" | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values(mysql_up{node_name=\"$node_name\"},node_name)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": "Crop Node Name", | |
| "multi": false, | |
| "multiFormat": "regex values", | |
| "name": "crop_host", | |
| "options": [], | |
| "query": "label_values(mysql_up{node_name=\"$node_name\"},node_name)", | |
| "refresh": 2, | |
| "refresh_on_load": false, | |
| "regex": "/(.?.?.?.?.?.?.?.?.?.?.?.?.?).*/", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": null, | |
| "tags": [], | |
| "tagsQuery": null, | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": ".*", | |
| "current": { | |
| "selected": true, | |
| "text": [ | |
| "All" | |
| ], | |
| "value": [ | |
| "$__all" | |
| ] | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, environment)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": true, | |
| "label": "Environment", | |
| "multi": true, | |
| "name": "environment", | |
| "options": [], | |
| "query": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, environment)", | |
| "refresh": 2, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": true, | |
| "text": [ | |
| "All" | |
| ], | |
| "value": [ | |
| "$__all" | |
| ] | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, cluster)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": true, | |
| "label": "Cluster", | |
| "multi": true, | |
| "name": "cluster", | |
| "options": [], | |
| "query": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, cluster)", | |
| "refresh": 2, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": true, | |
| "text": [ | |
| "All" | |
| ], | |
| "value": [ | |
| "$__all" | |
| ] | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values(pg_stat_database_tup_fetched{service_name=~\"$service_name\",datname!~\"template.*|postgres\"},datname)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": true, | |
| "label": "Database", | |
| "multi": true, | |
| "name": "database", | |
| "options": [], | |
| "query": "label_values(pg_stat_database_tup_fetched{service_name=~\"$service_name\",datname!~\"template.*|postgres\"},datname)", | |
| "refresh": 1, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": true, | |
| "text": [ | |
| "All" | |
| ], | |
| "value": [ | |
| "$__all" | |
| ] | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, node_type)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": true, | |
| "label": "Type", | |
| "multi": true, | |
| "name": "node_type", | |
| "options": [], | |
| "query": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, node_type)", | |
| "refresh": 1, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": true, | |
| "text": [ | |
| "All" | |
| ], | |
| "value": [ | |
| "$__all" | |
| ] | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, service_type)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": true, | |
| "label": "Type", | |
| "multi": true, | |
| "name": "service_type", | |
| "options": [], | |
| "query": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, service_type)", | |
| "refresh": 1, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": true, | |
| "text": [ | |
| "All" | |
| ], | |
| "value": [ | |
| "$__all" | |
| ] | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values(mysql_info_schema_user_statistics_connected_time_seconds_total{service_name=\"$service_name\"},user)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": true, | |
| "label": "Username", | |
| "multi": true, | |
| "name": "username", | |
| "options": [], | |
| "query": "label_values(mysql_info_schema_user_statistics_connected_time_seconds_total{service_name=\"$service_name\"},user)", | |
| "refresh": 1, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": true, | |
| "text": [ | |
| "All" | |
| ], | |
| "value": [ | |
| "$__all" | |
| ] | |
| }, | |
| "datasource": "Metrics", | |
| "definition": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, schema)", | |
| "error": null, | |
| "hide": 2, | |
| "includeAll": true, | |
| "label": "Schema", | |
| "multi": true, | |
| "name": "schema", | |
| "options": [], | |
| "query": "label_values({__name__=~\"pg_up|mysql_up|mongodb_up|proxysql_mysql_status_active_transactions\"}, schema)", | |
| "refresh": 1, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 5, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "2021-06-27T23:51:34.000Z", | |
| "to": "2021-06-28T06:10:30.000Z" | |
| }, | |
| "timepicker": { | |
| "collapse": false, | |
| "enable": true, | |
| "hidden": false, | |
| "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" | |
| }, | |
| "timezone": "browser", | |
| "title": "MySQL Semi-Sync Summary", | |
| "uid": "mysql-semi-sync-summary", | |
| "version": 25 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment