Created
November 4, 2018 14:46
-
-
Save fipar/87fe346de88aa71b9f7656dc5938c23d to your computer and use it in GitHub Desktop.
cassandra-detail with deprecated count_scalar replaced by count(scalar(
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
| { | |
| "__inputs": [ | |
| { | |
| "name": "DS_PROMETHEUS", | |
| "label": "Prometheus", | |
| "description": "with node exporter and jmx exporter", | |
| "type": "datasource", | |
| "pluginId": "prometheus", | |
| "pluginName": "Prometheus" | |
| } | |
| ], | |
| "__requires": [ | |
| { | |
| "type": "panel", | |
| "id": "graph", | |
| "name": "Graph", | |
| "version": "" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "text", | |
| "name": "Text", | |
| "version": "" | |
| }, | |
| { | |
| "type": "grafana", | |
| "id": "grafana", | |
| "name": "Grafana", | |
| "version": "3.1.1" | |
| }, | |
| { | |
| "type": "datasource", | |
| "id": "prometheus", | |
| "name": "Prometheus", | |
| "version": "1.0.0" | |
| } | |
| ], | |
| "id": null, | |
| "title": "Cassandra detail", | |
| "tags": [], | |
| "style": "dark", | |
| "timezone": "browser", | |
| "editable": true, | |
| "hideControls": false, | |
| "sharedCrosshair": false, | |
| "rows": [ | |
| { | |
| "collapse": false, | |
| "editable": true, | |
| "height": "250px", | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "decimals": 1, | |
| "editable": true, | |
| "error": false, | |
| "fill": 6, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 4, | |
| "isNew": true, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 6, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(irate(node_cpu{alias=\"$instance\"}[5m])) by (mode) * 100 / scalar(count(node_cpu{mode=\"user\", alias=\"$instance\"}))", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{mode}}", | |
| "refId": "B", | |
| "step": 120 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "CPU", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "percent", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 6, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 5, | |
| "isNew": true, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 6, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "node_memory_Buffers{alias=\"$instance\"} * 100/ node_memory_MemTotal", | |
| "interval": "", | |
| "intervalFactor": 2, | |
| "legendFormat": "buffer", | |
| "refId": "A", | |
| "step": 240 | |
| }, | |
| { | |
| "expr": "node_memory_MemFree{alias=\"$instance\"} * 100/ node_memory_MemTotal", | |
| "intervalFactor": 2, | |
| "legendFormat": "free", | |
| "refId": "B", | |
| "step": 240 | |
| }, | |
| { | |
| "expr": "node_memory_Cached{alias=\"$instance\"} * 100/ node_memory_MemTotal", | |
| "intervalFactor": 2, | |
| "legendFormat": "cached", | |
| "refId": "C", | |
| "step": 240 | |
| }, | |
| { | |
| "expr": "(node_memory_MemTotal - node_memory_Cached{alias=\"$instance\"} - node_memory_MemFree{alias=\"$instance\"} - node_memory_Buffers{alias=\"$instance\"}) * 100 / node_memory_MemTotal", | |
| "intervalFactor": 2, | |
| "legendFormat": "used", | |
| "refId": "D", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Memory", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "percent", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 6, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 6, | |
| "isNew": true, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "hideEmpty": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "node_filesystem_size{alias=\"$instance\", fstype!~\"rootfs|selinuxfs|autofs|rpc_pipefs|tmpfs\", mountpoint=\"$mountpoint\"} - node_filesystem_avail{alias=\"$instance\", fstype!~\"rootfs|selinuxfs|autofs|rpc_pipefs|tmpfs\", mountpoint=\"$mountpoint\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "Used (device {{ device }}, {{ fstype }})", | |
| "refId": "A", | |
| "step": 240 | |
| }, | |
| { | |
| "expr": "node_filesystem_avail{alias=\"$instance\", fstype!~\"rootfs|selinuxfs|autofs|rpc_pipefs|tmpfs\", mountpoint=\"$mountpoint\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "Free (device {{ device }}, {{ fstype }})", | |
| "refId": "B", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Disk", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bytes", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "bytes", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 6, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 7, | |
| "isNew": true, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "irate(node_network_receive_bytes{alias=\"$instance\", device!=\"lo\"}[5m])", | |
| "intervalFactor": 1, | |
| "legendFormat": "Inbound: {{ device }}", | |
| "refId": "A", | |
| "step": 120 | |
| }, | |
| { | |
| "expr": "irate(node_network_transmit_bytes{alias=\"$instance\", device!=\"lo\"}[5m])", | |
| "intervalFactor": 1, | |
| "legendFormat": "Outbound: {{ device }}", | |
| "refId": "B", | |
| "step": 120 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Network", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "Bps", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "bytes", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fill": 2, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 8, | |
| "isNew": true, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "node_load1{alias=\"$instance\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "1m", | |
| "refId": "A", | |
| "step": 240 | |
| }, | |
| { | |
| "expr": "node_load5{alias=\"$instance\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "5m", | |
| "refId": "B", | |
| "step": 240 | |
| }, | |
| { | |
| "expr": "node_load15{alias=\"$instance\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "15m", | |
| "refId": "C", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Load", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| } | |
| ], | |
| "title": "Row" | |
| }, | |
| { | |
| "collapse": false, | |
| "editable": true, | |
| "height": "250px", | |
| "panels": [ | |
| { | |
| "content": "Below is the Cassandra metrics", | |
| "editable": true, | |
| "error": false, | |
| "height": "50px", | |
| "id": 9, | |
| "isNew": true, | |
| "links": [], | |
| "mode": "markdown", | |
| "span": 12, | |
| "title": "", | |
| "type": "text" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 3, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(irate(cassandra_columnfamily_writelatency{alias=\"$instance\"}[5m]))", | |
| "intervalFactor": 2, | |
| "legendFormat": "write", | |
| "refId": "A", | |
| "step": 240 | |
| }, | |
| { | |
| "expr": "sum(irate(cassandra_columnfamily_readlatency{alias=\"$instance\"}[5m]))", | |
| "intervalFactor": 2, | |
| "legendFormat": "read", | |
| "refId": "B", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "ColumnFamily Read / Write Latency", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "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 | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 2, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "cassandra_filecache_hitrate{alias=\"$instance\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "{{hit rate}}", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "KeyCache Hit Rate", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": 1, | |
| "min": 0, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 1, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "irate(cassandra_clientrequest_latency{alias=\"$instance\"} [5m])", | |
| "intervalFactor": 2, | |
| "legendFormat": "{{clientrequest}}", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Client Latency", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "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 | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 6, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 10, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(cassandra_keyspace_livediskspaceused) by (keyspace)", | |
| "intervalFactor": 2, | |
| "legendFormat": "{{keyspace}}", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Keyspace live disk usgae", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "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 | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 11, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(cassandra_keyspace_memtablelivedatasize) by (keyspace)", | |
| "intervalFactor": 2, | |
| "legendFormat": "{{keyspace}}", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "memtable live data size", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "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 | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 15, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "irate(cassandra_keyspace_rangelatency{alias=\"$instance\"}[5m])", | |
| "intervalFactor": 2, | |
| "legendFormat": "{{keyspace}}", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Keyspace Range latency", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "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 | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 16, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "cassandra_client_connectednativeclients{alias=\"$instance\"}", | |
| "intervalFactor": 1, | |
| "legendFormat": "Native", | |
| "refId": "A", | |
| "step": 120 | |
| }, | |
| { | |
| "expr": "cassandra_client_connectedthriftclients{alias=\"$instance\"}", | |
| "intervalFactor": 1, | |
| "legendFormat": "Thrift", | |
| "refId": "B", | |
| "step": 120 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Client count", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "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 | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 6, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 17, | |
| "isNew": true, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "cassandra_cache_capacity{alias=\"$instance\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "{{cache}}", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Cache capacity", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bytes", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 18, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "rate(node_vmstat_pgpgin{alias=\"$instance\"}[5m]) * 1024 or irate(node_vmstat_pgpgin{alias=\"$instance\"}[5m]) * 1024", | |
| "intervalFactor": 2, | |
| "legendFormat": "Page In", | |
| "refId": "A", | |
| "step": 240 | |
| }, | |
| { | |
| "expr": "rate(node_vmstat_pgpgout{alias=\"$instance\"}[5m]) * 1024 or irate(node_vmstat_pgpgout{alias=\"$instance\"}[5m]) * 1024", | |
| "intervalFactor": 2, | |
| "legendFormat": "Page Out", | |
| "refId": "B", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Disk I/O Activity", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bytes", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| } | |
| ], | |
| "title": "New row" | |
| }, | |
| { | |
| "collapse": false, | |
| "editable": true, | |
| "height": "250px", | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 12, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "jvm_memory_bytes_max{area=\"heap\",alias=\"$instance\"} / jvm_memory_bytes_max{area=\"heap\", alias=\"$instance\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "heap", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Heap usage", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "percentunit", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 13, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "jvm_memory_pool_bytes_used{alias=\"$instance\"}", | |
| "intervalFactor": 2, | |
| "legendFormat": "{{pool}}", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Memory Pool used", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bytes", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": { | |
| "threshold1": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2": null, | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "id": 14, | |
| "isNew": true, | |
| "legend": { | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "span": 4, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "irate(jvm_gc_collection_seconds_sum{alias=\"$instance\"}[5m])", | |
| "intervalFactor": 2, | |
| "legendFormat": "{{gc}}", | |
| "refId": "A", | |
| "step": 240 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "GC count", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "show": true | |
| }, | |
| "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 | |
| } | |
| ] | |
| } | |
| ], | |
| "title": "New row" | |
| } | |
| ], | |
| "time": { | |
| "from": "now-24h", | |
| "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" | |
| ] | |
| }, | |
| "templating": { | |
| "list": [ | |
| { | |
| "current": {}, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "instance", | |
| "multi": false, | |
| "name": "instance", | |
| "options": [], | |
| "query": "up{job=\"cassandra\"}", | |
| "refresh": 1, | |
| "regex": "/.*{alias=\"(.*)\",ins.*/", | |
| "type": "query" | |
| }, | |
| { | |
| "current": {}, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "Mountpoint", | |
| "multi": false, | |
| "name": "mountpoint", | |
| "options": [], | |
| "query": "label_values(node_filesystem_avail{alias=\"$instance\", fstype!~\"rootfs|selinuxfs|autofs|rpc_pipefs|tmpfs\"}, mountpoint)", | |
| "refresh": 1, | |
| "regex": "", | |
| "type": "query" | |
| } | |
| ] | |
| }, | |
| "annotations": { | |
| "list": [] | |
| }, | |
| "schemaVersion": 12, | |
| "version": 1, | |
| "links": [], | |
| "gnetId": 371, | |
| "description": "Display cassandra node detail in OS, Cassandra and JVM blocks" | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment