[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-grid5k] 67/73: update dashboards
|
From: |
gnunet |
|
Subject: |
[taler-grid5k] 67/73: update dashboards |
|
Date: |
Tue, 14 Dec 2021 15:10:49 +0100 |
This is an automated email from the git hooks/post-receive script.
marco-boss pushed a commit to branch master
in repository grid5k.
commit 65e72ca2dac85a0c48c83ded9782389c48b611b8
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Sat Dec 11 21:47:00 2021 +0100
update dashboards
---
additional/grafana/database.json | 68 ++++++++++++++----------------
additional/grafana/load-statistics.json | 16 +++----
additional/grafana/logs.json | 2 +-
additional/grafana/request-statistics.json | 15 ++++---
additional/grafana/transactions.json | 27 ++++++------
5 files changed, 59 insertions(+), 69 deletions(-)
diff --git a/additional/grafana/database.json b/additional/grafana/database.json
index b61f320..eb488b0 100644
--- a/additional/grafana/database.json
+++ b/additional/grafana/database.json
@@ -92,7 +92,7 @@
"gnetId": 6742,
"graphTooltip": 1,
"id": null,
- "iteration": 1639246632570,
+ "iteration": 1639255444197,
"links": [],
"liveNow": false,
"panels": [
@@ -1441,7 +1441,7 @@
},
{
"datasource": null,
- "description": "",
+ "description": "Number of serialization errors by request endpoint
(type) since the last exchange restarts",
"fieldConfig": {
"defaults": {
"color": {
@@ -1503,7 +1503,7 @@
},
{
"datasource": null,
- "description": "",
+ "description": "Number of serialization errors per request since the
last exchange restarts",
"fieldConfig": {
"defaults": {
"color": {
@@ -1522,7 +1522,7 @@
}
],
"thresholds": {
- "mode": "percentage",
+ "mode": "absolute",
"steps": [
{
"color": "text",
@@ -1530,7 +1530,7 @@
},
{
"color": "red",
- "value": 1
+ "value": 2
}
]
},
@@ -1576,7 +1576,7 @@
},
{
"datasource": null,
- "description": "",
+ "description": "Total number of serialization errors that happened since
last exchange restarts",
"fieldConfig": {
"defaults": {
"color": {
@@ -1634,7 +1634,7 @@
},
{
"datasource": "${DS_LOKI}",
- "description": "Number of queries which took longer than the configured
duration in postgresql.conf",
+ "description": "Number of queries which took longer than the configured
duration",
"fieldConfig": {
"defaults": {
"color": {
@@ -1717,24 +1717,12 @@
{
"matcher": {
"id": "byName",
- "options": "Query"
+ "options": "Count"
},
"properties": [
{
"id": "custom.width",
- "value": 1791
- }
- ]
- },
- {
- "matcher": {
- "id": "byName",
- "options": "query"
- },
- "properties": [
- {
- "id": "custom.width",
- "value": 1802
+ "value": 100
}
]
}
@@ -1755,18 +1743,14 @@
"pluginVersion": "8.2.5",
"targets": [
{
- "expr": "{app=\"taler-database\"} |~ \"011Query Text:\" | regexp
\".*011Query Text: (?P<query>.*)\"",
- "instant": false,
- "range": true,
+ "expr": "sum by (query) (count_over_time({app=\"taler-database\"} |~
\"011Query Text:\" | regexp \".*011Query Text: (?P<query>.*)\" [$__range]))",
+ "instant": true,
+ "range": false,
"refId": "A"
}
],
"title": "Slow Queries",
"transformations": [
- {
- "id": "labelsToFields",
- "options": {}
- },
{
"id": "groupBy",
"options": {
@@ -1777,6 +1761,18 @@
],
"operation": "groupby"
},
+ "Value": {
+ "aggregations": [
+ "lastNotNull"
+ ],
+ "operation": "aggregate"
+ },
+ "Value #A": {
+ "aggregations": [
+ "lastNotNull"
+ ],
+ "operation": "aggregate"
+ },
"app": {
"aggregations": [
"count"
@@ -1790,18 +1786,16 @@
}
}
},
- {
- "id": "merge",
- "options": {}
- },
{
"id": "organize",
"options": {
"excludeByName": {},
"indexByName": {},
"renameByName": {
+ "Value #A (lastNotNull)": "Count",
+ "Value (lastNotNull)": "Count",
"app (count)": "Count",
- "query": ""
+ "query": "Query"
}
}
}
@@ -3461,7 +3455,7 @@
"type": "stat"
}
],
- "refresh": "30s",
+ "refresh": "1m",
"schemaVersion": 32,
"style": "dark",
"tags": [
@@ -3531,13 +3525,13 @@
"error": null,
"hide": 0,
"includeAll": false,
- "label": "server",
+ "label": "Server",
"multi": false,
"name": "server",
"options": [],
"query": {
"query": "label_values(pg_settings_array_nulls{}, server)",
- "refId": "StandardVariableQuery"
+ "refId": "Prometheus-server-Variable-Query"
},
"refresh": 1,
"regex": "",
@@ -3579,5 +3573,5 @@
"timezone": "",
"title": "Database",
"uid": "2FTtdeOnk",
- "version": 67
+ "version": 75
}
\ No newline at end of file
diff --git a/additional/grafana/load-statistics.json
b/additional/grafana/load-statistics.json
index 2e78a02..5e0f398 100644
--- a/additional/grafana/load-statistics.json
+++ b/additional/grafana/load-statistics.json
@@ -923,17 +923,13 @@
},
{
"id": "unit",
- "value": "SQ"
+ "value": "SQ/s"
},
{
"id": "custom.lineStyle",
"value": {
"fill": "solid"
}
- },
- {
- "id": "custom.drawStyle",
- "value": "bars"
}
]
}
@@ -970,7 +966,7 @@
},
{
"datasource": "${DS_LOKI}",
- "expr": "sum(count_over_time({app=\"taler-database\"} |~
\"duration:\" [30s]))",
+ "expr": "rate({app=\"taler-database\"} |~ \"duration:\" [1m])",
"hide": false,
"legendFormat": "Slow Queries",
"refId": "C"
@@ -1148,11 +1144,11 @@
},
{
"id": "unit",
- "value": "SQ"
+ "value": "SQ/s"
},
{
"id": "custom.drawStyle",
- "value": "bars"
+ "value": "line"
},
{
"id": "custom.lineStyle"
@@ -1188,7 +1184,7 @@
"resolution": 5
},
{
- "expr": "sum(count_over_time({app=\"taler-database\"} |~
\"duration:\" [30s]))",
+ "expr": "rate({app=\"taler-database\"} |~ \"duration:\" [1m])",
"hide": false,
"legendFormat": "Slow Queries",
"refId": "C",
@@ -1218,5 +1214,5 @@
"timezone": "",
"title": "Load Statistics",
"uid": "rkyhDAt7z",
- "version": 42
+ "version": 43
}
\ No newline at end of file
diff --git a/additional/grafana/logs.json b/additional/grafana/logs.json
index 87d4582..012b501 100644
--- a/additional/grafana/logs.json
+++ b/additional/grafana/logs.json
@@ -53,7 +53,7 @@
"gnetId": null,
"graphTooltip": 0,
"id": null,
- "iteration": 1639246839506,
+ "iteration": 1639255473609,
"links": [],
"liveNow": false,
"panels": [
diff --git a/additional/grafana/request-statistics.json
b/additional/grafana/request-statistics.json
index 355ac2e..82bd33a 100644
--- a/additional/grafana/request-statistics.json
+++ b/additional/grafana/request-statistics.json
@@ -60,7 +60,7 @@
"gnetId": null,
"graphTooltip": 1,
"id": null,
- "iteration": 1639250073225,
+ "iteration": 1639255499971,
"links": [],
"liveNow": false,
"panels": [
@@ -366,7 +366,7 @@
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
- "drawStyle": "bars",
+ "drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
@@ -407,7 +407,8 @@
"value": 10
}
]
- }
+ },
+ "unit": "SQ/s"
},
"overrides": []
},
@@ -430,11 +431,11 @@
},
"targets": [
{
- "expr": "sum(count_over_time({app=\"taler-database\"} |~
\"duration:\" [30s]))",
+ "expr": "rate({app=\"taler-database\"} |~ \"duration:\" [1m])",
"refId": "A"
}
],
- "title": "Slow Query Logs",
+ "title": "Slow Query Logs per Second",
"type": "timeseries"
},
{
@@ -1201,7 +1202,7 @@
"auto_count": 30,
"auto_min": "10s",
"current": {
- "selected": true,
+ "selected": false,
"text": "5m",
"value": "5m"
},
@@ -1355,5 +1356,5 @@
"timezone": "browser",
"title": "Request Statistics",
"uid": "WcfSXqDnk",
- "version": 121
+ "version": 122
}
\ No newline at end of file
diff --git a/additional/grafana/transactions.json
b/additional/grafana/transactions.json
index 716d402..69099bd 100644
--- a/additional/grafana/transactions.json
+++ b/additional/grafana/transactions.json
@@ -1693,18 +1693,18 @@
"type": "timeseries"
},
{
- "datasource": "${DS_LOKI}",
+ "datasource": null,
"description": "",
"fieldConfig": {
"defaults": {
"color": {
- "mode": "thresholds"
+ "mode": "palette-classic"
},
"custom": {
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
- "drawStyle": "bars",
+ "drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
@@ -1712,7 +1712,7 @@
"tooltip": false,
"viz": false
},
- "lineInterpolation": "smooth",
+ "lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
@@ -1736,13 +1736,9 @@
"color": "green",
"value": null
},
- {
- "color": "#EAB839",
- "value": 5
- },
{
"color": "red",
- "value": 10
+ "value": 80
}
]
}
@@ -1755,11 +1751,11 @@
"x": 10,
"y": 27
},
- "id": 36,
+ "id": 55,
"options": {
"legend": {
"calcs": [],
- "displayMode": "hidden",
+ "displayMode": "list",
"placement": "bottom"
},
"tooltip": {
@@ -1768,11 +1764,14 @@
},
"targets": [
{
- "expr": "sum(count_over_time({app=\"taler-database\"} |~
\"duration:\" [30s]))",
+ "exemplar": true,
+ "expr": "sum by (state)
(node_systemd_unit_state{name=~\"taler-exchange(.*)\"})",
+ "interval": "",
+ "legendFormat": "{{state}}",
"refId": "A"
}
],
- "title": "Slow Query Logs",
+ "title": "Exchanges over Time",
"type": "timeseries"
}
],
@@ -1794,5 +1793,5 @@
"timezone": "",
"title": "Transactions",
"uid": "83vvgKKnk",
- "version": 71
+ "version": 76
}
\ No newline at end of file
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
- [taler-grid5k] 62/73: fix monitor, (continued)
- [taler-grid5k] 62/73: fix monitor, gnunet, 2021/12/14
- [taler-grid5k] 49/73: monitor dns too, change db settings, gnunet, 2021/12/14
- [taler-grid5k] 59/73: fix taler-perf.sh, improve other scripts, gnunet, 2021/12/14
- [taler-grid5k] 56/73: fix startup, gnunet, 2021/12/14
- [taler-grid5k] 45/73: take postgres config to seperate file, gnunet, 2021/12/14
- [taler-grid5k] 38/73: speedup image build, gnunet, 2021/12/14
- [taler-grid5k] 40/73: document variables, gnunet, 2021/12/14
- [taler-grid5k] 70/73: update plotter README and dashboards, gnunet, 2021/12/14
- [taler-grid5k] 65/73: filter wallet getRecord messages - they spam the logs, gnunet, 2021/12/14
- [taler-grid5k] 51/73: add auto explain - not tested yet, gnunet, 2021/12/14
- [taler-grid5k] 67/73: update dashboards,
gnunet <=
- [taler-grid5k] 53/73: add more description about huge pages, gnunet, 2021/12/14
- [taler-grid5k] 71/73: remove unused rpecs and handled notes, gnunet, 2021/12/14
- [taler-grid5k] 69/73: update plotter script, gnunet, 2021/12/14
- [taler-grid5k] 72/73: add possibility to define grid5k repo branch for experiments, gnunet, 2021/12/14
- [taler-grid5k] 66/73: update dashboard exports, gnunet, 2021/12/14
- [taler-grid5k] 64/73: comment scripts and add help, gnunet, 2021/12/14
- [taler-grid5k] 73/73: scripts documented and commented, gnunet, 2021/12/14
- [taler-grid5k] 68/73: update grafana dashboards, add option for ram mount in db, gnunet, 2021/12/14