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"
24 name: osm-monitoring-prometheus-mysql-exporter-grafana
26 k8s-sidecar-target-directory: "/tmp/dashboards/Open Source MANO"
28 mysql-exporter-dashboard.json: |-
34 "datasource": "-- Grafana --",
37 "iconColor": "rgba(0, 211, 255, 1)",
38 "name": "Annotations & Alerts",
43 "description": "Mysql dashboard",
48 "iteration": 1569307668513,
61 "title": "Global status",
66 "colorBackground": true,
73 "datasource": "Prometheus",
79 "thresholdLabels": false,
80 "thresholdMarkers": true
94 "name": "value to text",
98 "name": "range to text",
102 "maxDataPoints": 100,
103 "nullPointMode": "connected",
107 "postfixFontSize": "50%",
109 "prefixFontSize": "50%",
118 "fillColor": "rgba(31, 118, 189, 0.18)",
120 "lineColor": "rgb(31, 120, 193)",
126 "expr": "mysql_up{release=\"$release\"}",
127 "format": "time_series",
133 "title": "Instance Up",
134 "type": "singlestat",
135 "valueFontSize": "80%",
143 "valueName": "current"
146 "cacheTimeout": null,
147 "colorBackground": true,
151 "rgba(237, 129, 40, 0.89)",
154 "datasource": "Prometheus",
160 "thresholdLabels": false,
161 "thresholdMarkers": true
175 "name": "value to text",
179 "name": "range to text",
183 "maxDataPoints": 100,
184 "nullPointMode": "connected",
188 "postfixFontSize": "50%",
190 "prefixFontSize": "50%",
199 "fillColor": "rgba(31, 118, 189, 0.18)",
201 "lineColor": "rgb(31, 120, 193)",
207 "expr": "mysql_global_status_uptime{release=\"$release\"}",
208 "format": "time_series",
213 "thresholds": "25200,32400",
215 "type": "singlestat",
216 "valueFontSize": "80%",
224 "valueName": "current"
231 "datasource": "Prometheus",
253 "nullPointMode": "null",
261 "seriesOverrides": [],
264 "steppedLine": false,
267 "expr": "mysql_global_status_max_used_connections{release=\"$release\"}",
268 "format": "time_series",
270 "legendFormat": "current",
274 "expr": "mysql_global_variables_max_connections{release=\"$release\"}",
275 "format": "time_series",
277 "legendFormat": "Max",
285 "title": "Mysql Connections",
289 "value_type": "individual"
340 "datasource": "Prometheus",
362 "nullPointMode": "null",
373 "transform": "negative-Y"
378 "steppedLine": false,
381 "expr": "irate(mysql_global_status_innodb_data_reads{release=\"$release\"}[10m])",
382 "format": "time_series",
384 "legendFormat": "reads",
388 "expr": "irate(mysql_global_status_innodb_data_writes{release=\"$release\"}[10m])",
389 "format": "time_series",
391 "legendFormat": "write",
399 "title": "mysql disk reads vs writes",
403 "value_type": "individual"
441 "datasource": "Prometheus",
463 "nullPointMode": "null",
474 "transform": "negative-Y"
479 "steppedLine": false,
482 "expr": "irate(mysql_global_status_bytes_received{release=\"$release\"}[5m])",
483 "format": "time_series",
485 "legendFormat": "received",
489 "expr": "irate(mysql_global_status_bytes_sent{release=\"$release\"}[5m])",
490 "format": "time_series",
492 "legendFormat": "sent",
500 "title": "mysql network received vs sent",
504 "value_type": "individual"
542 "datasource": "Prometheus",
564 "nullPointMode": "null",
572 "seriesOverrides": [],
575 "steppedLine": false,
578 "expr": "irate(mysql_global_status_commands_total{release=\"$release\"}[5m]) > 0",
579 "format": "time_series",
581 "legendFormat": "{{ command }} - {{ release }}",
589 "title": "Query rates",
593 "value_type": "individual"
631 "datasource": "Prometheus",
653 "nullPointMode": "null",
661 "seriesOverrides": [],
664 "steppedLine": false,
667 "expr": "mysql_global_status_threads_running{release=\"$release\"} ",
668 "format": "time_series",
677 "title": "Running Threads",
681 "value_type": "individual"
733 "datasource": "Prometheus",
734 "description": "The number of connections that were aborted because the client died without closing the connection properly.",
756 "nullPointMode": "null",
764 "seriesOverrides": [],
767 "steppedLine": false,
770 "expr": "mysql_global_status_aborted_clients{release=\"$release\"}",
771 "format": "time_series",
780 "title": "Aborted clients",
784 "value_type": "individual"
822 "datasource": "Prometheus",
823 "description": "The number of failed attempts to connect to the MySQL server.",
845 "nullPointMode": "null",
853 "seriesOverrides": [],
856 "steppedLine": false,
859 "expr": "mysql_global_status_aborted_connects{release=\"$release\"}",
860 "format": "time_series",
870 "title": "mysql aborted Connects",
874 "value_type": "individual"
917 "title": "Disk usage",
925 "datasource": "Prometheus",
947 "nullPointMode": "null",
955 "seriesOverrides": [],
958 "steppedLine": false,
961 "expr": "sum(mysql_info_schema_table_size{component=\"data_length\",release=\"$release\"})",
962 "format": "time_series",
964 "legendFormat": "Tables",
968 "expr": "sum(mysql_info_schema_table_size{component=\"index_length\",release=\"$release\"})",
969 "format": "time_series",
971 "legendFormat": "Indexes",
979 "title": "Disk usage tables / indexes",
983 "value_type": "individual"
995 "format": "decbytes",
1021 "datasource": "Prometheus",
1043 "nullPointMode": "null",
1047 "percentage": false,
1051 "seriesOverrides": [],
1054 "steppedLine": false,
1057 "expr": "sum(mysql_info_schema_table_rows{release=\"$release\"})",
1058 "format": "time_series",
1059 "intervalFactor": 1,
1067 "title": "Sum of all rows",
1071 "value_type": "individual"
1106 "schemaVersion": 19,
1119 "datasource": "Prometheus",
1122 "includeAll": false,
1127 "query": "label_values(mysql_up,release)",
1130 "skipUrlSync": false,
1132 "tagValuesQuery": "",
1145 "refresh_intervals": [