1 # Copyright 2021 Canonical Ltd.
3 # Licensed under the Apache License, Version 2.0 (the "License"); you may
4 # not use this file except in compliance with the License. You may obtain
5 # a copy of the License at
7 # http://www.apache.org/licenses/LICENSE-2.0
9 # Unless required by applicable law or agreed to in writing, software
10 # distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
11 # WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
12 # License for the specific language governing permissions and limitations
15 # For those usages not covered by the Apache License, Version 2.0 please
16 # contact: legal@canonical.com
18 # To get in touch with the maintainers, please contact:
19 # osm-charmers@lists.launchpad.net
26 datasource: '-- Grafana --'
29 iconColor: 'rgba(0, 211, 255, 1)'
30 name: Annotations & Alerts
32 description: Mysql dashboard
37 iteration: 1569307668513
57 datasource: Prometheus
63 thresholdLabels: false
64 thresholdMarkers: true
80 nullPointMode: connected
92 fillColor: 'rgba(31, 118, 189, 0.18)'
94 lineColor: 'rgb(31, 120, 193)'
98 - expr: 'mysql_up{release="$release"}'
112 colorBackground: true
116 - 'rgba(237, 129, 40, 0.89)'
118 datasource: Prometheus
124 thresholdLabels: false
125 thresholdMarkers: true
136 - name: value to text
138 - name: range to text
141 nullPointMode: connected
153 fillColor: 'rgba(31, 118, 189, 0.18)'
155 lineColor: 'rgb(31, 120, 193)'
159 - expr: 'mysql_global_status_uptime{release="$release"}'
163 thresholds: '25200,32400'
176 datasource: Prometheus
196 nullPointMode: 'null'
208 - expr: 'mysql_global_status_max_used_connections{release="$release"}'
211 legendFormat: current
213 - expr: 'mysql_global_variables_max_connections{release="$release"}'
222 title: Mysql Connections
226 value_type: individual
264 datasource: Prometheus
284 nullPointMode: 'null'
293 transform: negative-Y
299 'irate(mysql_global_status_innodb_data_reads{release="$release"}[10m])'
305 'irate(mysql_global_status_innodb_data_writes{release="$release"}[10m])'
314 title: mysql disk reads vs writes
318 value_type: individual
346 datasource: Prometheus
366 nullPointMode: 'null'
375 transform: negative-Y
381 'irate(mysql_global_status_bytes_received{release="$release"}[5m])'
384 legendFormat: received
386 - expr: 'irate(mysql_global_status_bytes_sent{release="$release"}[5m])'
395 title: mysql network received vs sent
399 value_type: individual
427 datasource: Prometheus
447 nullPointMode: 'null'
460 'irate(mysql_global_status_commands_total{release="$release"}[5m]) >'
464 legendFormat: '{{ command }} - {{ release }}'
474 value_type: individual
502 datasource: Prometheus
522 nullPointMode: 'null'
534 - expr: 'mysql_global_status_threads_running{release="$release"} '
542 title: Running Threads
546 value_type: individual
585 datasource: Prometheus
587 The number of connections that were aborted because the client died
588 without closing the connection properly.
608 nullPointMode: 'null'
620 - expr: 'mysql_global_status_aborted_clients{release="$release"}'
628 title: Aborted clients
632 value_type: individual
660 datasource: Prometheus
661 description: The number of failed attempts to connect to the MySQL server.
681 nullPointMode: 'null'
693 - expr: 'mysql_global_status_aborted_connects{release="$release"}'
702 title: mysql aborted Connects
706 value_type: individual
744 datasource: Prometheus
764 nullPointMode: 'null'
777 sum(mysql_info_schema_table_size{component="data_length",release="$release"})
783 sum(mysql_info_schema_table_size{component="index_length",release="$release"})
786 legendFormat: Indexes
792 title: Disk usage tables / indexes
796 value_type: individual
824 datasource: Prometheus
844 nullPointMode: 'null'
856 - expr: 'sum(mysql_info_schema_table_rows{release="$release"})'
864 title: Sum of all rows
868 value_type: individual
903 datasource: Prometheus
911 query: 'label_values(mysql_up,release)'