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