Gitiles
Code Review Sign In
osm.etsi.org / osm / devops / e400dfdf8dd2bdd67321fa70a56cef6458533dbc / . / installers / k8s / mysql-exporter-dashboard.yaml
blob: 9c9a90b6dbdb306dc4b412e400c6f0c8f945e839 [file] [log] [blame]
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]1# Copyright 2019 Minsait - Indra S.A.
2#
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
6#
7# http://www.apache.org/licenses/LICENSE-2.0
8#
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)
16
17apiVersion: v1
18kind: ConfigMap
19metadata:
20 labels:
21 app: prometheus-mysql-exporter-grafana
22 grafana_dashboard: "1"
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]23 name: osm-monitoring-prometheus-mysql-exporter-grafana
24 annotations:
romeromonser5bed3ad2019-12-10 18:25:55 +0100[diff] [blame]25 k8s-sidecar-target-directory: "/tmp/dashboards/Open Source MANO"
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]26data:
27 mysql-exporter-dashboard.json: |-
28 {
29 "annotations": {
30 "list": [
31 {
32 "builtIn": 1,
33 "datasource": "-- Grafana --",
34 "enable": true,
35 "hide": true,
36 "iconColor": "rgba(0, 211, 255, 1)",
37 "name": "Annotations & Alerts",
38 "type": "dashboard"
39 }
40 ]
41 },
romeromonser5bed3ad2019-12-10 18:25:55 +0100[diff] [blame]42 "description": "Mysql dashboard",
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]43 "editable": true,
44 "gnetId": 6239,
45 "graphTooltip": 0,
46 "id": 34,
47 "iteration": 1569307668513,
48 "links": [],
49 "panels": [
50 {
51 "collapsed": false,
52 "gridPos": {
53 "h": 1,
54 "w": 24,
55 "x": 0,
56 "y": 0
57 },
58 "id": 17,
59 "panels": [],
60 "title": "Global status",
61 "type": "row"
62 },
63 {
limon00d428d2022-03-01 10:44:53 +0100[diff] [blame]64 "id": 11,
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]65 "gridPos": {
66 "h": 7,
67 "w": 6,
68 "x": 0,
69 "y": 1
70 },
limon00d428d2022-03-01 10:44:53 +0100[diff] [blame]71 "type": "stat",
72 "title": "Instance Up",
73 "datasource": "Prometheus",
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]74 "maxDataPoints": 100,
limon00d428d2022-03-01 10:44:53 +0100[diff] [blame]75 "links": [],
76 "cacheTimeout": null,
77 "interval": null,
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]78 "targets": [
79 {
80 "expr": "mysql_up{release=\"$release\"}",
81 "format": "time_series",
82 "intervalFactor": 1,
83 "refId": "A"
84 }
85 ],
limon00d428d2022-03-01 10:44:53 +0100[diff] [blame]86 "fieldConfig": {
87 "defaults": {
88 "thresholds": {
89 "mode": "absolute",
90 "steps": [
91 {
92 "value": null,
93 "color": "#bf1b00"
94 },
95 {
96 "value": 1,
97 "color": "#508642"
98 },
99 {
100 "value": 2,
101 "color": "#ef843c"
102 }
103 ]
104 },
105 "mappings": [
106 {
107 "type": "special",
108 "options": {
109 "match": "null",
110 "result": {
111 "text": "N/A"
112 }
113 }
114 }
115 ],
116 "unit": "none",
117 "color": {
118 "mode": "thresholds"
119 }
120 },
121 "overrides": []
122 },
123 "options": {
124 "reduceOptions": {
125 "values": false,
126 "calcs": [
127 "lastNotNull"
128 ],
129 "fields": ""
130 },
131 "orientation": "horizontal",
132 "text": {},
133 "textMode": "auto",
134 "colorMode": "background",
135 "graphMode": "area",
136 "justifyMode": "auto"
137 },
138 "pluginVersion": "8.1.1"
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]139 },
140 {
141 "cacheTimeout": null,
142 "colorBackground": true,
143 "colorValue": false,
144 "colors": [
145 "#d44a3a",
146 "rgba(237, 129, 40, 0.89)",
147 "#508642"
148 ],
149 "datasource": "Prometheus",
150 "format": "s",
151 "gauge": {
152 "maxValue": 100,
153 "minValue": 0,
154 "show": false,
155 "thresholdLabels": false,
156 "thresholdMarkers": true
157 },
158 "gridPos": {
159 "h": 7,
160 "w": 6,
161 "x": 6,
162 "y": 1
163 },
164 "id": 15,
165 "interval": null,
166 "links": [],
167 "mappingType": 1,
168 "mappingTypes": [
169 {
170 "name": "value to text",
171 "value": 1
172 },
173 {
174 "name": "range to text",
175 "value": 2
176 }
177 ],
178 "maxDataPoints": 100,
179 "nullPointMode": "connected",
180 "nullText": null,
181 "options": {},
182 "postfix": "",
183 "postfixFontSize": "50%",
184 "prefix": "",
185 "prefixFontSize": "50%",
186 "rangeMaps": [
187 {
188 "from": "null",
189 "text": "N/A",
190 "to": "null"
191 }
192 ],
193 "sparkline": {
194 "fillColor": "rgba(31, 118, 189, 0.18)",
195 "full": false,
196 "lineColor": "rgb(31, 120, 193)",
197 "show": true
198 },
199 "tableColumn": "",
200 "targets": [
201 {
202 "expr": "mysql_global_status_uptime{release=\"$release\"}",
203 "format": "time_series",
204 "intervalFactor": 1,
205 "refId": "A"
206 }
207 ],
208 "thresholds": "25200,32400",
209 "title": "Uptime",
210 "type": "singlestat",
211 "valueFontSize": "80%",
212 "valueMaps": [
213 {
214 "op": "=",
215 "text": "N/A",
216 "value": "null"
217 }
218 ],
219 "valueName": "current"
220 },
221 {
222 "aliasColors": {},
223 "bars": false,
224 "dashLength": 10,
225 "dashes": false,
226 "datasource": "Prometheus",
227 "fill": 1,
228 "fillGradient": 0,
229 "gridPos": {
230 "h": 7,
231 "w": 12,
232 "x": 12,
233 "y": 1
234 },
235 "id": 29,
236 "legend": {
237 "avg": false,
238 "current": false,
239 "max": false,
240 "min": false,
241 "show": false,
242 "total": false,
243 "values": false
244 },
245 "lines": true,
246 "linewidth": 1,
247 "links": [],
248 "nullPointMode": "null",
249 "options": {
250 "dataLinks": []
251 },
252 "percentage": false,
253 "pointradius": 5,
254 "points": false,
255 "renderer": "flot",
256 "seriesOverrides": [],
257 "spaceLength": 10,
258 "stack": false,
259 "steppedLine": false,
260 "targets": [
261 {
262 "expr": "mysql_global_status_max_used_connections{release=\"$release\"}",
263 "format": "time_series",
264 "intervalFactor": 1,
265 "legendFormat": "current",
266 "refId": "A"
267 },
268 {
269 "expr": "mysql_global_variables_max_connections{release=\"$release\"}",
270 "format": "time_series",
271 "intervalFactor": 1,
272 "legendFormat": "Max",
273 "refId": "B"
274 }
275 ],
276 "thresholds": [],
277 "timeFrom": null,
278 "timeRegions": [],
279 "timeShift": null,
280 "title": "Mysql Connections",
281 "tooltip": {
282 "shared": true,
283 "sort": 0,
284 "value_type": "individual"
285 },
286 "type": "graph",
287 "xaxis": {
288 "buckets": null,
289 "mode": "time",
290 "name": null,
291 "show": true,
292 "values": []
293 },
294 "yaxes": [
295 {
296 "format": "short",
297 "label": null,
298 "logBase": 1,
299 "max": null,
300 "min": null,
301 "show": true
302 },
303 {
304 "format": "short",
305 "label": null,
306 "logBase": 1,
307 "max": null,
308 "min": null,
309 "show": true
310 }
311 ],
312 "yaxis": {
313 "align": false,
314 "alignLevel": null
315 }
316 },
317 {
318 "collapsed": false,
319 "gridPos": {
320 "h": 1,
321 "w": 24,
322 "x": 0,
323 "y": 8
324 },
325 "id": 19,
326 "panels": [],
327 "title": "I/O",
328 "type": "row"
329 },
330 {
331 "aliasColors": {},
332 "bars": false,
333 "dashLength": 10,
334 "dashes": false,
335 "datasource": "Prometheus",
336 "fill": 1,
337 "fillGradient": 0,
338 "gridPos": {
339 "h": 9,
340 "w": 12,
341 "x": 0,
342 "y": 9
343 },
344 "id": 5,
345 "legend": {
346 "avg": false,
347 "current": false,
348 "max": false,
349 "min": false,
350 "show": true,
351 "total": false,
352 "values": false
353 },
354 "lines": true,
355 "linewidth": 1,
356 "links": [],
357 "nullPointMode": "null",
358 "options": {
359 "dataLinks": []
360 },
361 "percentage": false,
362 "pointradius": 5,
363 "points": false,
364 "renderer": "flot",
365 "seriesOverrides": [
366 {
367 "alias": "write",
368 "transform": "negative-Y"
369 }
370 ],
371 "spaceLength": 10,
372 "stack": false,
373 "steppedLine": false,
374 "targets": [
375 {
376 "expr": "irate(mysql_global_status_innodb_data_reads{release=\"$release\"}[10m])",
377 "format": "time_series",
378 "intervalFactor": 1,
379 "legendFormat": "reads",
380 "refId": "A"
381 },
382 {
383 "expr": "irate(mysql_global_status_innodb_data_writes{release=\"$release\"}[10m])",
384 "format": "time_series",
385 "intervalFactor": 1,
386 "legendFormat": "write",
387 "refId": "B"
388 }
389 ],
390 "thresholds": [],
391 "timeFrom": null,
392 "timeRegions": [],
393 "timeShift": null,
394 "title": "mysql disk reads vs writes",
395 "tooltip": {
396 "shared": true,
397 "sort": 0,
398 "value_type": "individual"
399 },
400 "type": "graph",
401 "xaxis": {
402 "buckets": null,
403 "mode": "time",
404 "name": null,
405 "show": true,
406 "values": []
407 },
408 "yaxes": [
409 {
410 "format": "short",
411 "label": null,
412 "logBase": 1,
413 "max": null,
414 "min": null,
415 "show": true
416 },
417 {
418 "format": "short",
419 "label": null,
420 "logBase": 1,
421 "max": null,
422 "min": null,
423 "show": true
424 }
425 ],
426 "yaxis": {
427 "align": false,
428 "alignLevel": null
429 }
430 },
431 {
432 "aliasColors": {},
433 "bars": false,
434 "dashLength": 10,
435 "dashes": false,
436 "datasource": "Prometheus",
437 "fill": 1,
438 "fillGradient": 0,
439 "gridPos": {
440 "h": 9,
441 "w": 12,
442 "x": 12,
443 "y": 9
444 },
445 "id": 9,
446 "legend": {
447 "avg": false,
448 "current": false,
449 "max": false,
450 "min": false,
451 "show": false,
452 "total": false,
453 "values": false
454 },
455 "lines": true,
456 "linewidth": 1,
457 "links": [],
458 "nullPointMode": "null",
459 "options": {
460 "dataLinks": []
461 },
462 "percentage": false,
463 "pointradius": 5,
464 "points": false,
465 "renderer": "flot",
466 "seriesOverrides": [
467 {
468 "alias": "/sent/",
469 "transform": "negative-Y"
470 }
471 ],
472 "spaceLength": 10,
473 "stack": false,
474 "steppedLine": false,
475 "targets": [
476 {
477 "expr": "irate(mysql_global_status_bytes_received{release=\"$release\"}[5m])",
478 "format": "time_series",
479 "intervalFactor": 1,
480 "legendFormat": "received",
481 "refId": "A"
482 },
483 {
484 "expr": "irate(mysql_global_status_bytes_sent{release=\"$release\"}[5m])",
485 "format": "time_series",
486 "intervalFactor": 1,
487 "legendFormat": "sent",
488 "refId": "B"
489 }
490 ],
491 "thresholds": [],
492 "timeFrom": null,
493 "timeRegions": [],
494 "timeShift": null,
495 "title": "mysql network received vs sent",
496 "tooltip": {
497 "shared": true,
498 "sort": 0,
499 "value_type": "individual"
500 },
501 "type": "graph",
502 "xaxis": {
503 "buckets": null,
504 "mode": "time",
505 "name": null,
506 "show": true,
507 "values": []
508 },
509 "yaxes": [
510 {
511 "format": "short",
512 "label": null,
513 "logBase": 1,
514 "max": null,
515 "min": null,
516 "show": true
517 },
518 {
519 "format": "short",
520 "label": null,
521 "logBase": 1,
522 "max": null,
523 "min": null,
524 "show": true
525 }
526 ],
527 "yaxis": {
528 "align": false,
529 "alignLevel": null
530 }
531 },
532 {
533 "aliasColors": {},
534 "bars": false,
535 "dashLength": 10,
536 "dashes": false,
537 "datasource": "Prometheus",
538 "fill": 1,
539 "fillGradient": 0,
540 "gridPos": {
541 "h": 7,
542 "w": 12,
543 "x": 0,
544 "y": 18
545 },
546 "id": 2,
547 "legend": {
548 "avg": false,
549 "current": false,
550 "max": false,
551 "min": false,
552 "show": false,
553 "total": false,
554 "values": false
555 },
556 "lines": true,
557 "linewidth": 1,
558 "links": [],
559 "nullPointMode": "null",
560 "options": {
561 "dataLinks": []
562 },
563 "percentage": false,
564 "pointradius": 5,
565 "points": false,
566 "renderer": "flot",
567 "seriesOverrides": [],
568 "spaceLength": 10,
569 "stack": false,
570 "steppedLine": false,
571 "targets": [
572 {
573 "expr": "irate(mysql_global_status_commands_total{release=\"$release\"}[5m]) > 0",
574 "format": "time_series",
575 "intervalFactor": 1,
576 "legendFormat": "{{ command }} - {{ release }}",
577 "refId": "A"
578 }
579 ],
580 "thresholds": [],
581 "timeFrom": null,
582 "timeRegions": [],
583 "timeShift": null,
584 "title": "Query rates",
585 "tooltip": {
586 "shared": true,
587 "sort": 0,
588 "value_type": "individual"
589 },
590 "type": "graph",
591 "xaxis": {
592 "buckets": null,
593 "mode": "time",
594 "name": null,
595 "show": true,
596 "values": []
597 },
598 "yaxes": [
599 {
600 "format": "short",
601 "label": null,
602 "logBase": 1,
603 "max": null,
604 "min": null,
605 "show": true
606 },
607 {
608 "format": "short",
609 "label": null,
610 "logBase": 1,
611 "max": null,
612 "min": null,
613 "show": true
614 }
615 ],
616 "yaxis": {
617 "align": false,
618 "alignLevel": null
619 }
620 },
621 {
622 "aliasColors": {},
623 "bars": false,
624 "dashLength": 10,
625 "dashes": false,
626 "datasource": "Prometheus",
627 "fill": 1,
628 "fillGradient": 0,
629 "gridPos": {
630 "h": 7,
631 "w": 12,
632 "x": 12,
633 "y": 18
634 },
635 "id": 25,
636 "legend": {
637 "avg": false,
638 "current": false,
639 "max": false,
640 "min": false,
641 "show": false,
642 "total": false,
643 "values": false
644 },
645 "lines": true,
646 "linewidth": 1,
647 "links": [],
648 "nullPointMode": "null",
649 "options": {
650 "dataLinks": []
651 },
652 "percentage": false,
653 "pointradius": 5,
654 "points": false,
655 "renderer": "flot",
656 "seriesOverrides": [],
657 "spaceLength": 10,
658 "stack": false,
659 "steppedLine": false,
660 "targets": [
661 {
662 "expr": "mysql_global_status_threads_running{release=\"$release\"} ",
663 "format": "time_series",
664 "intervalFactor": 1,
665 "refId": "A"
666 }
667 ],
668 "thresholds": [],
669 "timeFrom": null,
670 "timeRegions": [],
671 "timeShift": null,
672 "title": "Running Threads",
673 "tooltip": {
674 "shared": true,
675 "sort": 0,
676 "value_type": "individual"
677 },
678 "type": "graph",
679 "xaxis": {
680 "buckets": null,
681 "mode": "time",
682 "name": null,
683 "show": true,
684 "values": []
685 },
686 "yaxes": [
687 {
688 "decimals": null,
689 "format": "short",
690 "label": null,
691 "logBase": 1,
692 "max": "15",
693 "min": null,
694 "show": true
695 },
696 {
697 "format": "short",
698 "label": null,
699 "logBase": 1,
700 "max": null,
701 "min": null,
702 "show": true
703 }
704 ],
705 "yaxis": {
706 "align": false,
707 "alignLevel": null
708 }
709 },
710 {
711 "collapsed": false,
712 "gridPos": {
713 "h": 1,
714 "w": 24,
715 "x": 0,
716 "y": 25
717 },
718 "id": 21,
719 "panels": [],
720 "title": "Errors",
721 "type": "row"
722 },
723 {
724 "aliasColors": {},
725 "bars": false,
726 "dashLength": 10,
727 "dashes": false,
728 "datasource": "Prometheus",
romeromonser5bed3ad2019-12-10 18:25:55 +0100[diff] [blame]729 "description": "The number of connections that were aborted because the client died without closing the connection properly.",
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]730 "fill": 1,
731 "fillGradient": 0,
732 "gridPos": {
733 "h": 9,
734 "w": 12,
735 "x": 0,
736 "y": 26
737 },
738 "id": 13,
739 "legend": {
740 "avg": false,
741 "current": false,
742 "max": false,
743 "min": false,
744 "show": false,
745 "total": false,
746 "values": false
747 },
748 "lines": true,
749 "linewidth": 1,
750 "links": [],
751 "nullPointMode": "null",
752 "options": {
753 "dataLinks": []
754 },
755 "percentage": false,
756 "pointradius": 5,
757 "points": false,
758 "renderer": "flot",
759 "seriesOverrides": [],
760 "spaceLength": 10,
761 "stack": false,
762 "steppedLine": false,
763 "targets": [
764 {
765 "expr": "mysql_global_status_aborted_clients{release=\"$release\"}",
766 "format": "time_series",
767 "intervalFactor": 1,
768 "refId": "B"
769 }
770 ],
771 "thresholds": [],
772 "timeFrom": null,
773 "timeRegions": [],
774 "timeShift": null,
775 "title": "Aborted clients",
776 "tooltip": {
777 "shared": true,
778 "sort": 0,
779 "value_type": "individual"
780 },
781 "type": "graph",
782 "xaxis": {
783 "buckets": null,
784 "mode": "time",
785 "name": null,
786 "show": true,
787 "values": []
788 },
789 "yaxes": [
790 {
791 "format": "short",
792 "label": null,
793 "logBase": 1,
794 "max": null,
795 "min": null,
796 "show": true
797 },
798 {
799 "format": "short",
800 "label": null,
801 "logBase": 1,
802 "max": null,
803 "min": null,
804 "show": true
805 }
806 ],
807 "yaxis": {
808 "align": false,
809 "alignLevel": null
810 }
811 },
812 {
813 "aliasColors": {},
814 "bars": false,
815 "dashLength": 10,
816 "dashes": false,
817 "datasource": "Prometheus",
romeromonser5bed3ad2019-12-10 18:25:55 +0100[diff] [blame]818 "description": "The number of failed attempts to connect to the MySQL server.",
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]819 "fill": 1,
820 "fillGradient": 0,
821 "gridPos": {
822 "h": 9,
823 "w": 12,
824 "x": 12,
825 "y": 26
826 },
827 "id": 4,
828 "legend": {
829 "avg": false,
830 "current": false,
831 "max": false,
832 "min": false,
833 "show": false,
834 "total": false,
835 "values": false
836 },
837 "lines": true,
838 "linewidth": 1,
839 "links": [],
840 "nullPointMode": "null",
841 "options": {
842 "dataLinks": []
843 },
844 "percentage": false,
845 "pointradius": 5,
846 "points": false,
847 "renderer": "flot",
848 "seriesOverrides": [],
849 "spaceLength": 10,
850 "stack": false,
851 "steppedLine": false,
852 "targets": [
853 {
854 "expr": "mysql_global_status_aborted_connects{release=\"$release\"}",
855 "format": "time_series",
856 "intervalFactor": 1,
857 "legendFormat": "",
858 "refId": "A"
859 }
860 ],
861 "thresholds": [],
862 "timeFrom": null,
863 "timeRegions": [],
864 "timeShift": null,
865 "title": "mysql aborted Connects",
866 "tooltip": {
867 "shared": true,
868 "sort": 0,
869 "value_type": "individual"
870 },
871 "type": "graph",
872 "xaxis": {
873 "buckets": null,
874 "mode": "time",
875 "name": null,
876 "show": true,
877 "values": []
878 },
879 "yaxes": [
880 {
881 "format": "short",
882 "label": null,
883 "logBase": 1,
884 "max": null,
885 "min": null,
886 "show": true
887 },
888 {
889 "format": "short",
890 "label": null,
891 "logBase": 1,
892 "max": null,
893 "min": null,
894 "show": true
895 }
896 ],
897 "yaxis": {
898 "align": false,
899 "alignLevel": null
900 }
901 },
902 {
903 "collapsed": false,
904 "gridPos": {
905 "h": 1,
906 "w": 24,
907 "x": 0,
908 "y": 35
909 },
910 "id": 23,
911 "panels": [],
912 "title": "Disk usage",
913 "type": "row"
914 },
915 {
916 "aliasColors": {},
917 "bars": false,
918 "dashLength": 10,
919 "dashes": false,
920 "datasource": "Prometheus",
921 "fill": 1,
922 "fillGradient": 0,
923 "gridPos": {
924 "h": 9,
925 "w": 12,
926 "x": 0,
927 "y": 36
928 },
929 "id": 27,
930 "legend": {
931 "avg": false,
932 "current": false,
933 "max": false,
934 "min": false,
935 "show": true,
936 "total": false,
937 "values": false
938 },
939 "lines": true,
940 "linewidth": 1,
941 "links": [],
942 "nullPointMode": "null",
943 "options": {
944 "dataLinks": []
945 },
946 "percentage": false,
947 "pointradius": 5,
948 "points": false,
949 "renderer": "flot",
950 "seriesOverrides": [],
951 "spaceLength": 10,
952 "stack": false,
953 "steppedLine": false,
954 "targets": [
955 {
956 "expr": "sum(mysql_info_schema_table_size{component=\"data_length\",release=\"$release\"})",
957 "format": "time_series",
958 "intervalFactor": 1,
959 "legendFormat": "Tables",
960 "refId": "A"
961 },
962 {
963 "expr": "sum(mysql_info_schema_table_size{component=\"index_length\",release=\"$release\"})",
964 "format": "time_series",
965 "intervalFactor": 1,
966 "legendFormat": "Indexes",
967 "refId": "B"
968 }
969 ],
970 "thresholds": [],
971 "timeFrom": null,
972 "timeRegions": [],
973 "timeShift": null,
974 "title": "Disk usage tables / indexes",
975 "tooltip": {
976 "shared": true,
977 "sort": 0,
978 "value_type": "individual"
979 },
980 "type": "graph",
981 "xaxis": {
982 "buckets": null,
983 "mode": "time",
984 "name": null,
985 "show": true,
986 "values": []
987 },
988 "yaxes": [
989 {
990 "format": "decbytes",
991 "label": null,
992 "logBase": 1,
993 "max": null,
994 "min": null,
995 "show": true
996 },
997 {
998 "format": "short",
999 "label": null,
1000 "logBase": 1,
1001 "max": null,
1002 "min": null,
1003 "show": true
1004 }
1005 ],
1006 "yaxis": {
1007 "align": false,
1008 "alignLevel": null
1009 }
1010 },
1011 {
1012 "aliasColors": {},
1013 "bars": false,
1014 "dashLength": 10,
1015 "dashes": false,
1016 "datasource": "Prometheus",
1017 "fill": 1,
1018 "fillGradient": 0,
1019 "gridPos": {
1020 "h": 9,
1021 "w": 12,
1022 "x": 12,
1023 "y": 36
1024 },
1025 "id": 7,
1026 "legend": {
1027 "avg": false,
1028 "current": false,
1029 "max": false,
1030 "min": false,
1031 "show": false,
1032 "total": false,
1033 "values": false
1034 },
1035 "lines": true,
1036 "linewidth": 1,
1037 "links": [],
1038 "nullPointMode": "null",
1039 "options": {
1040 "dataLinks": []
1041 },
1042 "percentage": false,
1043 "pointradius": 5,
1044 "points": false,
1045 "renderer": "flot",
1046 "seriesOverrides": [],
1047 "spaceLength": 10,
1048 "stack": false,
1049 "steppedLine": false,
1050 "targets": [
1051 {
1052 "expr": "sum(mysql_info_schema_table_rows{release=\"$release\"})",
1053 "format": "time_series",
1054 "intervalFactor": 1,
1055 "refId": "A"
1056 }
1057 ],
1058 "thresholds": [],
1059 "timeFrom": null,
1060 "timeRegions": [],
1061 "timeShift": null,
1062 "title": "Sum of all rows",
1063 "tooltip": {
1064 "shared": true,
1065 "sort": 0,
1066 "value_type": "individual"
1067 },
1068 "type": "graph",
1069 "xaxis": {
1070 "buckets": null,
1071 "mode": "time",
1072 "name": null,
1073 "show": true,
1074 "values": []
1075 },
1076 "yaxes": [
1077 {
1078 "decimals": null,
1079 "format": "short",
1080 "label": null,
1081 "logBase": 1,
1082 "max": null,
1083 "min": null,
1084 "show": true
1085 },
1086 {
1087 "format": "short",
1088 "label": null,
1089 "logBase": 1,
1090 "max": null,
1091 "min": null,
1092 "show": true
1093 }
1094 ],
1095 "yaxis": {
1096 "align": false,
1097 "alignLevel": null
1098 }
1099 }
1100 ],
1101 "schemaVersion": 19,
1102 "style": "dark",
1103 "tags": [
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]1104 ],
1105 "templating": {
1106 "list": [
1107 {
1108 "allValue": null,
1109 "current": {
1110 "isNone": true,
1111 "text": "None",
1112 "value": ""
1113 },
1114 "datasource": "Prometheus",
1115 "definition": "",
1116 "hide": 0,
1117 "includeAll": false,
1118 "label": null,
1119 "multi": false,
1120 "name": "release",
1121 "options": [],
1122 "query": "label_values(mysql_up,release)",
1123 "refresh": 1,
1124 "regex": "",
1125 "skipUrlSync": false,
1126 "sort": 0,
1127 "tagValuesQuery": "",
1128 "tags": [],
1129 "tagsQuery": "",
1130 "type": "query",
1131 "useTags": false
1132 }
1133 ]
1134 },
1135 "time": {
1136 "from": "now-1h",
1137 "to": "now"
1138 },
1139 "timepicker": {
1140 "refresh_intervals": [
1141 "5s",
1142 "10s",
1143 "30s",
1144 "1m",
1145 "5m",
1146 "15m",
1147 "30m",
1148 "1h",
1149 "2h",
1150 "1d"
1151 ],
1152 "time_options": [
1153 "5m",
1154 "15m",
1155 "1h",
1156 "6h",
1157 "12h",
1158 "24h",
1159 "2d",
1160 "7d",
1161 "30d"
1162 ]
1163 },
1164 "timezone": "",
romeromonser5bed3ad2019-12-10 18:25:55 +0100[diff] [blame]1165 "title": "Mysql",
romeromonsere366b1a2019-11-19 19:49:26 +0100[diff] [blame]1166 "uid": "6-kPlS7ik",
1167 "version": 1
1168 }