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",
65 "colorBackground": true,
72 "datasource": "Prometheus",
78 "thresholdLabels": false,
79 "thresholdMarkers": true
93 "name": "value to text",
97 "name": "range to text",
101 "maxDataPoints": 100,
102 "nullPointMode": "connected",
106 "postfixFontSize": "50%",
108 "prefixFontSize": "50%",
117 "fillColor": "rgba(31, 118, 189, 0.18)",
119 "lineColor": "rgb(31, 120, 193)",
125 "expr": "mysql_up{release=\"$release\"}",
126 "format": "time_series",
132 "title": "Instance Up",
133 "type": "singlestat",
134 "valueFontSize": "80%",
142 "valueName": "current"
145 "cacheTimeout": null,
146 "colorBackground": true,
150 "rgba(237, 129, 40, 0.89)",
153 "datasource": "Prometheus",
159 "thresholdLabels": false,
160 "thresholdMarkers": true
174 "name": "value to text",
178 "name": "range to text",
182 "maxDataPoints": 100,
183 "nullPointMode": "connected",
187 "postfixFontSize": "50%",
189 "prefixFontSize": "50%",
198 "fillColor": "rgba(31, 118, 189, 0.18)",
200 "lineColor": "rgb(31, 120, 193)",
206 "expr": "mysql_global_status_uptime{release=\"$release\"}",
207 "format": "time_series",
212 "thresholds": "25200,32400",
214 "type": "singlestat",
215 "valueFontSize": "80%",
223 "valueName": "current"
230 "datasource": "Prometheus",
252 "nullPointMode": "null",
260 "seriesOverrides": [],
263 "steppedLine": false,
266 "expr": "mysql_global_status_max_used_connections{release=\"$release\"}",
267 "format": "time_series",
269 "legendFormat": "current",
273 "expr": "mysql_global_variables_max_connections{release=\"$release\"}",
274 "format": "time_series",
276 "legendFormat": "Max",
284 "title": "Mysql Connections",
288 "value_type": "individual"
339 "datasource": "Prometheus",
361 "nullPointMode": "null",
372 "transform": "negative-Y"
377 "steppedLine": false,
380 "expr": "irate(mysql_global_status_innodb_data_reads{release=\"$release\"}[10m])",
381 "format": "time_series",
383 "legendFormat": "reads",
387 "expr": "irate(mysql_global_status_innodb_data_writes{release=\"$release\"}[10m])",
388 "format": "time_series",
390 "legendFormat": "write",
398 "title": "mysql disk reads vs writes",
402 "value_type": "individual"
440 "datasource": "Prometheus",
462 "nullPointMode": "null",
473 "transform": "negative-Y"
478 "steppedLine": false,
481 "expr": "irate(mysql_global_status_bytes_received{release=\"$release\"}[5m])",
482 "format": "time_series",
484 "legendFormat": "received",
488 "expr": "irate(mysql_global_status_bytes_sent{release=\"$release\"}[5m])",
489 "format": "time_series",
491 "legendFormat": "sent",
499 "title": "mysql network received vs sent",
503 "value_type": "individual"
541 "datasource": "Prometheus",
563 "nullPointMode": "null",
571 "seriesOverrides": [],
574 "steppedLine": false,
577 "expr": "irate(mysql_global_status_commands_total{release=\"$release\"}[5m]) > 0",
578 "format": "time_series",
580 "legendFormat": "{{ command }} - {{ release }}",
588 "title": "Query rates",
592 "value_type": "individual"
630 "datasource": "Prometheus",
652 "nullPointMode": "null",
660 "seriesOverrides": [],
663 "steppedLine": false,
666 "expr": "mysql_global_status_threads_running{release=\"$release\"} ",
667 "format": "time_series",
676 "title": "Running Threads",
680 "value_type": "individual"
732 "datasource": "Prometheus",
733 "description": "The number of connections that were aborted because the client died without closing the connection properly.",
755 "nullPointMode": "null",
763 "seriesOverrides": [],
766 "steppedLine": false,
769 "expr": "mysql_global_status_aborted_clients{release=\"$release\"}",
770 "format": "time_series",
779 "title": "Aborted clients",
783 "value_type": "individual"
821 "datasource": "Prometheus",
822 "description": "The number of failed attempts to connect to the MySQL server.",
844 "nullPointMode": "null",
852 "seriesOverrides": [],
855 "steppedLine": false,
858 "expr": "mysql_global_status_aborted_connects{release=\"$release\"}",
859 "format": "time_series",
869 "title": "mysql aborted Connects",
873 "value_type": "individual"
916 "title": "Disk usage",
924 "datasource": "Prometheus",
946 "nullPointMode": "null",
954 "seriesOverrides": [],
957 "steppedLine": false,
960 "expr": "sum(mysql_info_schema_table_size{component=\"data_length\",release=\"$release\"})",
961 "format": "time_series",
963 "legendFormat": "Tables",
967 "expr": "sum(mysql_info_schema_table_size{component=\"index_length\",release=\"$release\"})",
968 "format": "time_series",
970 "legendFormat": "Indexes",
978 "title": "Disk usage tables / indexes",
982 "value_type": "individual"
994 "format": "decbytes",
1020 "datasource": "Prometheus",
1042 "nullPointMode": "null",
1046 "percentage": false,
1050 "seriesOverrides": [],
1053 "steppedLine": false,
1056 "expr": "sum(mysql_info_schema_table_rows{release=\"$release\"})",
1057 "format": "time_series",
1058 "intervalFactor": 1,
1066 "title": "Sum of all rows",
1070 "value_type": "individual"
1105 "schemaVersion": 19,
1118 "datasource": "Prometheus",
1121 "includeAll": false,
1126 "query": "label_values(mysql_up,release)",
1129 "skipUrlSync": false,
1131 "tagValuesQuery": "",
1144 "refresh_intervals": [