installers/k8s/mysql-exporter-dashboard.yaml

   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
  17 apiVersion: v1
  18 kind: ConfigMap
  19 metadata:
  20   labels:
  21     app: prometheus-mysql-exporter-grafana
  22     grafana_dashboard: "1"
  23   name: osm-monitoring-prometheus-mysql-exporter-grafana
  24   annotations:
  25     k8s-sidecar-target-directory: "/tmp/dashboards/Open Source MANO"
  26 data:
  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       },
  42       "description": "Mysql dashboard",
  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         {
  64           "id": 11,
  65           "gridPos": {
  66             "h": 7,
  67             "w": 6,
  68             "x": 0,
  69             "y": 1
  70           },
  71           "type": "stat",
  72           "title": "Instance Up",
  73           "datasource": "Prometheus",
  74           "maxDataPoints": 100,
  75           "links": [],
  76           "cacheTimeout": null,
  77           "interval": null,
  78           "targets": [
  79             {
  80               "expr": "mysql_up{release=\"$release\"}",
  81               "format": "time_series",
  82               "intervalFactor": 1,
  83               "refId": "A"
  84             }
  85           ],
  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"
 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",
 729           "description": "The number of connections that were aborted because the client died without closing the connection properly.",
 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",
 818           "description": "The number of failed attempts to connect to the MySQL server.",
 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": [
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": "",
1165       "title": "Mysql",
1166       "uid": "6-kPlS7ik",
1167       "version": 1
1168     }