Created
May 18, 2021 14:11
-
-
Save Fgruntjes/2badfa5047c822501115c880056c3a09 to your computer and use it in GitHub Desktop.
Grafana MySQL dashboard
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "__inputs": [ | |
| { | |
| "name": "DS_GRAFANACLOUD-WOUTER4-PROM", | |
| "label": "grafanacloud-wouter4-prom", | |
| "description": "", | |
| "type": "datasource", | |
| "pluginId": "prometheus", | |
| "pluginName": "Prometheus" | |
| } | |
| ], | |
| "__requires": [ | |
| { | |
| "type": "grafana", | |
| "id": "grafana", | |
| "name": "Grafana", | |
| "version": "7.5.6" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "graph", | |
| "name": "Graph", | |
| "version": "" | |
| }, | |
| { | |
| "type": "datasource", | |
| "id": "prometheus", | |
| "name": "Prometheus", | |
| "version": "1.0.0" | |
| } | |
| ], | |
| "annotations": { | |
| "list": [ | |
| { | |
| "builtIn": 1, | |
| "datasource": "-- Grafana --", | |
| "enable": false, | |
| "hide": true, | |
| "iconColor": "#e0752d", | |
| "limit": 100, | |
| "name": "PMM Annotations", | |
| "showIn": 0, | |
| "tags": [ | |
| "pmm_annotation" | |
| ], | |
| "type": "tags" | |
| } | |
| ] | |
| }, | |
| "editable": true, | |
| "gnetId": null, | |
| "graphTooltip": 1, | |
| "id": null, | |
| "iteration": 1621346803037, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "collapsed": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 51, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Checkpoint", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": { | |
| "Max Checkpoint Age": "#BF1B00", | |
| "Uncheckpointed Bytes": "#E0752D" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "description": "**InnoDB Checkpoint Age**\n\nThe maximum checkpoint age is determined by the total length of all transaction log files (`innodb_log_file_size`).\n\nWhen the checkpoint age reaches the maximum checkpoint age, blocks are flushed syncronously. The rules of the thumb is to keep one hour of traffic in those logs and let the checkpointing perform its work as smooth as possible. If you don't do this, InnoDB will do synchronous flushing at the worst possible time, ie when you are busiest.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 19, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Max Checkpoint Age", | |
| "color": "#BF1B00", | |
| "fill": 0 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "max_over_time(mysql_global_status_innodb_checkpoint_age{instance=\"$host\"}[$interval]) or \nmax_over_time(mysql_global_status_innodb_checkpoint_age{instance=\"$host\"}[5m]) or\nmax_over_time(mysql_info_schema_innodb_metrics_recovery_log_lsn_checkpoint_age_total{instance=\"$host\"}[$interval]) or\nmax_over_time(mysql_info_schema_innodb_metrics_recovery_log_lsn_checkpoint_age_total{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Uncheckpointed Bytes", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "max_over_time(mysql_global_status_innodb_checkpoint_max_age{instance=\"$host\"}[$interval]) or\nmax_over_time(mysql_global_status_innodb_checkpoint_max_age{instance=\"$host\"}[5m]) or\nmax_over_time(mysql_info_schema_innodb_metrics_recovery_log_max_modified_age_async{instance=\"$host\"}[$interval]) or\nmax_over_time(mysql_info_schema_innodb_metrics_recovery_log_max_modified_age_async{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Max Checkpoint Age", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Checkpoint Age", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "description": "**Innodb Transactions** \n\nInnoDB is an MVCC storage engine, which means you can start a transaction and continue to see a consistent snapshot \neven as the data changes. This is implemented by keeping old versions of rows as they are modified.\n\nThe InnoDB History List is the undo logs which are used to store these modifications. They are a fundamental part of InnoDB’s transactional architecture.\n\nIf history length is rising regularly, do not let open connections linger for a long period as this can affect the performance of InnoDB considerably. It is also a good idea to look for long running queries in PMM's Query Analytics.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 12, | |
| "y": 1 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 20, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "hideZero": true, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [ | |
| { | |
| "title": "Query Analytics", | |
| "url": "dashboard/db/_pmm-query-analytics" | |
| } | |
| ], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "InnoDB Transactions", | |
| "yaxis": 2 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_max_trx_id{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_max_trx_id{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "hide": false, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "InnoDB Transactions", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "(max_over_time(mysql_global_status_innodb_history_list_length{instance=\"$host\"}[$interval]) or \nmax_over_time(mysql_global_status_innodb_history_list_length{instance=\"$host\"}[5m])) or \n(max_over_time(mysql_info_schema_innodb_metrics_transaction_trx_rseg_history_len{instance=\"$host\"}[$interval]) or \nmax_over_time(mysql_info_schema_innodb_metrics_transaction_trx_rseg_history_len{instance=\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "History Length", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Transactions", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 8 | |
| }, | |
| "id": 52, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Row Operations", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "description": "**InnoDB Row Operations**\n\nThis graph allows you to see which operations occur and the number of rows affected per operation. A graph like Queries Per Second will give you an idea of queries, but one query could effect millions of rows.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 0, | |
| "y": 9 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 23, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_row_ops_total{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_row_ops_total{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Rows {{ operation }}", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Row Operations", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "Avg Row Lock Wait Time": "#BF1B00" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "description": "**InnoDB Row Lock Time**\n\nWhen data is locked, then that means that another ***session can NOT update that data until the lock*** is released (which unlocks the data and allows other users to update that data). Locks are usually released by either a ROLLBACK or COMMIT SQL statement.\n\nInnoDB implements standard row-level locking where there are two types of locks, [shared (S) locks](https://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_shared_lock) and [exclusive (X) locks](https://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_exclusive_lock).\n\n* A [shared (S) lock](https://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_shared_lock) permits the transaction that holds the lock to read a row.\n* An [exclusive (X) lock](https://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_exclusive_lock) permits the transaction that holds the lock to update or delete a row.\n\n_Average Row Lock Wait Time_ is the row lock wait time divided by the number of row locks.\\\n_Row Lock Waits_ are how many times a transaction waited on a row lock per second.\\\n_Row Lock Wait Load_ is a rolling 5 minute average of Row Lock Waits.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "grid": { | |
| "leftLogBase": 1, | |
| "leftMax": null, | |
| "leftMin": 0, | |
| "rightLogBase": 1, | |
| "rightMax": null, | |
| "rightMin": 0 | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 12, | |
| "y": 9 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 46, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": false, | |
| "linewidth": 2, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "InnoDB Locking", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html" | |
| } | |
| ], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 1, | |
| "points": true, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Avg Row Lock Wait Time", | |
| "yaxis": 2 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": true, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_row_lock_waits{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_row_lock_waits{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Row Lock Waits", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "rate(mysql_global_status_innodb_row_lock_time{instance=\"$host\"}[$interval])/1000 or irate(mysql_global_status_innodb_row_lock_time{instance=\"$host\"}[5m])/1000", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Row Lock Wait Load", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "rate(mysql_global_status_innodb_row_lock_time{instance=\"$host\"}[$interval])/rate(mysql_global_status_innodb_row_lock_waits{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_row_lock_time{instance=\"$host\"}[5m])/irate(mysql_global_status_innodb_row_lock_waits{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Avg Row Lock Wait Time", | |
| "refId": "C", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Row Lock Time", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "x-axis": true, | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "y-axis": true, | |
| "y_formats": [ | |
| "short", | |
| "ms" | |
| ], | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "ms", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 16 | |
| }, | |
| "id": 53, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "I/O", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "description": "**InnoDB I/O**\n\n_Data Writes_ - The total number of InnoDB data writes.\\\n_Data Reads_ - The total number of InnoDB data reads (OS file reads).\\\n_Log Writes_ - The number of physical writes to the InnoDB redo log file.\\\n_Data Fsyncs_ - The number of fsync() operations. The frequency of fsync() calls is influenced by the setting of the `innodb_flush_method` configuration option.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 0, | |
| "y": 17 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 38, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_data_reads{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_data_reads{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Data Reads", | |
| "metric": "", | |
| "refId": "C", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_data_writes{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_data_writes{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Data Writes", | |
| "metric": "", | |
| "refId": "D", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_data_fsyncs{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_data_fsyncs{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Data Fsyncs", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_log_writes{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_log_writes{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Log Writes", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB I/O", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": true, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "description": "**InnoDB Log File Usage Hourly**\n\nAlong with the buffer pool size, `innodb_log_file_size` is the most important setting when we are working with InnoDB. This graph shows how much data was written to InnoDB's redo logs over each hour. When the InnoDB log files are full, InnoDB needs to flush the modified pages from memory to disk.\n\nThe rules of the thumb is to keep one hour of traffic in those logs and let the checkpointing perform its work as smooth as possible. If you don't do this, InnoDB will do synchronous flushing at the worst possible time, ie when you are busiest.\n\nThis graph can help guide you in setting the correct `innodb_log_file_size`.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 8, | |
| "y": 17 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 37, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": false, | |
| "linewidth": 2, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "How to calculate a good InnoDB log file size", | |
| "url": "https://www.percona.com/blog/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/" | |
| }, | |
| { | |
| "targetBlank": true, | |
| "title": "System Variables (innodb_log_file_size)", | |
| "url": "http://www.percona.com/doc/percona-server/5.5/scalability/innodb_io_55.html#innodb_log_file_size" | |
| } | |
| ], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Total Size of InnoDB Log Files", | |
| "bars": false, | |
| "color": "#E24D42", | |
| "fill": 0, | |
| "lines": true | |
| }, | |
| { | |
| "alias": "Data Written", | |
| "color": "#E0752D" | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "increase(mysql_global_status_innodb_os_log_written{instance=\"$host\"}[1h])", | |
| "format": "time_series", | |
| "interval": "1h", | |
| "intervalFactor": 1, | |
| "legendFormat": "Data Written", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 3600 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "mysql_global_variables_innodb_log_files_in_group{instance=\"$host\"} * mysql_global_variables_innodb_log_file_size{instance=\"$host\"}", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Total Size of InnoDB Log Files", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": "24h", | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Log File Usage Hourly", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "Data Written to Logs": "#E24D42", | |
| "Time to Use Redo Log Space ": "#447EBC" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 16, | |
| "y": 17 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 50, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": null, | |
| "sortDesc": null, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": false, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 1, | |
| "points": true, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Time to Use Redo Log Space ", | |
| "yaxis": 2 | |
| }, | |
| { | |
| "alias": "Time to Use In-Memory Log Buffer", | |
| "yaxis": 2 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_os_log_written{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_os_log_written{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Data Written to Logs", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "(mysql_global_variables_innodb_log_files_in_group{instance=\"$host\"} * mysql_global_variables_innodb_log_file_size{instance=\"$host\"})/(rate(mysql_global_status_innodb_os_log_written{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_os_log_written{instance=\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Time to Use Redo Log Space ", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "(mysql_global_variables_innodb_log_buffer_size{instance=\"$host\"})/(rate(mysql_global_status_innodb_os_log_written{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_os_log_written{instance=\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Time to Use In-Memory Log Buffer", | |
| "refId": "C", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Innodb Logging Performance", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "Bps", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "s", | |
| "label": "", | |
| "logBase": 2, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 24 | |
| }, | |
| "id": 54, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Deadlocks and ICP", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "description": "**InnoDB Deadlocks**\n\nA deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable. InnoDB automatically detects transaction deadlocks, rollbacks a transaction immediately and returns an error.", | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 0, | |
| "y": 25 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 47, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": null, | |
| "sortDesc": null, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "How to deal with MySQL deadlocks", | |
| "url": "https://www.percona.com/blog/2014/10/28/how-to-deal-with-mysql-deadlocks/" | |
| } | |
| ], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "(rate(mysql_global_status_innodb_deadlocks{instance=\"$host\"}[$interval]) or rate(mysql_info_schema_innodb_metrics_lock_lock_deadlocks_total{instance=\"$host\"}[$interval])) or (irate(mysql_global_status_innodb_deadlocks{instance=\"$host\"}[5m]) or irate(mysql_info_schema_innodb_metrics_lock_lock_deadlocks_total{instance=\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Deadlocks", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Deadlocks", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "description": "Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an index. Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which evaluates the WHERE condition for the rows. With ICP enabled, and if parts of the WHERE condition can be evaluated by using only columns from the index, the MySQL server pushes this part of the WHERE condition down to the storage engine. The storage engine then evaluates the pushed index condition by using the index entry and only if this is satisfied is the row read from the table. ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine.", | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 12, | |
| "y": 25 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 48, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "hideEmpty": false, | |
| "hideZero": true, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "Index Condition Pushdown optimisation - MySQL 5.7 Manual", | |
| "url": "https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html" | |
| }, | |
| { | |
| "targetBlank": true, | |
| "title": "ICP counters and how to interpret them", | |
| "url": "https://www.percona.com/blog/2017/05/09/mariadb-handler_icp_-counters-what-they-are-and-how-to-use-them/" | |
| } | |
| ], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "rate(mysql_info_schema_innodb_metrics_icp_icp_attempts_total{instance=\"$host\"}[$interval])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Attempts", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "rate(mysql_info_schema_innodb_metrics_icp_icp_match_total{instance=\"$host\"}[$interval])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Matches", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "rate(mysql_info_schema_innodb_metrics_icp_icp_no_match_total{instance=\"$host\"}[$interval])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "No Matches", | |
| "refId": "C", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "rate(mysql_info_schema_innodb_metrics_icp_icp_out_of_range_total{instance=\"$host\"}[$interval])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Out of Range", | |
| "refId": "D", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Index Condition Pushdown (ICP)", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": "", | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 32 | |
| }, | |
| "id": 55, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Buffer Pool", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 0, | |
| "y": 33 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 42, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "mysql_global_status_innodb_buffer_pool_bytes_data{instance=\"$host\"}", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Data Total", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "mysql_global_status_innodb_buffer_pool_bytes_dirty{instance=\"$host\"}", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Data Dirty", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Buffer Pool Content", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 6, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 12, | |
| "y": 33 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 3, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "mysql_global_status_buffer_pool_pages{instance=\"$host\", state=~\"free|data|misc\"}", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{ state }}", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Buffer Pool Pages", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 40 | |
| }, | |
| "id": 56, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Buffer Pool I/O", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 0, | |
| "y": 41 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 21, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_pages_created{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_pages_created{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Pages Created", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_pages_read{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_pages_read{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Pages Read", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_pages_written{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_pages_written{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Pages Written", | |
| "metric": "", | |
| "refId": "C", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Buffer Pool I/O", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 8, | |
| "y": 41 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 41, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Disk Reads", | |
| "yaxis": 2 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_buffer_pool_read_requests{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_requests{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Read Requests", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_buffer_pool_write_requests{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_write_requests{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Write Requests", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_buffer_pool_reads{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_reads{instance=\"$host\"}[5m]) ", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Disk Reads", | |
| "metric": "", | |
| "refId": "C", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Buffer Pool Requests", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "Paged Fetched by Random Read Ahead": "#6ED0E0", | |
| "Paged Fetched by Read Ahead but Never Accessed": "#EF843C", | |
| "Percent of IO Caused by Read Ahead": "#0A437C", | |
| "Read Ahead Waste Percent": "#BF1B00" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 16, | |
| "y": 41 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 49, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Read Ahead Waste Percent", | |
| "yaxis": 2 | |
| }, | |
| { | |
| "alias": "Percent of IO Caused by Read Ahead", | |
| "yaxis": 2 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_buffer_pool_read_ahead{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_ahead{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Pages Fetched by Linear Read Ahead ", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_buffer_pool_read_ahead_rnd{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_ahead_rnd{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Paged Fetched by Random Read Ahead", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "rate(mysql_global_status_innodb_buffer_pool_read_ahead_evicted{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_ahead_evicted{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Paged Fetched by Read Ahead but Never Accessed", | |
| "metric": "go_gc_duration_seconds_count", | |
| "refId": "C", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "(rate(mysql_global_status_innodb_buffer_pool_read_ahead_evicted{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_ahead_evicted{instance=\"$host\"}[5m])) / ((rate(mysql_global_status_innodb_buffer_pool_read_ahead{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_ahead{instance=\"$host\"}[5m])) + (rate(mysql_global_status_innodb_buffer_pool_read_ahead_rnd{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_ahead_rnd{instance=\"$host\"}[5m])))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Read Ahead Waste Percent", | |
| "refId": "D", | |
| "step": 300 | |
| }, | |
| { | |
| "expr": "((rate(mysql_global_status_innodb_buffer_pool_read_ahead{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_ahead{instance=\"$host\"}[5m]))+(rate(mysql_global_status_innodb_buffer_pool_read_ahead_rnd{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_buffer_pool_read_ahead_rnd{instance=\"$host\"}[5m])))/(rate(mysql_global_status_innodb_pages_read{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_pages_read{instance=\"$host\"}[5m])\n)", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Percent of IO Caused by Read Ahead", | |
| "refId": "E", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Innodb Read-Ahead", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "percentunit", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "collapsed": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 48 | |
| }, | |
| "id": 57, | |
| "panels": [], | |
| "repeat": null, | |
| "title": "Change/Insert Buffer", | |
| "type": "row" | |
| }, | |
| { | |
| "aliasColors": { | |
| "Uncheckpointed Bytes": "#E0752D" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 6, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 0, | |
| "y": 49 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 39, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "mysql_global_status_innodb_ibuf_segment_size{instance=\"$host\"} * mysql_global_status_innodb_page_size{instance=\"$host\"}", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Allocated", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "(mysql_global_status_innodb_ibuf_segment_size{instance=\"$host\"} - mysql_global_status_innodb_ibuf_free_list{instance=\"$host\"})*mysql_global_status_innodb_page_size{instance=\"$host\"}", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Used", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Change Buffer", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bytes", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": {}, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 12, | |
| "x": 12, | |
| "y": 49 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 40, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "hideEmpty": false, | |
| "hideZero": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "percentage": false, | |
| "pluginVersion": "7.5.6", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_ibuf_merges{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_ibuf_merges{instance=\"$host\"}[5m]) or rate(mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_total{instance=\"$host\"}[$interval]) or irate(mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_total{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Merges", | |
| "metric": "", | |
| "refId": "A", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_ibuf_merged_inserts{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_ibuf_merged_inserts{instance=\"$host\"}[5m]) or rate(mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_insert_total{instance=\"$host\"}[$interval]) or irate(mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_insert_total{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Merged Inserts", | |
| "metric": "", | |
| "refId": "B", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_ibuf_merged_deletes{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_ibuf_merged_deletes{instance=\"$host\"}[5m]) or rate(mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_delete_total{instance=\"$host\"}[$interval]) or irate(mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_delete_total{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Merged Deletes", | |
| "metric": "", | |
| "refId": "C", | |
| "step": 300 | |
| }, | |
| { | |
| "calculatedInterval": "2m", | |
| "datasourceErrors": {}, | |
| "errors": {}, | |
| "expr": "rate(mysql_global_status_innodb_ibuf_merged_delete_marks{instance=\"$host\"}[$interval]) or irate(mysql_global_status_innodb_ibuf_merged_delete_marks{instance=\"$host\"}[5m]) or rate(mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_delete_mark_total{instance=\"$host\"}[$interval]) or irate(mysql_info_schema_innodb_metrics_change_buffer_ibuf_merges_delete_mark_total{instance=\"$host\"}[5m])", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Merged Delete Marks", | |
| "metric": "", | |
| "refId": "D", | |
| "step": 300 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "InnoDB Change Buffer Activity", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "refresh": "1m", | |
| "schemaVersion": 27, | |
| "style": "dark", | |
| "tags": [ | |
| "MySQL", | |
| "Percona" | |
| ], | |
| "templating": { | |
| "list": [ | |
| { | |
| "allFormat": "glob", | |
| "auto": true, | |
| "auto_count": 200, | |
| "auto_min": "1s", | |
| "current": { | |
| "selected": false, | |
| "text": "auto", | |
| "value": "$__auto_interval_interval" | |
| }, | |
| "datasource": "Prometheus", | |
| "description": null, | |
| "error": null, | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "Interval", | |
| "multi": false, | |
| "multiFormat": "glob", | |
| "name": "interval", | |
| "options": [ | |
| { | |
| "selected": true, | |
| "text": "auto", | |
| "value": "$__auto_interval_interval" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1s", | |
| "value": "1s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5s", | |
| "value": "5s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1m", | |
| "value": "1m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5m", | |
| "value": "5m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1h", | |
| "value": "1h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "6h", | |
| "value": "6h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1d", | |
| "value": "1d" | |
| } | |
| ], | |
| "query": "1s,5s,1m,5m,1h,6h,1d", | |
| "refresh": 2, | |
| "skipUrlSync": false, | |
| "type": "interval" | |
| }, | |
| { | |
| "allFormat": "glob", | |
| "allValue": null, | |
| "current": {}, | |
| "datasource": "${DS_GRAFANACLOUD-WOUTER4-PROM}", | |
| "definition": "", | |
| "description": null, | |
| "error": null, | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "Host", | |
| "multi": false, | |
| "multiFormat": "regex values", | |
| "name": "host", | |
| "options": [], | |
| "query": { | |
| "query": "label_values(mysql_up, instance)", | |
| "refId": "grafanacloud-wouter4-prom-host-Variable-Query" | |
| }, | |
| "refresh": 1, | |
| "refresh_on_load": false, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 1, | |
| "tagValuesQuery": null, | |
| "tags": [], | |
| "tagsQuery": null, | |
| "type": "query", | |
| "useTags": false | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now-12h", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "collapse": false, | |
| "enable": true, | |
| "hidden": false, | |
| "notice": false, | |
| "now": true, | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ], | |
| "status": "Stable", | |
| "time_options": [ | |
| "5m", | |
| "15m", | |
| "1h", | |
| "6h", | |
| "12h", | |
| "24h", | |
| "2d", | |
| "7d", | |
| "30d" | |
| ], | |
| "type": "timepicker" | |
| }, | |
| "timezone": "browser", | |
| "title": "MySQL", | |
| "uid": "giGgrTimz", | |
| "version": 5 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment