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