1 # Copyright 2019 Minsait - Indra S.A.
3 # Licensed under the Apache License, Version 2.0 (the "License");
4 # you may not use this file except in compliance with the License.
5 # You may obtain a copy of the License at
7 # http://www.apache.org/licenses/LICENSE-2.0
9 # Unless required by applicable law or agreed to in writing, software
10 # distributed under the License is distributed on an "AS IS" BASIS,
11 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12 # See the License for the specific language governing permissions and
13 # limitations under the License.
14 # Author: Jose Manuel Palacios (jmpalacios@minsait.com)
15 # Author: Jose Antonio Martinez (jamartinezv@minsait.com)
21 app: prometheus-mysql-exporter-grafana
22 grafana_dashboard: "1"
23 name: osm-monitoring-prometheus-mysql-exporter-grafana
25 k8s-sidecar-target-directory: "/tmp/dashboards/Open Source MANO"
27 mysql-exporter-dashboard.json: |-
33 "datasource": "-- Grafana --",
36 "iconColor": "rgba(0, 211, 255, 1)",
37 "name": "Annotations & Alerts",
42 "description": "Mysql dashboard",
47 "iteration": 1569307668513,
60 "title": "Global status",
72 "title": "Instance Up",
73 "datasource": "Prometheus",
80 "expr": "mysql_up{release=\"$release\"}",
81 "format": "time_series",
131 "orientation": "horizontal",
134 "colorMode": "background",
136 "justifyMode": "auto"
138 "pluginVersion": "8.1.1"
141 "cacheTimeout": null,
142 "colorBackground": true,
146 "rgba(237, 129, 40, 0.89)",
149 "datasource": "Prometheus",
155 "thresholdLabels": false,
156 "thresholdMarkers": true
170 "name": "value to text",
174 "name": "range to text",
178 "maxDataPoints": 100,
179 "nullPointMode": "connected",
183 "postfixFontSize": "50%",
185 "prefixFontSize": "50%",
194 "fillColor": "rgba(31, 118, 189, 0.18)",
196 "lineColor": "rgb(31, 120, 193)",
202 "expr": "mysql_global_status_uptime{release=\"$release\"}",
203 "format": "time_series",
208 "thresholds": "25200,32400",
210 "type": "singlestat",
211 "valueFontSize": "80%",
219 "valueName": "current"
226 "datasource": "Prometheus",
248 "nullPointMode": "null",
256 "seriesOverrides": [],
259 "steppedLine": false,
262 "expr": "mysql_global_status_max_used_connections{release=\"$release\"}",
263 "format": "time_series",
265 "legendFormat": "current",
269 "expr": "mysql_global_variables_max_connections{release=\"$release\"}",
270 "format": "time_series",
272 "legendFormat": "Max",
280 "title": "Mysql Connections",
284 "value_type": "individual"
335 "datasource": "Prometheus",
357 "nullPointMode": "null",
368 "transform": "negative-Y"
373 "steppedLine": false,
376 "expr": "irate(mysql_global_status_innodb_data_reads{release=\"$release\"}[10m])",
377 "format": "time_series",
379 "legendFormat": "reads",
383 "expr": "irate(mysql_global_status_innodb_data_writes{release=\"$release\"}[10m])",
384 "format": "time_series",
386 "legendFormat": "write",
394 "title": "mysql disk reads vs writes",
398 "value_type": "individual"
436 "datasource": "Prometheus",
458 "nullPointMode": "null",
469 "transform": "negative-Y"
474 "steppedLine": false,
477 "expr": "irate(mysql_global_status_bytes_received{release=\"$release\"}[5m])",
478 "format": "time_series",
480 "legendFormat": "received",
484 "expr": "irate(mysql_global_status_bytes_sent{release=\"$release\"}[5m])",
485 "format": "time_series",
487 "legendFormat": "sent",
495 "title": "mysql network received vs sent",
499 "value_type": "individual"
537 "datasource": "Prometheus",
559 "nullPointMode": "null",
567 "seriesOverrides": [],
570 "steppedLine": false,
573 "expr": "irate(mysql_global_status_commands_total{release=\"$release\"}[5m]) > 0",
574 "format": "time_series",
576 "legendFormat": "{{ command }} - {{ release }}",
584 "title": "Query rates",
588 "value_type": "individual"
626 "datasource": "Prometheus",
648 "nullPointMode": "null",
656 "seriesOverrides": [],
659 "steppedLine": false,
662 "expr": "mysql_global_status_threads_running{release=\"$release\"} ",
663 "format": "time_series",
672 "title": "Running Threads",
676 "value_type": "individual"
728 "datasource": "Prometheus",
729 "description": "The number of connections that were aborted because the client died without closing the connection properly.",
751 "nullPointMode": "null",
759 "seriesOverrides": [],
762 "steppedLine": false,
765 "expr": "mysql_global_status_aborted_clients{release=\"$release\"}",
766 "format": "time_series",
775 "title": "Aborted clients",
779 "value_type": "individual"
817 "datasource": "Prometheus",
818 "description": "The number of failed attempts to connect to the MySQL server.",
840 "nullPointMode": "null",
848 "seriesOverrides": [],
851 "steppedLine": false,
854 "expr": "mysql_global_status_aborted_connects{release=\"$release\"}",
855 "format": "time_series",
865 "title": "mysql aborted Connects",
869 "value_type": "individual"
912 "title": "Disk usage",
920 "datasource": "Prometheus",
942 "nullPointMode": "null",
950 "seriesOverrides": [],
953 "steppedLine": false,
956 "expr": "sum(mysql_info_schema_table_size{component=\"data_length\",release=\"$release\"})",
957 "format": "time_series",
959 "legendFormat": "Tables",
963 "expr": "sum(mysql_info_schema_table_size{component=\"index_length\",release=\"$release\"})",
964 "format": "time_series",
966 "legendFormat": "Indexes",
974 "title": "Disk usage tables / indexes",
978 "value_type": "individual"
990 "format": "decbytes",
1016 "datasource": "Prometheus",
1038 "nullPointMode": "null",
1042 "percentage": false,
1046 "seriesOverrides": [],
1049 "steppedLine": false,
1052 "expr": "sum(mysql_info_schema_table_rows{release=\"$release\"})",
1053 "format": "time_series",
1054 "intervalFactor": 1,
1062 "title": "Sum of all rows",
1066 "value_type": "individual"
1101 "schemaVersion": 19,
1114 "datasource": "Prometheus",
1117 "includeAll": false,
1122 "query": "label_values(mysql_up,release)",
1125 "skipUrlSync": false,
1127 "tagValuesQuery": "",
1140 "refresh_intervals": [