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 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