6 "datasource": "-- Grafana --",
9 "iconColor": "rgba(0, 211, 255, 1)",
10 "name": "Annotations & Alerts",
39 "title": "General status",
43 "datasource": "Prometheus",
58 "color": "semi-dark-green",
80 "color": "dark-green",
103 "options": "Total replicas"
113 "color": "dark-green",
134 "colorMode": "background",
136 "justifyMode": "center",
137 "orientation": "vertical",
146 "textMode": "value_and_name"
148 "pluginVersion": "8.1.0",
153 "format": "time_series",
157 "legendFormat": "{{ pod }}",
163 "title": "Service Status",
166 "id": "calculateField",
168 "alias": "Total replicas",
174 "replaceFields": false
181 "datasource": "Prometheus",
219 "color": "light-blue",
237 "colorMode": "value",
239 "justifyMode": "center",
240 "orientation": "vertical",
252 "textMode": "value_and_name"
254 "pluginVersion": "8.1.0",
258 "expr": "mysql_global_status_uptime",
259 "format": "time_series",
262 "legendFormat": "{{ pod }}",
268 "title": "Service uptime",
269 "transformations": [],
273 "cacheTimeout": null,
274 "datasource": "Prometheus",
275 "description": "Displays current active connections count and configured maximum value",
279 "fixedColor": "semi-dark-green",
280 "mode": "continuous-BlYlRd"
320 "maxDataPoints": 100,
322 "displayMode": "basic",
323 "orientation": "vertical",
329 "showUnfilled": false,
332 "pluginVersion": "8.1.0",
336 "expr": "mysql_global_status_threads_connected",
337 "format": "time_series",
341 "legendFormat": "{{ pod }} (current)",
346 "expr": "mysql_global_variables_max_connections",
350 "legendFormat": "{{ pod }} (max)",
354 "title": "Active Connections with max value",
355 "transformations": [],
369 "title": "Connections/Commands",
377 "datasource": "Prometheus",
379 "description": "Shows number of open connections and max used connections",
388 "hiddenSeries": false,
391 "alignAsTable": true,
406 "nullPointMode": "null",
408 "alertThreshold": false
411 "pluginVersion": "8.1.0",
415 "seriesOverrides": [],
418 "steppedLine": false,
422 "expr": "mysql_global_status_threads_connected",
423 "format": "time_series",
427 "legendFormat": "Active Connections - {{ pod }}",
432 "expr": "mysql_global_status_max_used_connections",
433 "format": "time_series",
437 "legendFormat": "Max Used Connections - {{ pod }}",
445 "title": "Connections",
449 "value_type": "individual"
461 "$$hashKey": "object:332",
470 "$$hashKey": "object:333",
489 "datasource": "Prometheus",
490 "description": "SQL command query rate per second (5m averages)",
505 "hiddenSeries": false,
508 "alignAsTable": true,
521 "nullPointMode": "null",
523 "alertThreshold": false
526 "pluginVersion": "8.1.0",
530 "seriesOverrides": [],
533 "steppedLine": false,
537 "expr": "rate(mysql_global_status_queries[5m])",
538 "format": "time_series",
542 "legendFormat": "{{ pod }}",
554 "value_type": "individual"
566 "$$hashKey": "object:391",
575 "$$hashKey": "object:392",
594 "datasource": "Prometheus",
595 "description": "Top 5 sql commands over 5 minute time frames by each replica",
604 "hiddenSeries": false,
607 "alignAsTable": false,
619 "nullPointMode": "null",
621 "alertThreshold": true
624 "pluginVersion": "8.1.0",
628 "seriesOverrides": [],
631 "steppedLine": false,
635 "expr": "topk(5, rate(mysql_global_status_commands_total[5m]))",
636 "format": "time_series",
639 "legendFormat": "{{ command }} - {{ pod }}",
647 "title": "Top Command Counters",
651 "value_type": "individual"
653 "transformations": [],
664 "$$hashKey": "object:2126",
673 "$$hashKey": "object:2127",
692 "datasource": "Prometheus",
702 "hiddenSeries": false,
705 "alignAsTable": true,
718 "nullPointMode": "null",
720 "alertThreshold": true
723 "pluginVersion": "8.1.0",
727 "seriesOverrides": [],
730 "steppedLine": false,
734 "expr": "irate(mysql_global_status_slow_queries[1m])",
736 "legendFormat": "Slow Queries on {{ pod }}",
744 "title": "Slow Queries",
748 "value_type": "individual"
750 "transformations": [],
761 "$$hashKey": "object:94",
770 "$$hashKey": "object:95",
789 "datasource": "Prometheus",
798 "hiddenSeries": false,
801 "alignAsTable": true,
812 "nullPointMode": "null",
814 "alertThreshold": true
817 "pluginVersion": "8.1.0",
821 "seriesOverrides": [],
824 "steppedLine": false,
828 "expr": "irate(mysql_global_status_aborted_connects[1m])",
830 "legendFormat": "Aborted Connects - {{ pod }}",
835 "expr": "irate(mysql_global_status_aborted_clients[1m])",
837 "legendFormat": "Aborted Clients - {{ pod }}",
845 "title": "Aborted Connections/Clients",
849 "value_type": "individual"
861 "$$hashKey": "object:206",
870 "$$hashKey": "object:207",
895 "title": "System stats",
903 "datasource": "Prometheus",
905 "description": "Shows the number of open files",
914 "hiddenSeries": false,
917 "alignAsTable": true,
929 "nullPointMode": "null",
931 "alertThreshold": false
934 "pluginVersion": "8.1.0",
938 "seriesOverrides": [],
941 "steppedLine": false,
945 "expr": "mysql_global_status_open_files",
947 "legendFormat": "Open Files - {{ pod }}",
952 "expr": "mysql_global_status_innodb_num_open_files",
954 "legendFormat": "InnoDB Open Files - {{ pod }}",
962 "title": "Open Files",
966 "value_type": "individual"
978 "$$hashKey": "object:2306",
987 "$$hashKey": "object:2307",
1006 "datasource": "Prometheus",
1007 "description": "Network received vs sent in 5m averages",
1016 "hiddenSeries": false,
1019 "alignAsTable": true,
1033 "nullPointMode": "null",
1035 "alertThreshold": true
1037 "percentage": false,
1038 "pluginVersion": "8.1.0",
1042 "seriesOverrides": [
1044 "$$hashKey": "object:984",
1046 "transform": "negative-Y"
1051 "steppedLine": false,
1055 "expr": "irate(mysql_global_status_bytes_received[5m])",
1056 "format": "time_series",
1059 "intervalFactor": 1,
1060 "legendFormat": "received - {{ pod }}",
1065 "expr": "irate(mysql_global_status_bytes_sent[5m])",
1066 "format": "time_series",
1068 "intervalFactor": 1,
1069 "legendFormat": "sent - {{ pod }}",
1077 "title": "Network received vs sent",
1081 "value_type": "individual"
1093 "$$hashKey": "object:991",
1102 "$$hashKey": "object:992",
1121 "datasource": "Prometheus",
1130 "hiddenSeries": false,
1133 "alignAsTable": false,
1148 "nullPointMode": "null",
1150 "alertThreshold": false
1152 "percentage": false,
1153 "pluginVersion": "8.1.0",
1157 "seriesOverrides": [
1159 "$$hashKey": "object:1802",
1161 "transform": "negative-Y"
1166 "steppedLine": false,
1170 "expr": "irate(mysql_global_status_innodb_data_reads[10m])",
1171 "format": "time_series",
1173 "intervalFactor": 1,
1174 "legendFormat": "reads - {{ pod }}",
1179 "expr": "irate(mysql_global_status_innodb_data_writes[10m])",
1180 "format": "time_series",
1182 "intervalFactor": 1,
1183 "legendFormat": "write - {{ pod }}",
1191 "title": "Disk reads vs writes",
1195 "value_type": "individual"
1207 "$$hashKey": "object:1809",
1216 "$$hashKey": "object:1810",
1232 "schemaVersion": 30,
1248 "title": "Galera/MariaDB",