installers/charm/grafana/templates/mysql_exporter_dashboard.json

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