Skip to content

Instantly share code, notes, and snippets.

@guy9

guy9/sl-demo-dash-v3.json

Created December 18, 2023 17:10
Show Gist options
  • Save guy9/f0d8c8c229642544313e456ef3f91e49 to your computer and use it in GitHub Desktop.
Save guy9/f0d8c8c229642544313e456ef3f91e49 to your computer and use it in GitHub Desktop.
Download ZIP
Workload Prioritization Example Demo
Raw
sl-demo-dash-v3.json
{
"annotations": {
"class": "default_annotations",
"list": [
{
"builtIn": 1,
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
},
{
"class": "annotation_restart",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": true,
"expr": "resets(scylla_gossip_heart_beat{cluster=~\"$cluster|$^\"}[$__rate_interval])>0",
"hide": false,
"iconColor": "rgba(255, 96, 96, 1)",
"limit": 100,
"name": "node_restart",
"showIn": 0,
"tagKeys": "instance,dc,cluster",
"tags": [],
"titleFormat": "restart",
"type": "tags"
},
{
"class": "annotation_stall",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": false,
"expr": "changes(scylla_stall_detector_reported{cluster=~\"$cluster|$^\"}[$__rate_interval])>0",
"hide": false,
"iconColor": "rgba(255, 96, 96, 1)",
"limit": 100,
"name": "stall detector",
"showIn": 0,
"tagKeys": "dc,instance,shard",
"tags": [],
"titleFormat": "Stall found",
"type": "tags"
},
{
"class": "annotation_schema_changed",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": false,
"expr": "changes(scylla_database_schema_changed{cluster=~\"$cluster|$^\"}[$__rate_interval])>0",
"hide": false,
"iconColor": "rgba(255, 96, 96, 1)",
"limit": 100,
"name": "Schema Changed",
"showIn": 0,
"tagKeys": "instance,dc,cluster",
"tags": [],
"titleFormat": "schema changed",
"type": "tags"
},
{
"class": "annotation_manager_task",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": true,
"expr": "scylla_manager_task_active_count{type=~\"repair|backup\",cluster=~\"$cluster|$^\"}>0",
"hide": false,
"iconColor": "#73BF69",
"limit": 100,
"name": "Task",
"showIn": 0,
"tagKeys": "type",
"tags": [],
"titleFormat": "Running",
"type": "tags"
},
{
"class": "annotation_hints_writes",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": false,
"expr": "changes(scylla_hints_manager_written{cluster=~\"$cluster|$^\"}[$__rate_interval])>0",
"hide": false,
"iconColor": "rgb(255, 176, 0, 128)",
"limit": 100,
"name": "Hints Write",
"showIn": 0,
"tagKeys": "instance,dc,cluster",
"tags": [],
"titleFormat": "Hints write",
"type": "tags"
},
{
"class": "annotation_hints_sent",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": false,
"expr": "changes(scylla_hints_manager_written{cluster=~\"$cluster|$^\"}[$__rate_interval])>0",
"hide": false,
"iconColor": "rgb(50, 176, 0, 128)",
"limit": 100,
"name": "Hints Sent",
"showIn": 0,
"tagKeys": "instance,dc,cluster",
"tags": [],
"titleFormat": "Hints Sent",
"type": "tags"
},
{
"class": "mv_building",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": true,
"expr": "sum(scylla_view_builder_builds_in_progress{cluster=~\"$cluster|$^\"})>0",
"hide": false,
"iconColor": "rgb(50, 176, 0, 128)",
"limit": 100,
"name": "MV",
"showIn": 0,
"tagKeys": "instance,dc,cluster",
"tags": [],
"titleFormat": "Materialized View built",
"type": "tags"
},
{
"class": "ops_annotation",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": true,
"expr": "10*min(scylla_node_ops_finished_percentage{cluster=~\"$cluster|$^\"}) by (ops, dc,instance) < 10",
"hide": false,
"iconColor": "rgb(50, 176, 0, 128)",
"limit": 100,
"name": "ops",
"showIn": 0,
"tagKeys": "ops,dc,instance",
"tags": [],
"titleFormat": "Operation",
"type": "tags"
},
{
"class": "stream_annotation",
"dashversion": [
">5.2",
">2023.1"
],
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"enable": true,
"expr": "10*min(scylla_streaming_finished_percentage{cluster=~\"$cluster|$^\"}) by (ops, dc,instance) < 10",
"hide": false,
"iconColor": "rgb(50, 176, 0, 128)",
"limit": 100,
"name": "streaming",
"showIn": 0,
"tagKeys": "ops,dc,instance",
"tags": [],
"titleFormat": "Streaming",
"type": "tags"
}
]
},
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 1,
"id": 7,
"links": [
{
"asDropdown": true,
"icon": "external link",
"includeVars": true,
"keepTime": true,
"tags": [],
"type": "dashboards"
}
],
"liveNow": false,
"panels": [
{
"collapsed": false,
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 0
},
"id": 1,
"panels": [],
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"title": "Cluster overview $cluster",
"type": "row"
},
{
"class": "text_panel",
"dashproductreject": "no-version-check",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 1,
"w": 9,
"x": 0,
"y": 1
},
"id": 2,
"isNew": true,
"links": [],
"mode": "html",
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<img src=\"https://repositories.scylladb.com/scylla/imgversion/$monitoring_version/scylla-monitoring\">",
"mode": "html"
},
"pluginVersion": "9.5.5",
"span": 12,
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"type": "text"
},
{
"class": "text_panel",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 1,
"w": 4,
"x": 9,
"y": 1
},
"id": 3,
"isNew": true,
"links": [],
"mode": "html",
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "# ",
"mode": "markdown"
},
"pluginVersion": "9.5.5",
"span": 12,
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"type": "text"
},
{
"class": "text_panel",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 1,
"w": 4,
"x": 13,
"y": 1
},
"id": 4,
"isNew": true,
"links": [],
"mode": "html",
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "# ",
"mode": "markdown"
},
"pluginVersion": "9.5.5",
"span": 12,
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"type": "text"
},
{
"class": "text_panel",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 1,
"w": 7,
"x": 17,
"y": 1
},
"id": 5,
"isNew": true,
"links": [],
"mode": "html",
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "# ",
"mode": "markdown"
},
"pluginVersion": "9.5.5",
"span": 12,
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"type": "text"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "The number of nodes configured in the cluster.",
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 0,
"y": 2
},
"id": 6,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "count(scylla_scylladb_current_version{job=\"scylla\", cluster=~\"$cluster|$^\"})",
"intervalFactor": 1,
"legendFormat": "Total Nodes",
"refId": "A",
"step": 40
}
],
"title": "# Nodes",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "The number of unreachable nodes.\nUsually because a machine is down or unreachable.",
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "green",
"value": 0
},
{
"color": "red",
"value": 1
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 2,
"y": 2
},
"id": 7,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "(count(scrape_samples_scraped{job=\"scylla\", cluster=~\"$cluster|$^\"}==0) OR vector(0))",
"intervalFactor": 1,
"legendFormat": "Offline ",
"refId": "A",
"step": 20
}
],
"title": "Unreachable",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "The number of joining and leaving nodes.\nThe number of nodes that are up but not actively part of the cluster, either because they are still joining or because they are leaving.",
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "green",
"value": 0
},
{
"color": "red",
"value": 1
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 4,
"y": 2
},
"id": 8,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "count(scylla_node_operation_mode{cluster=~\"$cluster|$^\"}!=3)OR vector(0)",
"intervalFactor": 1,
"legendFormat": "Offline ",
"refId": "A",
"step": 20
}
],
"thresholds": "1,2",
"title": "Inactive",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"fieldConfig": {
"defaults": {
"mappings": [
{
"options": {
"0": {
"text": "Online"
},
"1": {
"text": "Repair"
},
"2": {
"text": "Backup"
},
"-1": {
"text": "Offline"
}
},
"type": "value"
}
],
"noValue": " Offline",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "red",
"value": null
},
{
"color": "green",
"value": 0
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 6,
"y": 2
},
"id": 9,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "(sum(scylla_manager_task_active_count{type=~\"repair\",cluster=~\"$cluster|$^\"}) or on() vector(0)) + (sum(scylla_manager_task_active_count{type=~\"backup\",cluster=~\"$cluster|$^\"})*2 or on() vector(0)) + (sum(scylla_manager_server_current_version{}) or on() vector(-1))",
"intervalFactor": 1,
"refId": "A",
"step": 40
}
],
"title": "Manager",
"type": "stat"
},
{
"class": "vertical_lcd",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 1,
"x": 8,
"y": 2
},
"id": 10,
"options": {
"displayMode": "lcd",
"minVizHeight": 10,
"minVizWidth": 0,
"orientation": "vertical",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"showUnfilled": true,
"valueMode": "color"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "(sum(avg(scylla_manager_repair_progress{cluster=~\"$cluster|$^\"}) by (task) * sum(scylla_manager_task_active_count{type=\"repair\",cluster=~\"$cluster|$^\"}) by (task)) or on () vector(0)) + (sum(avg(scylla_manager_backup_percent_progress{cluster=~\"$cluster|$^\"}) by (task) * sum(scylla_manager_task_active_count{type=\"backup\",cluster=~\"$cluster|$^\"}) by (task)) or on () vector(0))",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "A"
}
],
"type": "bargauge"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Average Write Latency",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 50000
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 9,
"y": 2
},
"id": 11,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(wlatencya{by=\"cluster\", cluster=~\"$cluster|^$\",scheduling_group_name=~\"$sg\"}>0)",
"instant": true,
"intervalFactor": 1,
"legendFormat": "",
"refId": "A",
"step": 4
}
],
"title": "Avg Write",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "99% write Latency",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 100000
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 11,
"y": 2
},
"id": 12,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(wlatencyp99{by=\"cluster\", cluster=~\"$cluster|^$\",scheduling_group_name=~\"$sg\"}>0)",
"instant": true,
"intervalFactor": 1,
"legendFormat": "",
"refId": "A",
"step": 4
}
],
"title": "99% Write",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Average Read Latency",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 50000
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 13,
"y": 2
},
"id": 13,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(rlatencya{by=\"cluster\", cluster=~\"$cluster|^$\",scheduling_group_name=~\"$sg\"}>0)",
"instant": true,
"intervalFactor": 1,
"legendFormat": "",
"refId": "A",
"step": 4
}
],
"title": "Avg Read",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "99% read Latency",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 100000
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 15,
"y": 2
},
"id": 14,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(rlatencyp99{by=\"cluster\", cluster=~\"$cluster|^$\",scheduling_group_name=~\"$sg\"}>0)",
"instant": true,
"intervalFactor": 1,
"legendFormat": "",
"refId": "A",
"step": 4
}
],
"title": "99% Read",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"fieldConfig": {
"defaults": {
"decimals": 1,
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "si:"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 3,
"x": 17,
"y": 2
},
"id": 15,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "sum(rate(scylla_transport_requests_served{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[60s])) + (sum(rate(scylla_thrift_served{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[60s])) or on() vector(0))",
"instant": true,
"intervalFactor": 1,
"refId": "A",
"step": 40
}
],
"title": "Requests/s",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "The percentage of the time during which Scylla utilized the CPU. Note that because Scylla does busy polling for some time before going idle, CPU utilization as seen by the operating system may be much higher. Your system is not yet CPU-bottlenecked until this metric is high.",
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 20,
"y": 2
},
"id": 16,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(scylla_reactor_utilization{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"} )",
"instant": true,
"intervalFactor": 1,
"legendFormat": "",
"refId": "A",
"step": 4
}
],
"title": "Load",
"type": "stat"
},
{
"class": "small_stat",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"fieldConfig": {
"defaults": {
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 1
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 4,
"w": 2,
"x": 22,
"y": 2
},
"id": 17,
"options": {
"colorMode": "value",
"graphMode": "none",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "sum(rate(scylla_storage_proxy_coordinator_write_timeouts{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]|$^\"}[1m]))",
"instant": true,
"intervalFactor": 1,
"refId": "A",
"step": 40
}
],
"title": "Timeouts",
"type": "stat"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Write attempts - include all writes that reached the coordinator node, even if they will eventually fail",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 10,
"w": 4,
"x": 0,
"y": 6
},
"id": 18,
"isNew": true,
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(scylla_reactor_utilization{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"} ) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "Load",
"range": true,
"refId": "A",
"step": 1
}
],
"title": "Load",
"type": "timeseries"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Write attempts - include all writes that reached the coordinator node, even if they will eventually fail",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 10,
"w": 4,
"x": 4,
"y": 6
},
"id": 47,
"isNew": true,
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "($func(rate(scylla_storage_proxy_coordinator_write_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_write_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m]))) + ($func(rate(scylla_storage_proxy_coordinator_read_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_read_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])))",
"intervalFactor": 1,
"legendFormat": "Total",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "($func(rate(scylla_storage_proxy_coordinator_write_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\", scheduling_group_name=~\"sl:.*\", scheduling_group!~\"sl:default\"}[1m])) by (scheduling_group_name) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_write_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\", scheduling_group_name=~\"sl:.*\", scheduling_group!~\"sl:default\"}[1m])) by (scheduling_group_name)) + ($func(rate(scylla_storage_proxy_coordinator_read_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\", scheduling_group_name=~\"sl:.*\", scheduling_group!~\"sl:default\"}[1m])) by (scheduling_group_name) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_read_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\", scheduling_group_name=~\"sl:.*\", scheduling_group!~\"sl:default\"}[1m])) by (scheduling_group_name))",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
}
],
"title": "Total Ops",
"type": "timeseries"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Write attempts - include all writes that reached the coordinator node, even if they will eventually fail",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 10,
"w": 4,
"x": 8,
"y": 6
},
"id": 45,
"isNew": true,
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "$func(rate(scylla_storage_proxy_coordinator_write_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_write_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m]))",
"intervalFactor": 1,
"legendFormat": "Total",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "$func(rate(scylla_storage_proxy_coordinator_write_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\", scheduling_group_name=~\"sl:.*\", scheduling_group!~\"sl:default\"}[1m])) by (scheduling_group_name) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_write_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\", scheduling_group_name=~\"sl:.*\", scheduling_group!~\"sl:default\"}[1m])) by (scheduling_group_name)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
}
],
"title": "Writes",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 10,
"w": 4,
"x": 12,
"y": 6
},
"id": 19,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(wlatencyp95{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name=~\"$sg\"}>0)",
"intervalFactor": 1,
"legendFormat": "95%",
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(wlatencyp99{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name=~\"$sg\"}>0)",
"intervalFactor": 1,
"legendFormat": "99%",
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencya{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name=~\"$sg\"}>0)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "Avg",
"range": true,
"refId": "C",
"step": 1
}
],
"title": "Write Latencies $sg",
"type": "timeseries"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Read attempts - include all reads that reached the coordinator node, even if they will eventually fail",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 10,
"w": 4,
"x": 16,
"y": 6
},
"id": 20,
"isNew": true,
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "$func(rate(scylla_storage_proxy_coordinator_read_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_read_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m]))",
"intervalFactor": 1,
"legendFormat": "Total",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "$func(rate(scylla_storage_proxy_coordinator_read_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\", scheduling_group_name=~\"sl:.*\", scheduling_group!~\"sl:default\"}[1m])) by (scheduling_group_name) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_read_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\", scheduling_group_name=~\"sl:.*\", scheduling_group!~\"sl:default\"}[1m])) by (scheduling_group_name)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
}
],
"title": "Reads",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 10,
"w": 4,
"x": 20,
"y": 6
},
"id": 21,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(rlatencyp95{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name=~\"$sg\"}>0)",
"intervalFactor": 1,
"legendFormat": "95%",
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(rlatencyp99{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name=~\"$sg\"}>0)",
"intervalFactor": 1,
"legendFormat": "99%",
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencya{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name=~\"$sg\"}>0)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "Avg",
"range": true,
"refId": "C",
"step": 1
}
],
"title": "Read Latencies $sg",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 4,
"x": 0,
"y": 16
},
"id": 46,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencyp95{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencyp99{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencya{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "C",
"step": 1
}
],
"title": "Write Latencies Avg",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 4,
"x": 4,
"y": 16
},
"id": 48,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencyp95{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencyp99{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencya{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "C",
"step": 1
}
],
"title": "Write Latencies 95%",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 4,
"x": 8,
"y": 16
},
"id": 49,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencyp95{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencyp99{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(wlatencya{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "C",
"step": 1
}
],
"title": "Write Latencies 99%",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 4,
"x": 12,
"y": 16
},
"id": 51,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencyp95{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencyp99{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencya{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "C",
"step": 1
}
],
"title": "Read Latencies Avg",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 4,
"x": 16,
"y": 16
},
"id": 52,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencyp95{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencyp99{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencya{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "C",
"step": 1
}
],
"title": "Read Latencies 95%",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 4,
"x": 20,
"y": 16
},
"id": 53,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencyp95{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencyp99{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(rlatencya{by=\"cluster\", cluster=~\"$cluster|$^\",scheduling_group_name !~\"sl:default\",scheduling_group_name=~\"sl:.*\"}>0) by (scheduling_group_name)",
"hide": true,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "C",
"step": 1
}
],
"title": "Read Latencies 99%",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "none"
},
"overrides": []
},
"gridPos": {
"h": 12,
"w": 4,
"x": 0,
"y": 28
},
"id": 54,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(scylla_scheduler_shares{group =~\"sl:.*\"}) by ([[by]],instance, group)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editorMode": "code",
"expr": "avg(scylla_io_queue_shares{class =~\"sl:.*\"}) by ([[by]],instance, class)",
"hide": false,
"intervalFactor": 1,
"legendFormat": "__auto",
"range": true,
"refId": "B",
"step": 1
}
],
"title": "Shares",
"type": "timeseries"
},
{
"collapsed": false,
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 40
},
"id": 22,
"panels": [],
"repeat": "dc",
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"type": "row"
},
{
"class": "plain_text",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 2,
"w": 24,
"x": 0,
"y": 41
},
"id": 23,
"isNew": true,
"links": [],
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<h1 style=\"color:#5780C1; border-bottom: 3px solid #5780C1;\">Information for $dc</h1>",
"mode": "html"
},
"pluginVersion": "9.5.5",
"span": 12,
"style": {},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"transparent": true,
"type": "text"
},
{
"class": "vertical_lcd",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"fieldConfig": {
"defaults": {
"decimals": 0,
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "orange",
"value": 85
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 1,
"x": 0,
"y": 43
},
"id": 24,
"options": {
"displayMode": "lcd",
"minVizHeight": 10,
"minVizWidth": 0,
"orientation": "vertical",
"reduceOptions": {
"calcs": [
"last"
],
"fields": "",
"values": false
},
"showUnfilled": true,
"valueMode": "color"
},
"pluginVersion": "9.5.5",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(scylla_reactor_utilization{instance=~\"[[node]]\",cluster=~\"$cluster\", dc=~\"$dc\", shard=~\"[[shard]]\"} )",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "A"
}
],
"title": "Load",
"type": "bargauge"
},
{
"class": "bytes_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "The average Disk usage per [[by]].\n\n The dashed line represent the total size.",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "bytes"
},
"overrides": [
{
"matcher": {
"id": "byFrameRefID",
"options": "B"
},
"properties": [
{
"id": "custom.lineStyle",
"value": {
"dash": [
10,
10
],
"fill": "dash"
}
},
{
"id": "custom.lineWidth",
"value": 2
}
]
}
]
},
"gridPos": {
"h": 6,
"w": 3,
"x": 1,
"y": 43
},
"id": 25,
"isNew": true,
"links": [],
"options": {
"class": "desc_tooltip_options",
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "desc"
}
},
"span": 5,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "Avg(node_filesystem_size_bytes{mountpoint=\"$mount_point\", dc=~\"$dc\", instance=~\"$node\"}) by ([[by]])-avg(node_filesystem_avail_bytes{mountpoint=\"$mount_point\", dc=~\"$dc\", instance=~\"$node\"}) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "Avg Usage {{[[by]]}}",
"metric": "",
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(node_filesystem_size_bytes{mountpoint=\"$mount_point\", dc=~\"$dc\", instance=~\"$node\"}) by ([[by]])",
"interval": "",
"legendFormat": "Size {{[[by]]}}",
"refId": "B"
}
],
"title": "Average Disk Usage",
"type": "timeseries"
},
{
"class": "graph_panel_int",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Holds the number of currently active compactions.",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 4,
"y": 43
},
"id": 26,
"isNew": true,
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(scylla_compaction_manager_compactions{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "",
"metric": "",
"refId": "A",
"step": 1
}
],
"title": "Running Compactions",
"type": "timeseries"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "The Hits and Misses",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 6,
"x": 8,
"y": 43
},
"id": 27,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 3,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_cache_row_hits{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "Hit {{[[by]]}}",
"refId": "A",
"step": 10
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_cache_row_misses{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "Misses {{[[by]]}}",
"refId": "B",
"step": 10
}
],
"title": "Cache Hits/Misses",
"type": "timeseries"
},
{
"class": "small_nodes_table",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"align": "auto",
"cellOptions": {
"type": "auto"
},
"filterable": true,
"inspect": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "orange",
"value": 85
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Value #B"
},
"properties": [
{
"id": "custom.cellOptions",
"value": {
"mode": "lcd",
"type": "gauge"
}
},
{
"id": "min",
"value": 0
},
{
"id": "max",
"value": 101
},
{
"id": "displayName",
"value": "Load"
},
{
"id": "custom.width",
"value": 120
},
{
"id": "custom.filterable",
"value": false
},
{
"id": "decimals",
"value": 0
}
]
},
{
"matcher": {
"id": "byName",
"options": "svr"
},
"properties": [
{
"id": "custom.width",
"value": 85
},
{
"id": "displayName",
"value": "Version"
}
]
},
{
"matcher": {
"id": "byName",
"options": "instance"
},
"properties": [
{
"id": "custom.width",
"value": 105
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #A"
},
"properties": [
{
"id": "custom.width",
"value": 105
},
{
"id": "displayName",
"value": "Status"
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-text"
}
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "yellow",
"value": null
},
{
"color": "rgb(87, 128, 193)",
"value": 3
},
{
"color": "red",
"value": 4
}
]
}
},
{
"id": "custom.align",
"value": "center"
},
{
"id": "mappings",
"value": [
{
"options": {
"1": {
"text": "Starting"
},
"2": {
"text": "Joining"
},
"3": {
"text": "Normal"
},
"4": {
"text": "Leaving"
},
"5": {
"text": "Decommissioned"
},
"6": {
"text": "Draining"
},
"7": {
"text": "Drained"
},
"8": {
"text": "Moving"
}
},
"type": "value"
}
]
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #E"
},
"properties": [
{
"id": "links",
"value": [
{
"title": "CQL Information Dashboard. Warning indicates that there are potential issues in the CQL Optimization",
"url": "/d/cql-[[dash_version]]/scylla-cql?refresh=30s&orgId=1&var-by=instance&var-node=${__data.fields[0]}&from=${__from}&to=${__to}"
}
]
},
{
"id": "custom.width",
"value": 90
},
{
"id": "custom.filterable",
"value": false
},
{
"id": "mappings",
"value": [
{
"options": {
"0": {
"text": "CQL Info"
}
},
"type": "value"
},
{
"options": {
"from": 1,
"result": {
"text": "CQL Warnings"
},
"to": 20
},
"type": "range"
}
]
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "rgb(87, 128, 193)",
"value": null
},
{
"color": "dark-orange",
"value": 1
}
]
}
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-text"
}
},
{
"id": "custom.align",
"value": "left"
},
{
"id": "displayName",
"value": "CQL"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #C"
},
"properties": [
{
"id": "links",
"value": [
{
"title": "OS Information Dashboard, an Error indicates there are OS related errors",
"url": "/d/OS-[[dash_version]]/os-metrics?refresh=30s&orgId=1&var-by=instance&var-node=${__data.fields[0]}&from=${__from}&to=${__to}"
}
]
},
{
"id": "custom.width",
"value": 90
},
{
"id": "custom.filterable",
"value": true
},
{
"id": "mappings",
"value": [
{
"options": {
"0": {
"text": "OS Info"
}
},
"type": "value"
},
{
"options": {
"from": 0,
"result": {
"text": "OS Errors"
},
"to": 100000
},
"type": "range"
}
]
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "rgb(87, 128, 193)",
"value": null
},
{
"color": "dark-orange",
"value": 0.001
}
]
}
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-text"
}
},
{
"id": "custom.align",
"value": "left"
},
{
"id": "displayName",
"value": "OS"
}
]
},
{
"matcher": {
"id": "byName",
"options": "Value #D"
},
"properties": [
{
"id": "links",
"value": [
{
"title": "Cordinator and Replica node errors",
"url": "/d/detailed-[[dash_version]]/detailed?refresh=30s&orgId=1&var-by=instance&var-node=${__data.fields[0]}&from=${__from}&to=${__to}"
}
]
},
{
"id": "custom.width",
"value": 80
},
{
"id": "custom.filterable",
"value": true
},
{
"id": "mappings",
"value": [
{
"options": {
"0": {
"text": ""
},
"1": {
"text": "Errors"
}
},
"type": "value"
}
]
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "rgb(87, 128, 193)",
"value": null
},
{
"color": "dark-orange",
"value": 0.001
}
]
}
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-text"
}
},
{
"id": "custom.align",
"value": "left"
},
{
"id": "displayName",
"value": " "
}
]
},
{
"dashversion": [
">5.1",
">2022.2"
],
"matcher": {
"id": "byName",
"options": "Value #F"
},
"properties": [
{
"id": "links",
"value": [
{
"title": "How many live nodes this node sees",
"url": "/d/detailed-[[dash_version]]/detailed?refresh=30s&orgId=1&var-by=instance&var-node=${__data.fields[0]}&from=${__from}&to=${__to}"
}
]
},
{
"id": "custom.width",
"value": 80
},
{
"id": "custom.filterable",
"value": true
},
{
"id": "custom.cellOptions",
"value": {
"type": "color-text"
}
},
{
"id": "custom.align",
"value": "left"
},
{
"id": "displayName",
"value": "Live"
}
]
},
{
"matcher": {
"id": "byName",
"options": "instance"
},
"properties": [
{
"id": "links",
"value": [
{
"title": "Detailed view",
"url": "/d/detailed-[[dash_version]]/detailed?refresh=30s&orgId=1&var-by=instance&var-node=${__data.fields[0]}&from=${__from}&to=${__to}"
}
]
}
]
},
{
"dashversion": [
">5.2",
">2023.1"
],
"matcher": {
"id": "byName",
"options": "Value #G"
},
"properties": [
{
"id": "custom.cellOptions",
"value": {
"mode": "lcd",
"type": "gauge"
}
},
{
"id": "min",
"value": 0
},
{
"id": "max",
"value": 101
},
{
"id": "displayName",
"value": "Streaming"
},
{
"id": "custom.width",
"value": 90
},
{
"id": "custom.filterable",
"value": false
},
{
"id": "decimals",
"value": 0
},
{
"id": "thresholds",
"value": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
}
}
]
}
]
},
"gridPos": {
"h": 17,
"w": 10,
"x": 14,
"y": 43
},
"id": 28,
"options": {
"cellHeight": "sm",
"footer": {
"countRows": false,
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"showHeader": true
},
"pluginVersion": "9.5.5",
"span": 8,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "0*scylla_scylladb_current_version{cluster=~\"$cluster|$^\", dc=~\"$dc\"} + on (instance) group_left() scylla_node_operation_mode{cluster=~\"$cluster|$^\", dc=~\"$dc\"}",
"format": "table",
"hide": false,
"instant": true,
"interval": "",
"intervalFactor": 1,
"legendFormat": "",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(scylla_reactor_utilization{cluster=~\"$cluster\", dc=~\"$dc\"} ) by (instance)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "sum(rate(scylla_reactor_aio_errors{cluster=~\"$cluster\", dc=~\"$dc\"}[1m])) by (instance)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "C"
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "sum(scylla_errors:nodes_total{cluster=~\"$cluster\", dc=~\"$dc\"}) by (instance) >bool 0",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "D"
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "(sum(scylla_cql:non_system_prepared1m{cluster=~\"$cluster\", dc=~\"$dc\"}) by (instance) >bool 1) + (sum(rate(scylla_cql_reverse_queries{cluster=~\"$cluster\", dc=~\"$dc\"}[60s])) by(instance) >bool 1) + (sum(scylla_cql:non_paged_no_system1m{cluster=~\"$cluster\", dc=~\"$dc\"}) by (instance) >bool 1)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "E"
},
{
"dashversion": [
">5.1",
">2022.2"
],
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "sum(scylla_gossip_live{cluster=~\"$cluster|$^\"})by (instance)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "F"
},
{
"dashversion": [
">5.2",
">2023.1"
],
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "(min(scylla_streaming_finished_percentage{cluster=~\"$cluster|$^\", dc=~\"$dc\"}*100) by (instance) < 100) or on (instance) 0*sum(scylla_scylladb_current_version{cluster=~\"$cluster|$^\", dc=~\"$dc\"}) by (instance)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "G"
}
],
"title": "Nodes",
"transformations": [
{
"id": "filterFieldsByName",
"options": {
"include": {
"names": [
"instance",
"svr",
"Value #A",
"Value #B",
"Value #C",
"Value #D",
"Value #E",
"Value #F",
"Value #G"
]
}
}
},
{
"id": "seriesToColumns",
"options": {
"byField": "instance"
}
},
{
"id": "organize",
"options": {
"excludeByName": {},
"indexByName": {
"Value #A": 5,
"Value #B": 7,
"Value #C": 3,
"Value #D": 1,
"Value #E": 2,
"Value #F": 6,
"Value #G": 8,
"instance": 0,
"svr": 4
},
"renameByName": {}
}
}
],
"type": "table"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Write attempts - include all writes that reached the coordinator node, even if they will eventually fail",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 6,
"x": 0,
"y": 49
},
"id": 29,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{
"alias": "1 Day Ago",
"dashLength": 4,
"dashes": true
},
{
"alias": "1 Week Ago",
"dashLength": 2,
"dashes": true
}
],
"span": 3,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_storage_proxy_coordinator_write_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) by ([[by]]) or on([[by]]) $func(rate(scylla_storage_proxy_coordinator_write_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "Writes",
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_storage_proxy_coordinator_write_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m] offset 1d)) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_write_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m] offset 1d))",
"interval": "",
"intervalFactor": 1,
"legendFormat": "1 Day Ago",
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_storage_proxy_coordinator_write_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m] offset 1w)) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_write_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m] offset 1w))",
"interval": "",
"intervalFactor": 1,
"legendFormat": "1 Week Ago",
"refId": "C",
"step": 1
}
],
"title": "Writes",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 6,
"y": 49
},
"id": 30,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(wlatencyp95{by=\"[[by]]\", instance=~\"[[node]]|^$\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]|$^\",scheduling_group_name=~\"$sg\"}>0) by ([[by]],sg)",
"intervalFactor": 1,
"legendFormat": "95% {{[[by]]}}",
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(wlatencyp99{by=\"[[by]]\", instance=~\"[[node]]|^$\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]|$^\",scheduling_group_name=~\"$sg\"}>0) by ([[by]],sg)",
"intervalFactor": 1,
"legendFormat": "99% {{[[by]]}}",
"refId": "B",
"step": 1
}
],
"title": "Write Latencies",
"type": "timeseries"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Requests that Scylla tried to write but timed out. Timeouts are counted in the node that received the request (the coordinator), not at the replicas.",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 10,
"y": 49
},
"id": 31,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_storage_proxy_coordinator_write_timeouts{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]|$^\"}[1m])) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "Writes {{[[by]]}}",
"refId": "A",
"step": 10
}
],
"title": "Write Timeouts by [[by]]",
"type": "timeseries"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Read attempts - include all reads that reached the coordinator node, even if they will eventually fail",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 6,
"x": 0,
"y": 55
},
"id": 32,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{
"alias": "1 Day Ago",
"dashLength": 4,
"dashes": true
},
{
"alias": "1 Week Ago",
"dashLength": 2,
"dashes": true
}
],
"span": 3,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_storage_proxy_coordinator_read_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\",scheduling_group_name=~\"$sg\"}[1m])) by ([[by]]) or on([[by]]) $func(rate(scylla_storage_proxy_coordinator_read_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\",scheduling_group_name=~\"$sg\"}[1m])) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "Reads",
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_storage_proxy_coordinator_read_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\",scheduling_group_name=~\"$sg\"}[1m] offset 1d)) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_read_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\",scheduling_group_name=~\"$sg\"}[1m] offset 1d))",
"intervalFactor": 1,
"legendFormat": "1 Day Ago",
"refId": "B",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_storage_proxy_coordinator_read_latency_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\",scheduling_group_name=~\"$sg\"}[1m] offset 1w)) or on ([[by]]) $func(rate(scylla_storage_proxy_coordinator_read_latency_summary_count{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\",scheduling_group_name=~\"$sg\"}[1m] offset 1w))",
"intervalFactor": 1,
"legendFormat": "1 Week Ago",
"refId": "C",
"step": 1
}
],
"title": "Reads",
"type": "timeseries"
},
{
"class": "us_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "µs"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 6,
"y": 55
},
"id": 33,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(rlatencyp95{by=\"[[by]]\", instance=~\"[[node]]|^$\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]|$^\",scheduling_group_name=~\"$sg\"}>0) by([[by]])",
"intervalFactor": 1,
"legendFormat": "95% {{[[by]]}}",
"refId": "A",
"step": 1
},
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "avg(rlatencyp99{by=\"[[by]]\", instance=~\"[[node]]|^$\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]|$^\",scheduling_group_name=~\"$sg\"}>0) by([[by]])",
"intervalFactor": 1,
"legendFormat": "99% {{[[by]]}}",
"refId": "B",
"step": 1
}
],
"title": "Read Latencies",
"type": "timeseries"
},
{
"class": "ops_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "Requests that Scylla tried to read but timed out. Timeouts are counted in the node that received the request (the coordinator), not at the replicas.",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 4,
"x": 10,
"y": 55
},
"id": 34,
"isNew": true,
"legend": {
"alignAsTable": false,
"avg": false,
"class": "show_legend",
"current": false,
"max": false,
"min": false,
"rightSide": false,
"show": true,
"total": false,
"values": false
},
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 2,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "$func(rate(scylla_storage_proxy_coordinator_read_timeouts{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])+rate(scylla_storage_proxy_coordinator_cas_read_timeouts{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])+rate(scylla_storage_proxy_coordinator_range_timeouts{instance=~\"[[node]]\",cluster=~\"$cluster|$^\", dc=~\"$dc\", shard=~\"[[shard]]\"}[1m])) by ([[by]])",
"intervalFactor": 1,
"legendFormat": "Read {{[[by]]}}",
"refId": "A",
"step": 10
}
],
"title": "Read Timeouts by [[by]]",
"type": "timeseries"
},
{
"class": "plain_text",
"dashproductreject": "no-version-check",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 1,
"w": 10,
"x": 14,
"y": 60
},
"id": 35,
"isNew": true,
"links": [],
"mode": "html",
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<img src=\"https://repositories.scylladb.com/scylla/imgversion/$all_scyllas_versions/scylla\"></img>",
"mode": "html"
},
"pluginVersion": "9.5.5",
"span": 12,
"style": {},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"transparent": true,
"type": "text"
},
{
"class": "plain_text",
"dashproduc": "no-version-check",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 1,
"w": 10,
"x": 14,
"y": 61
},
"id": 36,
"isNew": true,
"links": [],
"mode": "html",
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "",
"mode": "html"
},
"pluginVersion": "9.5.5",
"span": 12,
"style": {},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"transparent": true,
"type": "text"
},
{
"collapsed": false,
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 62
},
"id": 37,
"panels": [],
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"type": "row"
},
{
"class": "plain_text",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 2,
"w": 24,
"x": 0,
"y": 63
},
"id": 38,
"isNew": true,
"links": [],
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<h1 style=\"color:#5780C1; border-bottom: 3px solid #5780C1;\">Advisor</h1>",
"mode": "html"
},
"pluginVersion": "9.5.5",
"span": 12,
"style": {},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"transparent": true,
"type": "text"
},
{
"class": "advisor_table",
"dashversion": ">4.1",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"fieldConfig": {
"defaults": {
"custom": {
"align": "auto",
"cellOptions": {
"type": "auto"
},
"filterable": false,
"inspect": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "dashboard"
},
"properties": [
{
"id": "links",
"value": [
{
"title": "",
"url": "/d/${__data.fields.dashboard}-[[dash_version]]?refresh=30s&orgId=1&var-by=instance&from=${__from}&to=${__to}"
}
]
},
{
"id": "custom.width",
"value": 100
}
]
},
{
"matcher": {
"id": "byName",
"options": "advisor"
},
"properties": [
{
"id": "custom.width",
"value": 120
},
{
"id": "displayName",
"value": "Category"
}
]
},
{
"matcher": {
"id": "byName",
"options": "severity"
},
"properties": [
{
"id": "links",
"value": [
{
"targetBlank": true,
"title": "Open an issue",
"url": "https://github.com/scylladb/scylla/issues/new?body=description%3D${__data.fields[4]}%0ASource%3DAdvisor%0AScylla-versions%3D${all_scyllas_versions}%0Ascylla-monitoring%3D${monitoring_version}%0Acluster%3D${count_dc}%0Aname%3D${cluster}%0A%0A<!--%0ATo help us understand the issue, please upload a copy of your metrics to our secure location.%0AYou can read about it here: https://docs.scylladb.com/troubleshooting/report_scylla_problem/%0A%0AYou can use the upload_report.sh utility that is part of scylla-monitoring stack.%0AMake sure to include the UUID you got from the utility in this issue.%0A-->"
}
]
},
{
"id": "mappings",
"value": [
{
"options": {
"from": 0,
"result": {
"text": "🔔"
},
"to": 10
},
"type": "range"
}
]
},
{
"id": "displayName",
"value": "Report"
},
{
"id": "custom.width",
"value": 65
}
]
},
{
"matcher": {
"id": "byName",
"options": "summary"
},
"properties": [
{
"id": "links",
"value": [
{
"targetBlank": true,
"title": "${__data.fields.description}\n\n click for more information",
"url": "https://monitoring.docs.scylladb.com/branch-4.4/use-monitoring/advisor/${__data.fields.alertname}"
}
]
}
]
},
{
"matcher": {
"id": "byName",
"options": "alertname"
},
"properties": [
{
"id": "displayName",
"value": "."
},
{
"id": "custom.width",
"value": 1
}
]
},
{
"matcher": {
"id": "byName",
"options": "description"
},
"properties": [
{
"id": "displayName",
"value": "."
},
{
"id": "custom.width",
"value": 1
}
]
},
{
"matcher": {
"id": "byName",
"options": "Time"
},
"properties": [
{
"id": "custom.width",
"value": 150
}
]
}
]
},
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 65
},
"id": 39,
"links": [],
"options": {
"cellHeight": "sm",
"footer": {
"countRows": false,
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"showHeader": true
},
"pluginVersion": "9.5.5",
"targets": [
{
"active": true,
"annotations": true,
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"expr": "ALERTS{advisor!=\"\"}",
"instant": true,
"legendFormat": "__auto",
"range": false,
"refId": "A",
"target": "Query"
}
],
"transformations": [
{
"id": "labelsToFields",
"options": {}
},
{
"id": "merge",
"options": {}
},
{
"id": "filterFieldsByName",
"options": {
"include": {
"names": [
"advisor",
"dashboard",
"description",
"severity",
"alertname",
"summary",
"Time"
]
}
}
},
{
"id": "organize",
"options": {
"excludeByName": {},
"indexByName": {
"Time": 1,
"advisor": 2,
"dashboard": 3,
"severity": 0,
"summary": 4
},
"renameByName": {}
}
}
],
"type": "table"
},
{
"class": "collapsible_row_panel",
"collapsed": false,
"dashproductreject": "no-your-pannels",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 71
},
"id": 40,
"panels": [],
"repeat": "",
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"title": "Your panels",
"type": "row"
},
{
"class": "plain_text",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 2,
"w": 24,
"x": 0,
"y": 72
},
"id": 41,
"isNew": true,
"links": [],
"mode": "html",
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<h1 style=\"color:#5780C1; border-bottom: 3px solid #5780C1;\">Your Panels</h1>",
"mode": "html"
},
"pluginVersion": "9.5.5",
"span": 12,
"style": {},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"transparent": true,
"type": "text"
},
{
"class": "user_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "This graph panel was left empty on purpose for ad-hoc usage. Change it when needed. Pay attention that changes to the panel will not be saved.\n\nIf you do need a panel that can be saved, create a new dashboard, or edit the panel inside the json file",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 74
},
"id": 42,
"isNew": true,
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 6,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"refId": "A"
}
],
"title": "Your Graph here",
"type": "timeseries"
},
{
"class": "user_panel",
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"description": "This graph panel was left empty on purpose for ad-hoc usage. Change it when needed. Pay attention that changes to the panel will not be saved.\n\nIf you do need a panel that can be saved, create a new dashboard, or edit the panel inside the json file",
"editable": true,
"error": false,
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "si:ops/s"
},
"overrides": []
},
"gridPos": {
"h": 6,
"w": 12,
"x": 12,
"y": 74
},
"id": 43,
"isNew": true,
"links": [],
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "multi",
"sort": "asc"
}
},
"seriesOverrides": [
{}
],
"span": 6,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"refId": "A"
}
],
"title": "Your Graph here",
"type": "timeseries"
},
{
"class": "plain_text",
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"editable": true,
"error": false,
"gridPos": {
"h": 3,
"w": 24,
"x": 0,
"y": 80
},
"id": 44,
"isNew": true,
"links": [],
"mode": "html",
"options": {
"code": {
"language": "plaintext",
"showLineNumbers": false,
"showMiniMap": false
},
"content": "<div style=\"color:#5780C1; border-bottom: 0px solid #5780C1;\">Scylla Monitoring version - 4.4.2</div> <div style=\"\"><a href=\"https://github.com/scylladb/scylla-monitoring/issues/new?body=scylla-version%3D[[scylla_version]]%0Amonitoring-version%3D[[monitoring_version]]%0Adashboard%3D${__dashboard.uid}\" target=\"_blank\">\n<input title=\"Report an issue with Scylla Monitoring\" type=\"button\" style=\"background-color:#306EE6;color:white;border-radius: 15px;font-size:14px;line-height:22px;padding:2px\" value=\"&nbsp;Report an issue on this page&nbsp;\"></a>&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"/render/d/${__dashboard.uid}?orgId=1&from=${__from}&to=${__to}&width=1600&height=-1\" target=\"_blank\" download=\"dashboard_${__dashboard.uid}-${__from:date:iso}.png\"><input title=\"Make a Screenshot\" type=\"button\" style=\"background-color:#306EE6;color:white;border-radius: 15px;font-size:14px;line-height:22px;padding:2px\" value=\"&nbsp;&nbsp;&nbsp;Screenshot&nbsp;&nbsp;&nbsp;\"></input></a></span></div>",
"mode": "html"
},
"pluginVersion": "9.5.5",
"span": 12,
"style": {},
"targets": [
{
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"refId": "A"
}
],
"transparent": true,
"type": "text"
}
],
"refresh": "30s",
"schemaVersion": 38,
"style": "dark",
"tags": [
"5.2"
],
"templating": {
"list": [
{
"class": "by_template_var",
"current": {
"tags": [],
"text": "DC",
"value": "dc"
},
"hide": 0,
"includeAll": false,
"label": "by",
"multi": false,
"name": "by",
"options": [
{
"selected": false,
"text": "Cluster",
"value": "cluster"
},
{
"selected": true,
"text": "DC",
"value": "dc"
},
{
"selected": false,
"text": "Instance",
"value": "instance"
},
{
"selected": false,
"text": "instance,shard",
"value": "instance,shard"
}
],
"query": "Cluster,DC,Instance,Shard",
"skipUrlSync": false,
"type": "custom"
},
{
"class": "template_variable_single",
"current": {
"isNone": true,
"selected": false,
"text": "None",
"value": ""
},
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"definition": "",
"hide": 0,
"includeAll": false,
"label": "cluster",
"multi": false,
"name": "cluster",
"options": [],
"query": "label_values(scylla_reactor_utilization, cluster)",
"refresh": 2,
"regex": "",
"skipUrlSync": false,
"sort": 1,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
},
{
"allValue": ".*",
"class": "template_variable_all",
"current": {
"selected": true,
"text": [
"All"
],
"value": [
"$__all"
]
},
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"definition": "",
"hide": 0,
"includeAll": true,
"label": "dc",
"multi": true,
"name": "dc",
"options": [],
"query": "label_values(scylla_reactor_utilization{cluster=~\"$cluster\"}, dc)",
"refresh": 2,
"regex": "",
"skipUrlSync": false,
"sort": 1,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
},
{
"allValue": ".*",
"class": "template_variable_all",
"current": {
"selected": true,
"text": [
"All"
],
"value": [
"$__all"
]
},
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"definition": "",
"hide": 0,
"includeAll": true,
"label": "node",
"multi": true,
"name": "node",
"options": [],
"query": "label_values(scylla_reactor_utilization{cluster=~\"$cluster|$^\", dc=~\"$dc\"}, instance)",
"refresh": 2,
"regex": "",
"skipUrlSync": false,
"sort": 1,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
},
{
"allValue": ".+",
"class": "template_variable_all",
"current": {
"selected": true,
"text": [
"All"
],
"value": [
"$__all"
]
},
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"definition": "",
"hide": 0,
"includeAll": true,
"label": "shard",
"multi": true,
"name": "shard",
"options": [],
"query": "label_values(scylla_reactor_utilization{cluster=~\"$cluster|$^\"},shard)",
"refresh": 2,
"regex": "",
"skipUrlSync": false,
"sort": 3,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
},
{
"class": "template_variable_single",
"current": {
"selected": false,
"text": "/var/lib/scylla",
"value": "/var/lib/scylla"
},
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"definition": "",
"hide": 0,
"includeAll": false,
"label": "Mount path",
"multi": false,
"name": "mount_point",
"options": [],
"query": "node_filesystem_avail_bytes",
"refresh": 2,
"regex": "/mountpoint=\"([^\"]*)\".*/",
"skipUrlSync": false,
"sort": 0,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
},
{
"class": "template_variable_single",
"current": {
"selected": false,
"text": "All",
"value": "$__all"
},
"dashversion": [
">4.3"
],
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"definition": "",
"hide": 0,
"includeAll": true,
"label": "SG",
"multi": true,
"name": "sg",
"options": [],
"query": "label_values(rlatencyp99{cluster=~\"$cluster\", scheduling_group_name!~\"atexit|gossip|mem_compaction|memtable|streaming|background_reclaim|compaction|main|memtable_to_cache\"},scheduling_group_name)",
"refresh": 2,
"regex": "",
"skipUrlSync": false,
"sort": 3,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
},
{
"class": "aggregation_function",
"current": {
"tags": [],
"text": "sum",
"value": "sum"
},
"hide": 0,
"includeAll": false,
"label": "Function",
"multi": false,
"name": "func",
"options": [
{
"selected": true,
"text": "sum",
"value": "sum"
},
{
"selected": false,
"text": "avg",
"value": "avg"
},
{
"selected": false,
"text": "max",
"value": "max"
},
{
"selected": false,
"text": "min",
"value": "min"
},
{
"selected": false,
"text": "stddev",
"value": "stddev"
},
{
"selected": false,
"text": "stdvar",
"value": "stdvar"
}
],
"query": "sum,avg,max,min,stddev,stdvar",
"skipUrlSync": false,
"type": "custom"
},
{
"class": "template_variable_custom",
"current": {
"text": "5-2",
"value": "5-2"
},
"hide": 2,
"includeAll": false,
"multi": false,
"name": "dash_version",
"options": [
{
"selected": true,
"text": "5-2",
"value": "5-2"
}
],
"query": "5-2",
"skipUrlSync": false,
"type": "custom"
},
{
"allValue": ".*",
"class": "template_variable_all",
"current": {
"selected": true,
"text": [
"All"
],
"value": [
"$__all"
]
},
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"definition": "",
"hide": 2,
"includeAll": true,
"multi": true,
"name": "all_scyllas_versions",
"options": [],
"query": "label_values(scylla_scylladb_current_version{cluster=~\"$cluster|$^\"}, version)",
"refresh": 2,
"regex": "",
"skipUrlSync": false,
"sort": 1,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
},
{
"allValue": ".*",
"class": "template_variable_all",
"current": {
"selected": true,
"text": [
"All"
],
"value": [
"$__all"
]
},
"datasource": {
"type": "prometheus",
"uid": "P1809F7CD0C75ACF3"
},
"definition": "query_result(count(up{job=\"scylla\"}) by (dc))",
"hide": 2,
"includeAll": true,
"multi": true,
"name": "count_dc",
"options": [],
"query": {
"query": "query_result(count(up{job=\"scylla\"}) by (dc))",
"refId": "StandardVariableQuery"
},
"refresh": 2,
"regex": "/(?<dc>\\{dc=\"[^\"]+\".* \\d+) .*/",
"skipUrlSync": false,
"sort": 1,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
},
{
"class": "template_variable_custom",
"current": {
"text": "5.2",
"value": "5.2"
},
"hide": 2,
"includeAll": false,
"multi": false,
"name": "scylla_version",
"options": [
{
"selected": true,
"text": "5.2",
"value": "5.2"
}
],
"query": "5.2",
"skipUrlSync": false,
"type": "custom"
},
{
"class": "monitor_version_var",
"current": {
"text": "4.4.2",
"value": "4.4.2"
},
"hide": 2,
"includeAll": false,
"multi": false,
"name": "monitoring_version",
"options": [
{
"selected": true,
"text": "4.4.2",
"value": "4.4.2"
}
],
"query": "4.4.2",
"skipUrlSync": false,
"type": "custom"
}
]
},
"time": {
"from": "now-1h",
"to": "now"
},
"timepicker": {
"now": true,
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
],
"time_options": [
"5m",
"15m",
"1h",
"6h",
"12h",
"24h",
"2d",
"7d",
"30d"
]
},
"timezone": "utc",
"title": "Overview",
"uid": "overview-5-2",
"version": 11,
"weekStart": ""
}
sl-demo-dash-v3.json
Displaying sl-demo-dash-v3.json.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment