# Copyright 2021 Canonical Ltd.
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
#         http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.
#
# For those usages not covered by the Apache License, Version 2.0 please
# contact: legal@canonical.com
#
# To get in touch with the maintainers, please contact:
# osm-charmers@lists.launchpad.net
##

---
annotations:
  list:
    - builtIn: 1
      datasource: '-- Grafana --'
      enable: true
      hide: true
      iconColor: 'rgba(0, 211, 255, 1)'
      name: Annotations & Alerts
      type: dashboard
description: Mysql dashboard
editable: true
gnetId: 6239
graphTooltip: 0
id: 34
iteration: 1569307668513
links: []
panels:
  - collapsed: false
    gridPos:
      h: 1
      w: 24
      x: 0
      'y': 0
    id: 17
    panels: []
    title: Global status
    type: row
  - cacheTimeout: null
    colorBackground: true
    colorValue: false
    colors:
      - '#bf1b00'
      - '#508642'
      - '#ef843c'
    datasource: Prometheus
    format: none
    gauge:
      maxValue: 1
      minValue: 0
      show: false
      thresholdLabels: false
      thresholdMarkers: true
    gridPos:
      h: 7
      w: 6
      x: 0
      'y': 1
    id: 11
    interval: null
    links: []
    mappingType: 1
    mappingTypes:
      - name: value to text
        value: 1
      - name: range to text
        value: 2
    maxDataPoints: 100
    nullPointMode: connected
    nullText: null
    options: {}
    postfix: ''
    postfixFontSize: 50%
    prefix: ''
    prefixFontSize: 50%
    rangeMaps:
      - from: 'null'
        text: N/A
        to: 'null'
    sparkline:
      fillColor: 'rgba(31, 118, 189, 0.18)'
      full: true
      lineColor: 'rgb(31, 120, 193)'
      show: true
    tableColumn: ''
    targets:
      - expr: 'mysql_up{release="$release"}'
        format: time_series
        intervalFactor: 1
        refId: A
    thresholds: '1,2'
    title: Instance Up
    type: singlestat
    valueFontSize: 80%
    valueMaps:
      - op: '='
        text: N/A
        value: 'null'
    valueName: current
  - cacheTimeout: null
    colorBackground: true
    colorValue: false
    colors:
      - '#d44a3a'
      - 'rgba(237, 129, 40, 0.89)'
      - '#508642'
    datasource: Prometheus
    format: s
    gauge:
      maxValue: 100
      minValue: 0
      show: false
      thresholdLabels: false
      thresholdMarkers: true
    gridPos:
      h: 7
      w: 6
      x: 6
      'y': 1
    id: 15
    interval: null
    links: []
    mappingType: 1
    mappingTypes:
      - name: value to text
        value: 1
      - name: range to text
        value: 2
    maxDataPoints: 100
    nullPointMode: connected
    nullText: null
    options: {}
    postfix: ''
    postfixFontSize: 50%
    prefix: ''
    prefixFontSize: 50%
    rangeMaps:
      - from: 'null'
        text: N/A
        to: 'null'
    sparkline:
      fillColor: 'rgba(31, 118, 189, 0.18)'
      full: false
      lineColor: 'rgb(31, 120, 193)'
      show: true
    tableColumn: ''
    targets:
      - expr: 'mysql_global_status_uptime{release="$release"}'
        format: time_series
        intervalFactor: 1
        refId: A
    thresholds: '25200,32400'
    title: Uptime
    type: singlestat
    valueFontSize: 80%
    valueMaps:
      - op: '='
        text: N/A
        value: 'null'
    valueName: current
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    fill: 1
    fillGradient: 0
    gridPos:
      h: 7
      w: 12
      x: 12
      'y': 1
    id: 29
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: false
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides: []
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: 'mysql_global_status_max_used_connections{release="$release"}'
        format: time_series
        intervalFactor: 1
        legendFormat: current
        refId: A
      - expr: 'mysql_global_variables_max_connections{release="$release"}'
        format: time_series
        intervalFactor: 1
        legendFormat: Max
        refId: B
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: Mysql Connections
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
  - collapsed: false
    gridPos:
      h: 1
      w: 24
      x: 0
      'y': 8
    id: 19
    panels: []
    title: I/O
    type: row
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    fill: 1
    fillGradient: 0
    gridPos:
      h: 9
      w: 12
      x: 0
      'y': 9
    id: 5
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: true
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides:
      - alias: write
        transform: negative-Y
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: >-
          'irate(mysql_global_status_innodb_data_reads{release="$release"}[10m])'
        format: time_series
        intervalFactor: 1
        legendFormat: reads
        refId: A
      - expr: >-
          'irate(mysql_global_status_innodb_data_writes{release="$release"}[10m])'
        format: time_series
        intervalFactor: 1
        legendFormat: write
        refId: B
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: mysql  disk reads vs writes
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    fill: 1
    fillGradient: 0
    gridPos:
      h: 9
      w: 12
      x: 12
      'y': 9
    id: 9
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: false
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides:
      - alias: /sent/
        transform: negative-Y
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: >-
          'irate(mysql_global_status_bytes_received{release="$release"}[5m])'
        format: time_series
        intervalFactor: 1
        legendFormat: received
        refId: A
      - expr: 'irate(mysql_global_status_bytes_sent{release="$release"}[5m])'
        format: time_series
        intervalFactor: 1
        legendFormat: sent
        refId: B
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: mysql network received vs sent
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    fill: 1
    fillGradient: 0
    gridPos:
      h: 7
      w: 12
      x: 0
      'y': 18
    id: 2
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: false
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides: []
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: >-
          'irate(mysql_global_status_commands_total{release="$release"}[5m]) >'
          '0'
        format: time_series
        intervalFactor: 1
        legendFormat: '{{ command }} - {{ release }}'
        refId: A
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: Query rates
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    fill: 1
    fillGradient: 0
    gridPos:
      h: 7
      w: 12
      x: 12
      'y': 18
    id: 25
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: false
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides: []
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: 'mysql_global_status_threads_running{release="$release"} '
        format: time_series
        intervalFactor: 1
        refId: A
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: Running Threads
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - decimals: null
        format: short
        label: null
        logBase: 1
        max: '15'
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
  - collapsed: false
    gridPos:
      h: 1
      w: 24
      x: 0
      'y': 25
    id: 21
    panels: []
    title: Errors
    type: row
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    description: >-
      The number of connections that were aborted because the client died
      without closing the connection properly.
    fill: 1
    fillGradient: 0
    gridPos:
      h: 9
      w: 12
      x: 0
      'y': 26
    id: 13
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: false
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides: []
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: 'mysql_global_status_aborted_clients{release="$release"}'
        format: time_series
        intervalFactor: 1
        refId: B
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: Aborted clients
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    description: The number of failed attempts to connect to the MySQL server.
    fill: 1
    fillGradient: 0
    gridPos:
      h: 9
      w: 12
      x: 12
      'y': 26
    id: 4
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: false
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides: []
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: 'mysql_global_status_aborted_connects{release="$release"}'
        format: time_series
        intervalFactor: 1
        legendFormat: ''
        refId: A
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: mysql aborted Connects
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
  - collapsed: false
    gridPos:
      h: 1
      w: 24
      x: 0
      'y': 35
    id: 23
    panels: []
    title: Disk usage
    type: row
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    fill: 1
    fillGradient: 0
    gridPos:
      h: 9
      w: 12
      x: 0
      'y': 36
    id: 27
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: true
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides: []
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: >-
          sum(mysql_info_schema_table_size{component="data_length",release="$release"})
        format: time_series
        intervalFactor: 1
        legendFormat: Tables
        refId: A
      - expr: >-
          sum(mysql_info_schema_table_size{component="index_length",release="$release"})
        format: time_series
        intervalFactor: 1
        legendFormat: Indexes
        refId: B
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: Disk usage tables / indexes
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - format: decbytes
        label: null
        logBase: 1
        max: null
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
  - aliasColors: {}
    bars: false
    dashLength: 10
    dashes: false
    datasource: Prometheus
    fill: 1
    fillGradient: 0
    gridPos:
      h: 9
      w: 12
      x: 12
      'y': 36
    id: 7
    legend:
      avg: false
      current: false
      max: false
      min: false
      show: false
      total: false
      values: false
    lines: true
    linewidth: 1
    links: []
    nullPointMode: 'null'
    options:
      dataLinks: []
    percentage: false
    pointradius: 5
    points: false
    renderer: flot
    seriesOverrides: []
    spaceLength: 10
    stack: false
    steppedLine: false
    targets:
      - expr: 'sum(mysql_info_schema_table_rows{release="$release"})'
        format: time_series
        intervalFactor: 1
        refId: A
    thresholds: []
    timeFrom: null
    timeRegions: []
    timeShift: null
    title: Sum of all rows
    tooltip:
      shared: true
      sort: 0
      value_type: individual
    type: graph
    xaxis:
      buckets: null
      mode: time
      name: null
      show: true
      values: []
    yaxes:
      - decimals: null
        format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
      - format: short
        label: null
        logBase: 1
        max: null
        min: null
        show: true
    yaxis:
      align: false
      alignLevel: null
schemaVersion: 19
style: dark
tags: []
templating:
  list:
    - allValue: null
      current:
        isNone: true
        text: None
        value: ''
      datasource: Prometheus
      definition: ''
      hide: 0
      includeAll: false
      label: null
      multi: false
      name: release
      options: []
      query: 'label_values(mysql_up,release)'
      refresh: 1
      regex: ''
      skipUrlSync: false
      sort: 0
      tagValuesQuery: ''
      tags: []
      tagsQuery: ''
      type: query
      useTags: false
time:
  from: now-1h
  to: now
timepicker:
  refresh_intervals:
    - 5s
    - 10s
    - 30s
    - 1m
    - 5m
    - 15m
    - 30m
    - 1h
    - 2h
    - 1d
  time_options:
    - 5m
    - 15m
    - 1h
    - 6h
    - 12h
    - 24h
    - 2d
    - 7d
    - 30d
timezone: ''
title: Mysql
uid: 6-kPlS7ik
version: 1