6 "datasource": "-- Grafana --",
9 "iconColor": "rgba(0, 211, 255, 1)",
10 "name": "Annotations & Alerts",
15 "description": "Mysql dashboard",
20 "iteration": 1569307668513,
33 "title": "Global status",
38 "colorBackground": true,
45 "datasource": "prometheus - Juju generated source",
51 "thresholdLabels": false,
52 "thresholdMarkers": true
66 "name": "value to text",
70 "name": "range to text",
75 "nullPointMode": "connected",
79 "postfixFontSize": "50%",
81 "prefixFontSize": "50%",
90 "fillColor": "rgba(31, 118, 189, 0.18)",
92 "lineColor": "rgb(31, 120, 193)",
98 "expr": "mysql_up{release=\"$release\"}",
99 "format": "time_series",
105 "title": "Instance Up",
106 "type": "singlestat",
107 "valueFontSize": "80%",
115 "valueName": "current"
118 "cacheTimeout": null,
119 "colorBackground": true,
123 "rgba(237, 129, 40, 0.89)",
126 "datasource": "prometheus - Juju generated source",
132 "thresholdLabels": false,
133 "thresholdMarkers": true
147 "name": "value to text",
151 "name": "range to text",
155 "maxDataPoints": 100,
156 "nullPointMode": "connected",
160 "postfixFontSize": "50%",
162 "prefixFontSize": "50%",
171 "fillColor": "rgba(31, 118, 189, 0.18)",
173 "lineColor": "rgb(31, 120, 193)",
179 "expr": "mysql_global_status_uptime{release=\"$release\"}",
180 "format": "time_series",
185 "thresholds": "25200,32400",
187 "type": "singlestat",
188 "valueFontSize": "80%",
196 "valueName": "current"
203 "datasource": "prometheus - Juju generated source",
225 "nullPointMode": "null",
233 "seriesOverrides": [],
236 "steppedLine": false,
239 "expr": "mysql_global_status_max_used_connections{release=\"$release\"}",
240 "format": "time_series",
242 "legendFormat": "current",
246 "expr": "mysql_global_variables_max_connections{release=\"$release\"}",
247 "format": "time_series",
249 "legendFormat": "Max",
257 "title": "Mysql Connections",
261 "value_type": "individual"
312 "datasource": "prometheus - Juju generated source",
334 "nullPointMode": "null",
345 "transform": "negative-Y"
350 "steppedLine": false,
353 "expr": "irate(mysql_global_status_innodb_data_reads{release=\"$release\"}[10m])",
354 "format": "time_series",
356 "legendFormat": "reads",
360 "expr": "irate(mysql_global_status_innodb_data_writes{release=\"$release\"}[10m])",
361 "format": "time_series",
363 "legendFormat": "write",
371 "title": "mysql disk reads vs writes",
375 "value_type": "individual"
413 "datasource": "prometheus - Juju generated source",
435 "nullPointMode": "null",
446 "transform": "negative-Y"
451 "steppedLine": false,
454 "expr": "irate(mysql_global_status_bytes_received{release=\"$release\"}[5m])",
455 "format": "time_series",
457 "legendFormat": "received",
461 "expr": "irate(mysql_global_status_bytes_sent{release=\"$release\"}[5m])",
462 "format": "time_series",
464 "legendFormat": "sent",
472 "title": "mysql network received vs sent",
476 "value_type": "individual"
514 "datasource": "prometheus - Juju generated source",
536 "nullPointMode": "null",
544 "seriesOverrides": [],
547 "steppedLine": false,
550 "expr": "irate(mysql_global_status_commands_total{release=\"$release\"}[5m]) > 0",
551 "format": "time_series",
553 "legendFormat": "{{ command }} - {{ release }}",
561 "title": "Query rates",
565 "value_type": "individual"
603 "datasource": "prometheus - Juju generated source",
625 "nullPointMode": "null",
633 "seriesOverrides": [],
636 "steppedLine": false,
639 "expr": "mysql_global_status_threads_running{release=\"$release\"} ",
640 "format": "time_series",
649 "title": "Running Threads",
653 "value_type": "individual"
705 "datasource": "prometheus - Juju generated source",
706 "description": "The number of connections that were aborted because the client died without closing the connection properly.",
728 "nullPointMode": "null",
736 "seriesOverrides": [],
739 "steppedLine": false,
742 "expr": "mysql_global_status_aborted_clients{release=\"$release\"}",
743 "format": "time_series",
752 "title": "Aborted clients",
756 "value_type": "individual"
794 "datasource": "prometheus - Juju generated source",
795 "description": "The number of failed attempts to connect to the MySQL server.",
817 "nullPointMode": "null",
825 "seriesOverrides": [],
828 "steppedLine": false,
831 "expr": "mysql_global_status_aborted_connects{release=\"$release\"}",
832 "format": "time_series",
842 "title": "mysql aborted Connects",
846 "value_type": "individual"
889 "title": "Disk usage",
897 "datasource": "prometheus - Juju generated source",
919 "nullPointMode": "null",
927 "seriesOverrides": [],
930 "steppedLine": false,
933 "expr": "sum(mysql_info_schema_table_size{component=\"data_length\",release=\"$release\"})",
934 "format": "time_series",
936 "legendFormat": "Tables",
940 "expr": "sum(mysql_info_schema_table_size{component=\"index_length\",release=\"$release\"})",
941 "format": "time_series",
943 "legendFormat": "Indexes",
951 "title": "Disk usage tables / indexes",
955 "value_type": "individual"
967 "format": "decbytes",
993 "datasource": "prometheus - Juju generated source",
1015 "nullPointMode": "null",
1019 "percentage": false,
1023 "seriesOverrides": [],
1026 "steppedLine": false,
1029 "expr": "sum(mysql_info_schema_table_rows{release=\"$release\"})",
1030 "format": "time_series",
1031 "intervalFactor": 1,
1039 "title": "Sum of all rows",
1043 "value_type": "individual"
1078 "schemaVersion": 19,
1091 "datasource": "prometheus - Juju generated source",
1094 "includeAll": false,
1099 "query": "label_values(mysql_up,release)",
1102 "skipUrlSync": false,
1104 "tagValuesQuery": "",
1117 "refresh_intervals": [