Created
December 10, 2020 08:35
-
-
Save tzolov/d2a71fc58616278fb8852f5fc43d242f to your computer and use it in GitHub Desktop.
This file contains 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
{ | |
"annotations": { | |
"list": [ | |
{ | |
"builtIn": 1, | |
"datasource": "-- Grafana --", | |
"enable": true, | |
"hide": true, | |
"iconColor": "rgba(0, 211, 255, 1)", | |
"name": "Annotations & Alerts", | |
"type": "dashboard" | |
} | |
] | |
}, | |
"editable": true, | |
"gnetId": null, | |
"graphTooltip": 0, | |
"id": 6, | |
"links": [ | |
{ | |
"$$hashKey": "object:77", | |
"icon": "external link", | |
"tags": [], | |
"type": "dashboards" | |
} | |
], | |
"panels": [ | |
{ | |
"aliasColors": {}, | |
"breakPoint": "50%", | |
"cacheTimeout": null, | |
"combine": { | |
"label": "Others", | |
"threshold": 0 | |
}, | |
"datasource": null, | |
"fieldConfig": { | |
"defaults": { | |
"custom": {} | |
}, | |
"overrides": [] | |
}, | |
"fontSize": "80%", | |
"format": "short", | |
"gridPos": { | |
"h": 9, | |
"w": 6, | |
"x": 0, | |
"y": 0 | |
}, | |
"id": 4, | |
"interval": null, | |
"legend": { | |
"show": true, | |
"values": true | |
}, | |
"legendType": "Under graph", | |
"links": [], | |
"nullPointMode": "connected", | |
"pieType": "donut", | |
"pluginVersion": "7.1.5", | |
"strokeWidth": 1, | |
"targets": [ | |
{ | |
"expr": "sort_desc(topk(100, sum(cdc_total{table!='NA',table!=''}) by (table)))", | |
"instant": true, | |
"interval": "", | |
"legendFormat": "{{table}}", | |
"refId": "A" | |
} | |
], | |
"timeFrom": null, | |
"timeShift": null, | |
"title": "Operations per table", | |
"type": "grafana-piechart-panel", | |
"valueName": "current" | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": true, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": null, | |
"fieldConfig": { | |
"defaults": { | |
"custom": {} | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 9, | |
"w": 9, | |
"x": 6, | |
"y": 0 | |
}, | |
"hiddenSeries": false, | |
"id": 2, | |
"legend": { | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"show": false, | |
"total": false, | |
"values": false | |
}, | |
"lines": false, | |
"linewidth": 1, | |
"nullPointMode": "null", | |
"percentage": false, | |
"pluginVersion": "7.1.5", | |
"pointradius": 2, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"expr": "sort_desc(topk(100, sum(cdc_total{table!='n.a', table!='NA', table!=''}) by (db, table)))", | |
"instant": true, | |
"interval": "", | |
"legendFormat": "{{table}}", | |
"refId": "A" | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Operations per table", | |
"tooltip": { | |
"shared": false, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "series", | |
"name": null, | |
"show": true, | |
"values": [ | |
"total" | |
] | |
}, | |
"yaxes": [ | |
{ | |
"$$hashKey": "object:40", | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"$$hashKey": "object:41", | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": true, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": null, | |
"description": "Database operations:\nc - create\nu - update\nd - delete\n", | |
"fieldConfig": { | |
"defaults": { | |
"custom": {} | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 9, | |
"w": 9, | |
"x": 15, | |
"y": 0 | |
}, | |
"hiddenSeries": false, | |
"id": 6, | |
"legend": { | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"show": false, | |
"total": false, | |
"values": false | |
}, | |
"lines": false, | |
"linewidth": 1, | |
"nullPointMode": "null", | |
"percentage": false, | |
"pluginVersion": "7.1.5", | |
"pointradius": 2, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"expr": "sort_desc(topk(100, sum(cdc_total{operation!='NA',operation!='n.a',operation!=''}) by (operation)))", | |
"instant": true, | |
"interval": "", | |
"legendFormat": "{{operation}}", | |
"refId": "A" | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Database Operations", | |
"tooltip": { | |
"shared": false, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "series", | |
"name": null, | |
"show": true, | |
"values": [ | |
"total" | |
] | |
}, | |
"yaxes": [ | |
{ | |
"$$hashKey": "object:232", | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"$$hashKey": "object:233", | |
"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": null, | |
"fieldConfig": { | |
"defaults": { | |
"custom": {} | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 10, | |
"w": 15, | |
"x": 0, | |
"y": 9 | |
}, | |
"hiddenSeries": false, | |
"id": 8, | |
"legend": { | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": false, | |
"values": false | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"nullPointMode": "null", | |
"percentage": false, | |
"pluginVersion": "7.1.5", | |
"pointradius": 2, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"expr": "rate(cdc_total{db!='NA',table!='NA'}[60s])", | |
"hide": false, | |
"interval": "", | |
"legendFormat": "{{db}}:{{table}}:{{operation}}", | |
"refId": "C" | |
}, | |
{ | |
"expr": "sum(rate(cdc_total{db!='NA'}[60s])) by (db, table, operation)", | |
"hide": true, | |
"interval": "", | |
"legendFormat": "{{db}}:{{table}}:{{operation}}", | |
"refId": "A" | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "DB operations throughput", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"$$hashKey": "object:53", | |
"format": "ops", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": "0", | |
"show": true | |
}, | |
{ | |
"$$hashKey": "object:54", | |
"format": "ops", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": "0", | |
"show": false | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"datasource": null, | |
"fieldConfig": { | |
"defaults": { | |
"custom": {}, | |
"mappings": [], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
} | |
] | |
} | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 10, | |
"w": 9, | |
"x": 15, | |
"y": 9 | |
}, | |
"id": 9, | |
"options": { | |
"displayMode": "basic", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"last" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"showUnfilled": true | |
}, | |
"pluginVersion": "7.1.5", | |
"targets": [ | |
{ | |
"expr": "topK(20, sum(cdc_total{table!='NA'}) by (db, table))", | |
"instant": true, | |
"interval": "", | |
"legendFormat": "{{db}} / {{table}}", | |
"refId": "A" | |
} | |
], | |
"timeFrom": null, | |
"timeShift": null, | |
"title": "Top Operations per table", | |
"type": "bargauge" | |
} | |
], | |
"refresh": "10s", | |
"schemaVersion": 26, | |
"style": "dark", | |
"tags": [], | |
"templating": { | |
"list": [] | |
}, | |
"time": { | |
"from": "now-15m", | |
"to": "now" | |
}, | |
"timepicker": { | |
"refresh_intervals": [ | |
"5s", | |
"10s", | |
"30s", | |
"1m", | |
"5m", | |
"15m", | |
"30m", | |
"1h", | |
"2h", | |
"1d" | |
] | |
}, | |
"timezone": "", | |
"title": "CDC Dashboard", | |
"uid": "bAwwDm1Gk", | |
"version": 6 | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment